Mainframe, MVS and zOS Discussion

Shamshir Rai Luthra

Hi,

I have tried with this:

UPDATE table
SET YEAR(DATE) = 2017 
WHERE 
YEAR(DATE) = 2016;

But it did not work.

Shamshir Rai Luthra

Thanks nicc. But unload was not readable too. Can you please suggest a usual way of doing it?

Would appreciate any help you can provide.

Shamshir Rai Luthra

Hi,

Using a DB2 query I need to update only the year of a date. The date is defined in DATE format. Can we do this? I could not find a way of doing this?
Can anyone help please?

Shamshir Rai Luthra

Hi I need to unload a DB2 table. And in the unload I want the columns to be delimited by semicolon, ";". Also all decimal values should be converted in to readable format. For this, I tried to use DSNUPROC like this: DELIMITED COLDEL ';' PUNCHDDN SYSPUNCH UNLDDN SYSREC00 EBCDIC But this di...

Mainframe, MVS and zOS Discussion

Search found 4 matches

Re: Update only the year in DATE in DB2.

Re: Unload a table with specific column delimiters and redabale format.

Update only the year in DATE in DB2.

Unload a table with specific column delimiters and redabale format.