Code: Select all
FROM "#Library_ps.Library_Name#"."#TableName#" x
WHERE TRIDTR || '-' || MARQTR IN ('30-0', '32-1', '32-6', '41-77', '40-2', '83-0', '39-0')
AND"#SFPTR_JACKPOT_Load_Type#"
ORDER BY DHYRTR
Code: Select all
DHYRTR <= (select days (current date) - days (date('1900-01-01'))+1 FROM SYSIBM.SYSDUMMY1)
Code: Select all
DHYRTR <= (select days (current date) - days (date('1900-01-01'))+1 FROM SYSIBM.SYSDUMMY1)
I would appreciate any help or suggestions to accomplish the task.The connector failed to add missing columns to the output link. The rported error is: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-199, SQLSTATE=42601, SQLERRMC=ORDER;< > = <> <= !< !> != >= IN NOT, DRIVER=3.66.46