Subtract 1 day from a date dynamically

Sandesh Kirodian · New User Joined: 29 Sep 2011 Posts: 6 Location: India

Hi ,

I have an input file which a date field in format '02/11/2011' i need to subtract 1 day from this date and update in a table.

i need an sql which can do this for me as i am using easytrive to do this

there are around 20k records in the file with different dates

currently i am using the below code which is not working -

dbzTHEdinosauer · Posted: Fri Dec 02, 2011 7:08 pm

not working is a rather useless comment, don't you think?
why isn't it working?
you would have received some code, either from the compiler or spufi.

practice in spufi replacing ws-date with current_date until you get the syntax correct for the functions that you are using.

and once you get it correct, put it in the update statement.
get rid of the select and just make it part of the UPDATE Clause for the column.
i don't know how in ezytrieve sql to indicate a host variable,
but in cobol the variable name is prefaced by a colon (

Sandesh Kirodian · New User Joined: 29 Sep 2011 Posts: 6 Location: India

i tried it doing with declaring a cursor i am getting the below error -

dbzTHEdinosauer · Posted: Fri Dec 02, 2011 9:36 pm

don't know what you are doing or where,

normally parameter markers (place holders) are ?.
don't think we can use alias or variable name on mainframe.
on pc, yes, but it requires the declaration of the variable name to db2.

it appears that you want to execute two sql's.
1. get a date
2. update something with this date
for each of your 20k trigger-records.

why not include the date - 1 day bit in the UPDATE Clause,
and then only have one sql?

Mickeydusaor · Posted: Sat Dec 03, 2011 12:49 am

This is the correct format of the command....