IBM Mainframe Forum

I have an Easytrieve that queries a database and puts the result in a report. I need to filter the information in the query by taking the Order Date from Control-M. For that I'm passing the %%$ODATE from the JCL by using utility EZTPX01; I later put that date in a working storage variable, format it and then pass it to the WHERE clause of the query. Before this change I used TIMESTAMP(CURRENT DATE) in the aforementioned clause, and it worked beautifully.

Now I can't make it work, I keep getting SQL errors, depending on how I pass the WS variable (with or without quotes, using TO_CHAR, TO_DATE, TIMESTAMP, and others):
*******A046 SQL - DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE *N IS INVALID
*******B204 SQL - DSNT408I SQLCODE = -206, ERROR: ODATE IS NOT VALID IN THE CONTEXT WHERE IT IS USED

The PARM passed from the JCL is read like this: 20231023.

I can't share the program for compliance reasons, but if there's anything you need please let me know. This is a general layout of the code:

I'm using the SQL INCLUDE statement to retrieve database information; the JOB activity section looks like this:

Here's the date processing:

And this is the WHERE clause:

I've tried to solve this using the manual, going over forums and just can't figure this out. I'm sure I'm overlooking something.
I will take any help the experts can provide, thank you in advance

Forgot to add the working storage:

I got a fix for this:

I changed the format of the DB2 column 'ACTION_TIMESTAMP' by using TO_CHAR(ACTION_TIMESTAMP, 'YYYY-MM-DD') in the query, so that when the WHERE clause kicks in, it can compare ODATE (which is a string) with the formatted ACTION_TIMESTAMP.

Not necessarily the thing I was looking for to get (code wise), but it definitely works to achieve my objective.

Thanks anyway