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 "George Gallen" <ggal...@wyanokegroup.com> wrote in message news:<6d57ef06d84b5541af530227504bb68f58c8daf...@34093-mbx-c06.mex07a.mlsrvr.com>... > > -----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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
