Splunk DB2 connect rising option error

[abhijitsaoji]

I have successfully set-up the connection with DB2 database on Z OS, there are two options Batch and Rising. Batch option is working fine however its very risky and I want to configure Rising option however it is not working. I get below error.

com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10145][10844][4.13.127] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815

any help will be highly appreciated.

[richgalloway]

What is your query? What are you using for the rising column?

[abhijitsaoji]

hi, thanks for your reply. My query is
SELECT *
FROM "XX01"."LOG"
WHERE EVENTTIMESTAMP > '2019-01-01 00:00:00.000'
ORDER BY EVENTTIMESTAMP ASC

I am using EVENTTIMESTAMP as rising column, it is defined as timestamp field.