RE: strqmqry

["Konrad Underkofler" <kdunderk@xxxxxxxxxxxxx>]

Pete,

You have to mess around with the parm to get it in the right format.
See if this helps. It is not well documented in the books.

  CHGVAR     VAR(&EMODC) VALUE('''' *CAT &EMOD *BCAT '''')     
  STRQMQRY   QMQRY(UPDMODELS) SETVAR((EMOD &EMODC))    

Regards

Konrad
-----Original Message-----
From: Pete Olshavsky [mailto:polshavsky@xxxxxxxxx] 
Sent: Friday, November 07, 2003 9:12 AM
To: mapics-l@xxxxxxxxxxxx
Subject: strqmqry


Morning All,
I am trying to setup a CL to pass a parm to a query using the strqmqry
cmd. The parm is a W/H to sort those selected records from the ITEMBL
file, and create a work file. 
In my qry my selection clause is:
 AND/OR  Field             Test   Value (
         T01.HOUSE         EQ     :house 
  AND    T02.ITTYP         LIST   '3' '4'
  AND    T01.WHSLC         NE     ' '    
My CL is;
PGM            parm(&house)                        
             DCL    VAR(&house) TYPE(*char) LEN(3) 
 
     STRQMQRY   QMQRY(MAPCSTPGM/AAAAA) OUTPUT(*OUTFILE) + 
                  OUTFILE(QGPL/TMPWHSE) ALWQRYDFN(*YES) + 
                  SETVAR((HOUSE &HOUSE))  
The parm is &house with a value of in this case 'AT '
I am getting an errors;
Query derived from *QRYDFN object AAAAA in MAPCSTPGM, code 00.   
Column AT not in specified tables.                               
RUN QUERY command failed with SQLCODE -206.                      
RUN QUERY command ended due to error.                            
STRQMQRY command failed.

                                               
Any thoughts as to what I am doing wrong or what I need to do. Thanks
and have a Good Weekend
 
Pete Olshavsky
Ind Mapics Programmer/Systems Analyst
           


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.