Hi all,
I have an issue regaring a query who run in a CL, the query is started with a value passed from CL program:
My QMQRY:
SELECT * FROM mylib/myfile WHERE m_year concat m_month concat m_day > &var1
Here is the cl:
PGM PARM(&var1)
DCL (&var1) (*CHAR) LEN(8) --- like 20170519 as possible value, the format is YYYYMMDD
STRQMQRY QMQRY(My_query) OUTPUT(*) NAMING(*SYS) SETVAR((var1 &var1))
--> My problem is that I have an error - sqlcode=-104, it doesn't recognize the symbol & - I have in french the message : Element syntaxique & n'est pas correct. Elements possibles : ( + - ? : DAY..
message QWM2701
Please help me to understand what is wrong.
Before it works, now I have this problem but exactly this program with this query worked fine, I don't know what is change, if it related system values or not.
Thanks in advance
I have an issue regaring a query who run in a CL, the query is started with a value passed from CL program:
My QMQRY:
SELECT * FROM mylib/myfile WHERE m_year concat m_month concat m_day > &var1
Here is the cl:
PGM PARM(&var1)
DCL (&var1) (*CHAR) LEN(8) --- like 20170519 as possible value, the format is YYYYMMDD
STRQMQRY QMQRY(My_query) OUTPUT(*) NAMING(*SYS) SETVAR((var1 &var1))
--> My problem is that I have an error - sqlcode=-104, it doesn't recognize the symbol & - I have in french the message : Element syntaxique & n'est pas correct. Elements possibles : ( + - ? : DAY..
message QWM2701
Please help me to understand what is wrong.
Before it works, now I have this problem but exactly this program with this query worked fine, I don't know what is change, if it related system values or not.
Thanks in advance
Comment