Yes...that worked (After created the ASELECT as below).
ASELECT FILENAME "ITEMNAME" SAVING SWITCHIT
SAVE-LIST listname
DICT FILENAME SWITCHIT
0001: I
0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; FIELDS(@1,REUSE(","),REUSE(1)) ;
CONVERT(REUSE('"# '),REUSE(''),@2)
0003:
0004: DATA
0005: 20L
0006: M
Saved the first column of the csv item, after removing any "/# or spaces.
George
> -----Original Message-----
> From: [email protected] [mailto:owner-u2-
> [email protected]] On Behalf Of Brett Callacher
> Sent: Friday, April 03, 2009 4:58 AM
> To: [email protected]
> Subject: Re: [U2] SQL a possibility?
>
> For the SAVING syntax to work, you need to use a Pick-like flavour
> version of SELECT. Something like this:
>
> ASELECT
> 0001 V
> 0002 SELECT
> 0003 Q
> 0004 GHKSXA
>
> Note the A processor mode in attribute 4.
>
> HTH
>
> Brett
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
