Re: Dynamic SQR Select Clause

[John Sayre <John_Sayre@GAP.COM>]

John Sayre@GAPINC
10/27/98 09:59 AM



One addition to this, the square brackets [ ] do not work if run on the
mainframe with DB2.
There you have to use /$recordname /


Store the user-specified record name in a variable, let's say $recordname.
Then
let $recordname = 'PS_'|| $recordname


Then construct the select statement as follows:

Select  *  from [$recordname]

This should work.

The "[ ] " brackets are used to specify Dynamic variables.

Charu






l.ted.fecteau@LMCO.COM on 10/27/98 12:12:54 PM

Please respond to SQR-USERS@USA.NET

To:   SQR-USERS@list.iex.net
cc:    (bcc: C. Srinivas/dsisys/US)
Subject:  Dynamic SQR Select Clause




Does anyone know how to dynamically set up a SQR Select clause such that
the
column
names do not have to be explicitly named within the
begin-select/end-select?
I am
using PeopleSoft's PSRECFIELD table to determine the columns within a user
specified
record in order to select the data from that record.  For example, if the
user specifies
the record "PROJECT" as a parameter, I would like to do a "select *" from
that table
and place the resulting data in an output file.

Any help would be much appreciated.

>
>
>