> -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Brian Leach > Sent: Thursday, April 02, 2009 4:21 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] SQL a possibility? > > George > > >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... > > SQL - > SELECT SWITCHIT TO SLIST 0 FROM FILENAME WHERE @ID = 'somename';
This gave me an error, about not being able to use a multivalued field.. > > RetrieVe - > > SELECT FILENAME "somename" SAVING SWITCHIT This did not work, instead of giving me a listing of just the ID, it saved the original line without parsing. > > Both create active select lists you can then SAVE.LIST. > > Brian ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/