strqmqry /passing variables

[Pekka]

Hello there,
this is not exatly db2 issue but if somebody is familiar with As/400 query manager and could help.
Here is the simple example of the query:
SELECT * FROM libl39/cipname0 A WHERE cuno=&cuno
Here is the cl:
PGM PARM(&CUNO)
DCL (&CUNO) (*CHAR) LEN(7)
CHGVAR VAR(&CUN) VALUE(&CUNO)
STRQMQRY QMQRY(DSP_PF) SETVAR((CUNO &CUNO))

Problemo:
Why doesn't this cl pass the parameter to query but is allways prompting the variable cuno?

 

[leveyp]

Try build the entire string:

Your QMQRY looks like

SELECT * FROM MYLIB/EMPLOYEE WHERE EFEMNO &QEMNO

your CLP looks like

PGM PARM(&EMNO)
DCL VAR(&EMNO) TYPE(*CHAR) LEN(5)
DCL VAR(&STRING) TYPE(*CHAR) LEN(10)

CHGVAR VAR(&STRING) VALUE('=' *BCAT &EMNO )
STRQMQRY QMQRY(MYLIB/TEST) OUTPUT(*) SETVAR((QEMNO &STRING))

ENDPGM

 

[vtj]

Try removing the table qualifier ("A&quot from your filename. The system may think cuno is a variable as opposed to the column name (A.cuno).

VTJ