I just answered my own question right after I sent that last reply..lol. The
PASSLIST way (which I will not be using btw) is below:
SEL.STMT = 'SELECT CLIENT BY NAME WITH NAME = "A]"'
EXECUTE SEL.STMT CAPTURING CAPTURED PASSLIST
IF (SYSTEM(11)*@SELECTED) THEN
LIST.STMT = 'SELECT CLIENT WITH PAGE = 4'
EXECUTE LIST.STMT CAPTURING CAPTURED PASSLIST
LOOP WHILE READNEXT CLIENT.KEY
CALL LFSIO.DATAFILE('QREAD*CLIENT',CLIENT.REC,CLIENT.KEY,'','')
PRINT CLIENT.KEY:' ':CLIENT.REC<CL$NAME>
REPEAT
END
RETURN
Like you said, why do 2 executes when you don't need to, although when you
stack your SELECT commands like you did with the following:
CMD1 = 'SELECT CLIENT BY NAME WITH NAME = "A]"'
CMD1<-1> = 'SELECT CLIENT WITH PAGE = 1'
EXECUTE CMD1 RTNLIST CLIENT.LIST
You would think that does 2 executes, 1 behind the scenes but maybe not? It
must someone execute the first SELECT doesn't it, or is it a system level
command when you stack select's that the system processes 1 first, then the 2nd
with the first's results.
Chris
> From: cjausti...@hotmail.com
> To: u2-users@listserver.u2ug.org
> Date: Wed, 20 Jul 2011 17:14:53 -0500
> Subject: Re: [U2] SELECT question, paginated select.
>
>
> OK cool, thanks. Just out of curiosity how would you do 2 selects using a
> PASSLIST?
>
> Chris
>
>
> > From: ggal...@wyanokegroup.com
> > To: u2-users@listserver.u2ug.org
> > Date: Wed, 20 Jul 2011 17:06:50 -0500
> > Subject: Re: [U2] SELECT question, paginated select.
> >
> > SORRY, My mistake.
> >
> > that should have been
> >
> > SELECT CLIENT WITH PAGE = <<I3,PAGENO>>
> >
> > That should clear up the error.
> >
> > > -----Original Message-----
> > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > boun...@listserver.u2ug.org] On Behalf Of Chris Austin
> > > Sent: Wednesday, July 20, 2011 6:02 PM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: Re: [U2] SELECT question, paginated select.
> > >
> > >
> > > I setup my VOC as follows:
> > >
> > > PA
> > > SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>]"
> > > SELECT CLIENT WITH PAGE = <<I2,PAGNO>>
> > >
> > > I received an error though:
> > >
> > > CHRIS>GETCLIENTS A 4
> > >
> > > 6000 record(s) selected to SELECT list #0.
> > > RetrieVe: syntax error. Unexpected symbol. Token was "".
> > > Scanned command was SELECT CLIENT WITH PAGE = A
> > >
> > > Without setting up a VOC entry is there an easy way to execute 2
> > > selects in a program (just like in telnet)?
> > >
> > > Chris
> > >
> > >
> > > > From: ggal...@wyanokegroup.com
> > > > To: u2-users@listserver.u2ug.org
> > > > Date: Wed, 20 Jul 2011 16:50:08 -0500
> > > > Subject: Re: [U2] SELECT question, paginated select.
> > > >
> > > > oops forgot the bracket:
> > > >
> > > > Should read: SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>]"
> > > >
> > > > > -----Original Message-----
> > > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > > > boun...@listserver.u2ug.org] On Behalf Of George Gallen
> > > > > Sent: Wednesday, July 20, 2011 5:48 PM
> > > > > To: U2 Users List
> > > > > Subject: Re: [U2] SELECT question, paginated select.
> > > > >
> > > > > I'm not sure if this works on Pick flavor but...
> > > > >
> > > > > ED VOC GETCLIENTS
> > > > > 001: PA
> > > > > 002: SELECT CLIENT BY NAME WITH NAME = "<<I2,SRCH>>"
> > > > > 003: SELECT CLIENT WITH PAGE = <<I2,PAGNO>>
> > > > >
> > > > > NOW, You can get your results with
> > > > >
> > > > > GETCLIENTS A 4
> > > > > GETCLIENTS ALEX 6
> > > > >
> > > > > George
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > > > > > boun...@listserver.u2ug.org] On Behalf Of Chris Austin
> > > > > > Sent: Wednesday, July 20, 2011 5:26 PM
> > > > > > To: u2-users@listserver.u2ug.org
> > > > > > Subject: Re: [U2] SELECT question, paginated select.
> > > > > >
> > > > > >
> > > > > > George,
> > > > > >
> > > > > > I must say, you the man! And thanks for everyone else's help too.
> > > > > That
> > > > > > I-descriptor works beautifully and saved me a ton of time, thanks
> > > a
> > > > > > bunch.
> > > > > > To get my results in order I have to do the double select, such
> > > as:
> > > > > >
> > > > > > 03 SELECT CLIENT BY NAME WITH NAME = "A]"
> > > > > > 02 SELECT CLIENT WITH PAGE = 4
> > > > > > 01 LIST CLIENT PAGE NAME
> > > > > >
> > > > > _______________________________________________
> > > > > U2-Users mailing list
> > > > > U2-Users@listserver.u2ug.org
> > > > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > > > _______________________________________________
> > > > U2-Users mailing list
> > > > U2-Users@listserver.u2ug.org
> > > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > >
> > > _______________________________________________
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > _______________________________________________
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
