RE: qry manager queries and character replacement variables

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

What's needed is an understanding of how command parm values are handled by the 
command prompter/analyzer and how the SQL statement should look after the 
substiturion is completed. The issue of quotes or no quotes should be clear 
once those are clear.

Maybe a simple example that can be played with will help. Maybe others can 
provide better examples.

Create a QM query as:

select
       COLUMN_NAME ,
       SYSTEM_TABLE_NAME ,
       SYSTEM_TABLE_SCHEMA
    from SYSCOLUMNS
    where COLUMN_NAME = &Q&COL&Q

Then run these commands against it and figure out what's making the difference:

 ===> STRQMQRY QMQRY(TSTVAR) SETVAR((Q '''') (COL COLUMN_NAME))
 ===> STRQMQRY QMQRY(TSTVAR) SETVAR((Q ' ') (COL COLUMN_NAME))
and maybe even
 ===> STRQMQRY QMQRY(TSTVAR) SETVAR((Q '') (COL COLUMN_NAME))

Tom Liotta

midrange-l-request@midrange.com wrote:

>   9. RE: qry manager queries and character replacement variables
>       (DeLong, Eric)
>
>You've got the idea.  For some reason I can't remember right now (coz its
>friday and I'm a lazy guy), QM parms are wierd.  I think the image you are
>supposed to pass in is:
>
>''STUFF''
>123456789
>
>which becomes 
>
>'STUFF'
>1234567 
>
>in the SQL statement.  Of course, I usually get this stuff wrong the first
>two or three times, but.......  I'm sure sombody out there will straighten
>this out if'n I'm wrong. :) I think there's a FAQ about this.
>
>Eric DeLong
>Sally Beauty Company
>MIS-Project Manager (BSG)
>940-898-7863 or ext. 1863
>
>
>
>-----Original Message-----
>From: Richard B Baird [mailto:rbaird@esourceconsulting.com]
>Sent: Friday, January 17, 2003 12:24 PM
>To: Midrange Systems Technical Discussion
>Subject: RE: qry manager queries and character replacement variables
>
>
>
>Eric,
>
>do you have this backwards?  i.e. you don't put the quotes and +'s in the
>sql statement, but you build the variable in the CL like this:
>
>DCL &orgout *char (8)
>
>chgvar &orgout ('"' *TCAT &ORGIN *TCAT '"')     ?
>
>so that the value of the &orgout is    "CSR301"
>                                       12345678
>
>?
>
>I tried that with single quotes, but it didn't work.  i'll try with doubles
>next.
>
>thanks,
>
>Rick
>----original message-----
>Richard,
>
>More fun with "'"'s :)  Remember, you gotta build an extra layer of
>apostrophe's before you pass it in.....
>
>ORIGORG   = '"' + &A5 +'"'
>
>Eric DeLong
>

-- 
-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at 
http://webmail.netscape.com/