|
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/
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.