On 11/3/2010 1:26 AM, David Wolverton wrote:
Yes -- this does work --
It also turns out it DOES work using the 'tab' key, but looks bad, but that
it will not work from an SB+ '/TCL shell'.
I'm sort of hoping the new features (which includes a 'database viewer' I
hear) will make this kind of thing better for us going into SQL-land
settings! Generating a tab-delimited file is something a novice SQL users
can do - it's point and shoot for the most part. I'm hoping our
interpretation is as nice!
David W.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wally Terhune
Sent: Tuesday, November 02, 2010 4:37 PM
To: U2 Users List
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
2 line program works:
STMT = 'LIST CUSTOMER NAME TO DELIM "' :CHAR(9): '" wwtestjunk'
EXECUTE STMT
Also - if you are using dictionary items with conversion codes and want the
data in the output file to have the conversion code applied, don't forget to
first run the ECL command:
UDT.OPTIONS 91 ON
Wally Terhune
U2 Support Architect
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: [email protected]
Web: www.rocketsoftware.com/u2
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of David Wolverton
Sent: Tuesday, November 02, 2010 3:24 PM
To: 'U2 Users List'
Subject: Re: [U2] INPUTIF statement in Universe {Unclassified}
WELL -- I guess I could go the 3rd Party Product route -- but come on!
EVERY database product can do what I'm asking. It's not rocket science or
anything! (pun unintended!) I could just write BASIC code if I wanted - I'm
trying to find what I'm thinking should already be 'inside' of UniData. If
the answer is 'it is not there' then I will be forced to ask if someone from
Rocket can address 'why not'??
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
The TO DELIM functionality breaks down when trying to use BY-EXP (at
least in udt6.1 it does). I also wish we could write to an arbitrary
directory, but on my install I can only write to the current working
directory.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
