H DftActGrp(*No) ActGrp(*Caller)
Set Option Commit=*None;
INSERT INTO QTEMP/WKMT5TMP
SELECT * FROM DEVSHA/WKMT5TMP
WHERE MONTH in(1,2,3,4,5);
*Inlr = *On;
When using a list of numeric values separated by comma’s you should use blanks to make a separation. in(1 , 2 , 3 , 4 , 5)How else would you try to select 1,2 value ?
Register Hereor login if you are already a member
@pdraebel Thanks for your response. Even space is not working out.
As I mentioned in the question that the same query is perfectly working fine in different server.
other way i try that same query i ran in RUNSQL and get the same error. Good news here that i am able to fix the error by changing the decimal parameter from comma to periods. in the sameway i am thinking that at program level need to change somethink like that.
@ToddN2000 thank for your response.
Month is NUMERIC 2.
You are missing a space
WHERE MONTH in(1,2,3,4,5)
in( .. is interpreted as some function named in
in ( .. is interpreted as in the following list
There must be a space between in and (