George,
I use to pull a little trick saving a list of ids to the SAVEDLISTS file. Think of the SAVEDLISTS as any file name and your list as a Record. Within the Record write each cleaned Id on a new line. There is a limit to the number of Ids you can place in each record. The first record you save should be name001. After you hit your limit save the record and start name002. When you are finished writing your ids use a GET.LIST name to have an active save list within your program. To view a SAVEDLISTS name just create a SAVE.LIST and list the SELECT SAVEDLISTS name then LIST SAVEDLISTS by Id this will give you a way to test for any issues. If your list has name001 name002 name003 look at name002 for the limit. Also check your SAVEDLISTS structure some admins have all SAVEDLISTS in one area others each user has there own SAVEDLISTS. Just another way to control the task. Laurie Blain Unidata Programmer Analyst Live, Love, Code! Columbus, Ohio [email protected] --- On Wed, 4/1/09, phil walker <[email protected]> wrote: From: phil walker <[email protected]> Subject: RE: [U2] SQL a possibility? To: [email protected] Date: Wednesday, April 1, 2009, 6:21 PM SELECT FILENAME SAVING SWITCHIT Will work from TCL I believe.... > -----Original Message----- > From: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of George Gallen > Sent: Thursday, 2 April 2009 11:01 a.m. > To: [email protected] > Subject: [U2] SQL a possibility? > > I'm trying to save the first field of a .csv file to a select list, > Yes, I can > write a program, > but I also wanted to try to do it on the fly. > > Using UV10.0.2 , unix on Information format > > The source data looks like: > '#12345566#','first','last',..... > '#12344555#','first','last',..... > > Basically, field one has the item ID of another file. > > The source file gets read into a tempory file input file > > I created an I-desc of the following: > > 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 > > The above will convert the whole record into one mutlivalue attribute, > then strip off the first field delimited by the "," > then strip out the # ,' and spaces > > LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen > exactly what > I want > and so does > SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME'; > > Now....How can I put that data into a saved-list? (Using either TCL or > SQL?) > for that matter, how do you save a list using SQL on Universe? I tried > creating a view, but was told I > had to create a schema in order to create tables...that's no fun... > > I could open a como file, list the output with no headings close the > como > file, > edit it clean, the form-list the como file (work around 1) > > George > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
