[U2] Permanent Software Engineer (PICK, Unidata, Universe)

2007-02-21 Thread Moderator
REPOSTED WITHOUT ENDORSEMENT FOR A NON-MEMBER: Apolito, Marc 
[EMAIL PROTECTED]

/(Note: Attachments are automatically stripped off)/

Opportunity in Northern, VA

Hello,

I'm reaching out to everyone regarding a permanent opportunity in Northern, VA 
for a Software Engineer with PICK database experience.  The job description is 
attached for your review.  Please forward to me your latest resume in Word 
format and contact me to discuss.

I look forward to speaking with you.

Regards,
Marc

Software Engineer.doc


Marc Apolito
Recruiter, Information Technology
Professional Services

The Mergis Group
A division of Spherion
Your Bridge for the Best Hire
1750 Tysons Blvd., Suite 260
McLean, VA  22102
703-917-1102
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
www.mergisgroup.com

[demime 1.01d removed an attachment of type application/msword which had a name 
of Software Engineer.doc]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Linux/Aix/Solaris DST testing script

2007-02-21 Thread Hennessey, Mark F.
Sun Bigamy has a Perl script that will kick the tires and check to see if your 
system is ready for the changes to DST (at least for those of us in the US...)


http://www.sun.com/bigadmin/scripts/submittedScripts/test_dst.txt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: Spam:[U2] Permanent Software Engineer (PICK, Unidata, Universe)

2007-02-21 Thread Jerry
I noticed that the job description must have been attached and stripped from 
the email, is there a site you can go to where there is a description of 
this job?


- Original Message - 
From: Moderator [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; 
[EMAIL PROTECTED]

Sent: Wednesday, February 21, 2007 5:57 AM
Subject: Spam:[U2] Permanent Software Engineer (PICK, Unidata, Universe)


REPOSTED WITHOUT ENDORSEMENT FOR A NON-MEMBER: Apolito, Marc 
[EMAIL PROTECTED]

/(Note: Attachments are automatically stripped off)/

Opportunity in Northern, VA

Hello,

I'm reaching out to everyone regarding a permanent opportunity in 
Northern, VA for a Software Engineer with PICK database experience.  The 
job description is attached for your review.  Please forward to me your 
latest resume in Word format and contact me to discuss.


I look forward to speaking with you.

Regards,
Marc

Software Engineer.doc


Marc Apolito
Recruiter, Information Technology
Professional Services

The Mergis Group
A division of Spherion
Your Bridge for the Best Hire
1750 Tysons Blvd., Suite 260
McLean, VA  22102
703-917-1102
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
www.mergisgroup.com

[demime 1.01d removed an attachment of type application/msword which had a 
name of Software Engineer.doc]

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Linux/Aix/Solaris DST testing script

2007-02-21 Thread Hennessey, Mark F.
snip
Sun Bigamy has a 
/snip

Damn *[EMAIL PROTECTED] auto-correct... That of course should be Big 
Admin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Search email archives

2007-02-21 Thread jjuser ud2

I will be happy to devote what time I can :)  I love website
maintenance, documentation, and other such tasks that most people
generally consider to be mundane.  What would I need to do to get
started with U2UG.org?  I'll be more than happy to help, and the
ability to search archives is a very important feature to have on a
mailing list homepage!

On 2/20/07, Charles Barouch [EMAIL PROTECTED] wrote:

JJ,
 Actually, U2Ug.org is maintained by volunteers. We spend a lot of
our time, for no pay, doing that. If you don't like the level of
service, roll up you sleeves and volunteer so we have the staff needed
to keep up with improvements. IndexFocus, Nabble, and others freely help
out by archiving. We didn't ask them to, but we appreciate it. You can
help, too.

- Charles Barouch

jjuser ud2 wrote:
 I don't understand.  If the archive searching isn't working with this
 index-in-focus thing, why don't they change it on the website to one
 that DOES work?  Doesn't anybody maintain u2ug.org?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Search email archives

2007-02-21 Thread Glen Batchelor
  Htsearch (htdig) is a Linux web page indexing and search utility, which
can be installed. Apparently, it's not installed on the machine running
mailman. What Linux distro is u2ug running?

---
Glen Batchelor
IT Director
All-Spec Industries
phone: (910) 332-0424
fax: (910) 763-5664
e-mail: [EMAIL PROTECTED]
---
www.allspec.com
---

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Charles Barouch
 Sent: Tuesday, February 20, 2007 9:48 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Search email archives
 
 JJ,
  Actually, U2Ug.org is maintained by volunteers. We spend a lot of
 our time, for no pay, doing that. If you don't like the level of
 service, roll up you sleeves and volunteer so we have the staff needed
 to keep up with improvements. IndexFocus, Nabble, and others freely help
 out by archiving. We didn't ask them to, but we appreciate it. You can
 help, too.
 
 - Charles Barouch
 
 jjuser ud2 wrote:
  I don't understand.  If the archive searching isn't working with this
  index-in-focus thing, why don't they change it on the website to one
  that DOES work?  Doesn't anybody maintain u2ug.org?
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: Spam:[U2] Permanent Software Engineer (PICK, Unidata, Universe)

2007-02-21 Thread Charles Barouch

Jerry,
   I'll ask Marc for a post-able description.

  - Chuck

Jerry wrote:
I noticed that the job description must have been attached and 
stripped from the email, is there a site you can go to where there is 
a description of this job?


- Original Message - From: Moderator [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; 
[EMAIL PROTECTED]

Sent: Wednesday, February 21, 2007 5:57 AM
Subject: Spam:[U2] Permanent Software Engineer (PICK, Unidata, Universe)


REPOSTED WITHOUT ENDORSEMENT FOR A NON-MEMBER: Apolito, Marc 
[EMAIL PROTECTED]

/(Note: Attachments are automatically stripped off)/

Opportunity in Northern, VA

Hello,

I'm reaching out to everyone regarding a permanent opportunity in 
Northern, VA for a Software Engineer with PICK database experience.  
The job description is attached for your review.  Please forward to 
me your latest resume in Word format and contact me to discuss.


I look forward to speaking with you.

Regards,
Marc

Software Engineer.doc


Marc Apolito
Recruiter, Information Technology
Professional Services

The Mergis Group
A division of Spherion
Your Bridge for the Best Hire
1750 Tysons Blvd., Suite 260
McLean, VA  22102
703-917-1102
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
www.mergisgroup.com

[demime 1.01d removed an attachment of type application/msword which 
had a name of Software Engineer.doc]

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniData 6.1.15

2007-02-21 Thread Bob Wyatt
Doing a sort from ECL/TCL, ECL Type P



Have a field that is a straight D-type dictionary item, multi-valued

PLINE

001: D

002: 6

003:

004:

005: 6R

006:

007:

008: VARCHAR2

009:

010: A!6!!!L!6

011:

012: }}

Value Type (6) is blank on purpose for this email



If I do SORT FILE WITH 26 OR WITH NO MATCH BY TYPE BY 26 BY L BY-EXP PLINE
BY INV_n_ ID-SUPP BREAK-ON TYPE 'P' BREAK-ON 26 BREAK-ON L INV-DATE CUST
CUST-NAME ORDER-NBR WHSE BREAK-ON PLINE TOTAL PROD-SUB TOTAL PROD-COST
GRAND-TOTAL TOTALS FOR MY LITTLE SHOP CO., INC. HEADING 'C'MY LITTLE SHOP
CO., INC. 'LC'NOT-SO-LITTLE MONTH-END REPORT AS OF 'D' 'L'PAGE 'PL'



   A   11/17/2006 123456 SOME COMPANY NA 432529VAL  04
134.90 101.17

04
24.44  18.32

04
37.64  28.22

04
12.22   9.16

**
-- --

04
209.20 156.87

04

04

04



If I change the dictionary item field 6 to M, then the report changes to:



   A   11/17/2006 123456 SOME COMPANY NA 432529VAL  04
134.90 101.17


24.44  18.32


37.64  28.22


12.22   9.16

   A   11/17/2006 123456 SOME COMPANY NA 432529VAL  04
134.90 101.17


24.44  18.32


37.64  28.22


12.22   9.16

   A   11/17/2006 123456 SOME COMPANY NA 432529VAL  04
134.90 101.17


24.44  18.32


37.64  28.22


12.22   9.16

   A   11/17/2006 123456 SOME COMPANY NA 432529VAL  04
134.90 101.17


24.44  18.32


37.64  28.22


12.22   9.16

**
-- --

04
836.80 627.48



The total from the first display is correct, although the display is
incorrect by repeating the 04 3 more times after the total

In the second, it reports the same company 4 times, and each time entails
all 4 multivalues



I should mention this was working, and I/we have no idea what changed to
break it



What simple thing have I missed



Bob Wyatt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV 10.0 XML

2007-02-21 Thread Bob Woodward
Hi folks,

I'm in the process of trying to merge data between two Universe systems.
The destination is a Windows 2003 server with UV 10.1.14 and the source
is a RedHat server with UV 10.0.20.  I'm wanting to pull the data out
into an XML file so it can be reviewed by a number of people in a number
of different way in a number of different systems.  Did I say number
of and different enough times?  Anyway, I've got dictionaries set and
was ready to rock and roll but I've finally figured out the key word
TO did not get added until UV 10.1.  I'm looking for a fast answer on
how to get the data into an external file that can be copied to all the
people wanting to review the incoming entries.

Sample line from TCL:  LIST PROD XF_1 TOXML TO PRODXML

UV 10.0.20 chokes with: RetrieVe: syntax error. Unexpected explicit item
id. Token was PRODXML.
  Scanned command was LIST PROD XF_1
TOXML TO 'PRODXML'

I don't know why it didn't choke on the TO command but if I take off TO
PRODXML then the proper data is displayed on the screen.

TIA

BobW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10.0 XML

2007-02-21 Thread Perry Taylor
Bob,

What if you run the command as a phantom then grab the PH file?

Perry Taylor
Zirmed, Inc. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Wednesday, February 21, 2007 6:45 PM
To: U2-Users List
Subject: [U2] UV 10.0 XML

Hi folks,

I'm in the process of trying to merge data between two Universe systems.
The destination is a Windows 2003 server with UV 10.1.14 and the source
is a RedHat server with UV 10.0.20.  I'm wanting to pull the data out
into an XML file so it can be reviewed by a number of people in a number
of different way in a number of different systems.  Did I say number
of and different enough times?  Anyway, I've got dictionaries set and
was ready to rock and roll but I've finally figured out the key word
TO did not get added until UV 10.1.  I'm looking for a fast answer on
how to get the data into an external file that can be copied to all the
people wanting to review the incoming entries.

Sample line from TCL:  LIST PROD XF_1 TOXML TO PRODXML

UV 10.0.20 chokes with: RetrieVe: syntax error. Unexpected explicit item
id. Token was PRODXML.
  Scanned command was LIST PROD XF_1
TOXML TO 'PRODXML'

I don't know why it didn't choke on the TO command but if I take off TO
PRODXML then the proper data is displayed on the screen.

TIA

BobW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10.0 XML

2007-02-21 Thread Bob Woodward
Further searching I ran into a posting from Brian Leach on Nabble that
gave me a good, quick, way of doing this.  His code snippet was:

0001: PA 
0002: TERM dumb 
0003: DIVERT.OUT ON UFD titles.xml TTY.OFF 
0004: SORT BOOK_TITLES TOXML ELEMENTS COUNT.SUP NOPAGE 
0005: DIVERT.OUT OFF TTY.ON 
0006: TERM vt100

Thanks Brian!!!

BobW
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Wednesday, February 21, 2007 3:45 PM
To: U2-Users List
Subject: [U2] UV 10.0 XML

Hi folks,

I'm in the process of trying to merge data between two Universe systems.
The destination is a Windows 2003 server with UV 10.1.14 and the source
is a RedHat server with UV 10.0.20.  I'm wanting to pull the data out
into an XML file so it can be reviewed by a number of people in a number
of different way in a number of different systems.  Did I say number
of and different enough times?  Anyway, I've got dictionaries set and
was ready to rock and roll but I've finally figured out the key word
TO did not get added until UV 10.1.  I'm looking for a fast answer on
how to get the data into an external file that can be copied to all the
people wanting to review the incoming entries.

Sample line from TCL:  LIST PROD XF_1 TOXML TO PRODXML

UV 10.0.20 chokes with: RetrieVe: syntax error. Unexpected explicit item
id. Token was PRODXML.
  Scanned command was LIST PROD XF_1
TOXML TO 'PRODXML'

I don't know why it didn't choke on the TO command but if I take off TO
PRODXML then the proper data is displayed on the screen.

TIA

BobW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Using CONV in XML output string

2007-02-21 Thread Boydell, Stuart
I'm constructing a LIST TOXML sentence on the fly. Does anyone know if
you can combine two CONV modifiers on a TCL line? I'm extracting data
which needs to meet length criteria (T100) and also needs to ensure that
all the characters are printable (MCP).

Eg LIST TEMP ID.SUP @ID AS ProductID F1 AS Description CONV T100 CONV
MCP TOXML

Cheers,
Stuart Boydell



**
This email message and any files transmitted with it are confidential and
intended solely for the use of addressed recipient(s). If you have received
this communication in error, please reply to this e-mail to notify the sender
of its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and defects
before opening or sending them on. Spotless collects information about you to
provide and market our services. For information about use, disclosure and
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10.0 XML

2007-02-21 Thread Bob Woodward
Thanks, Perry.  That was a possiblility but I was wanting to keep that
as a last resort.

BobW
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Wednesday, February 21, 2007 4:30 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV 10.0 XML

Bob,

What if you run the command as a phantom then grab the PH file?

Perry Taylor
Zirmed, Inc. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Wednesday, February 21, 2007 6:45 PM
To: U2-Users List
Subject: [U2] UV 10.0 XML

Hi folks,

I'm in the process of trying to merge data between two Universe systems.
The destination is a Windows 2003 server with UV 10.1.14 and the source
is a RedHat server with UV 10.0.20.  I'm wanting to pull the data out
into an XML file so it can be reviewed by a number of people in a number
of different way in a number of different systems.  Did I say number
of and different enough times?  Anyway, I've got dictionaries set and
was ready to rock and roll but I've finally figured out the key word
TO did not get added until UV 10.1.  I'm looking for a fast answer on
how to get the data into an external file that can be copied to all the
people wanting to review the incoming entries.

Sample line from TCL:  LIST PROD XF_1 TOXML TO PRODXML

UV 10.0.20 chokes with: RetrieVe: syntax error. Unexpected explicit item
id. Token was PRODXML.
  Scanned command was LIST PROD XF_1
TOXML TO 'PRODXML'

I don't know why it didn't choke on the TO command but if I take off TO
PRODXML then the proper data is displayed on the screen.

TIA

BobW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited. ZirMed, Inc. has strict
policies regarding the content of e-mail communications, specifically
Protected Health Information, any communications containing such
material will be returned to the originating party with such advisement
noted. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10.0 XML

2007-02-21 Thread Boydell, Stuart
Bob,
Have a look at DIVERT.OUT.

PA
DIVERT.OUT ON EXPORTS PRODXML TTY.OFF
LIST PROD XF_1 TOXML
DIVERT.OUT OFF

HTH
Stuart


-Original Message-
I'm looking for a fast answer on
how to get the data into an external file that can be copied to all the
people wanting to review the incoming entries.

Sample line from TCL:  LIST PROD XF_1 TOXML TO PRODXML

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Using CONV in XML output string

2007-02-21 Thread Womack, Adrian
I just tried this out - and it does let you use multiple CONVS one after
the other. BUT, I would normally use FMT L#100 rather than CONV
T100.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, 22 February 2007 10:56 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Using CONV in XML output string

I'm constructing a LIST TOXML sentence on the fly. Does anyone know if
you can combine two CONV modifiers on a TCL line? I'm extracting data
which needs to meet length criteria (T100) and also needs to ensure that
all the characters are printable (MCP).

Eg LIST TEMP ID.SUP @ID AS ProductID F1 AS Description CONV T100 CONV
MCP TOXML

Cheers,
Stuart Boydell




DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Using CONV in XML output string

2007-02-21 Thread Boydell, Stuart
Hi Adrian,
Thanks for the response; multiples aren't working for me [UV10.0.7].
What syntax are you using?

L#100 works differently to T100 (here) - T truncates to a particular
length (which is what I want to ensure that the column width does not
exceed the size of the target SQL column).

Eg L#6 vs T6
L#6 - ... Description=Widget with multiple frustum gimlets /
T6   - ... Description=Widget /

Cheers,
Stuart

-Original Message-
I just tried this out - and it does let you use multiple CONVS one
after
the other. BUT, I would normally use FMT L#100 rather than CONV
T100.
[snip]
Eg LIST TEMP ID.SUP @ID AS ProductID F1 AS Description CONV T100
CONV
MCP TOXML

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Using CONV in XML output string

2007-02-21 Thread Womack, Adrian
We're on UV 10.1.20 (in PI/Open flavour).

The L#100 is a format not a conversion, so should be used with FMT
not CONV.

Eg. LIST TEMP ID.SUP F1 AS Description FMT L#100 CONV MCP TOXML

Or using two CONVs:

LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP TOXML

I even tried three CONVs and it still worked - eg.

LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP CONV MCU
TOXML
(causing the Description to be 100 characters long, printable 
uppercase)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Thursday, 22 February 2007 1:51 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Using CONV in XML output string

Hi Adrian,
Thanks for the response; multiples aren't working for me [UV10.0.7].
What syntax are you using?

L#100 works differently to T100 (here) - T truncates to a particular
length (which is what I want to ensure that the column width does not
exceed the size of the target SQL column).

Eg L#6 vs T6
L#6 - ... Description=Widget with multiple frustum gimlets /
T6   - ... Description=Widget /

Cheers,
Stuart





DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Using CONV in XML output string

2007-02-21 Thread Boydell, Stuart
Adrian,
Ah Format! Using the FMT L#100 works - I had only tried using the D type
format modifiers (100L ) which didn't truncate.
So, that solves my problem for now.
I've tried running the PIOPEN flavour of LIST and multiple CONVs still
don't work on this version of UV apparently.
Many Thanks
S


-Original Message-
We're on UV 10.1.20 (in PI/Open flavour).

The L#100 is a format not a conversion, so should be used with FMT
not CONV.

Eg. LIST TEMP ID.SUP F1 AS Description FMT L#100 CONV MCP TOXML

Or using two CONVs:

LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP TOXML

I even tried three CONVs and it still worked - eg.

LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP CONV MCU
TOXML
(causing the Description to be 100 characters long, printable 
uppercase)

 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/