FORMAT TIMESTAMP IN FULL UNLOAD DB2 11 for Z/OS - DSNUTILB

Paramasivam Ramasubramaniam

FORMAT TIMESTAMP IN FULL UNLOAD DB2 11 for Z/OS - DSNUTILB

I m using DSNUTILB to take the full unload of a table that contains few columns with TIMESTAMP Datatype.

The Output is in delimited format (CSV).

The Target format requires the Timestamp value in YYYY-MM-DD hh:mm:ss format.

But my UTILITY unloads the value  in YYYY-MM-DD-HH.MM.SS format . I have coded as COLUMN_NAME TIMESTAMP POSITION(*) EXTERNAL(19) to get this result.

 I thought of using DSNTIAUL with TOCHAR Scalar function to acheive the desired result.But its time consuming, as I need  to detail the table with all the columns and concatenation of comma to each column name to acheive the CSV format.

Its is huge table with BLOB Columns and I have more similar tables to be unloaded.

Is there any easiest way to acheive the result using DSNUTILB or other simple solution. 

 

regards!

Ramasubramaniam

Edited By:
Paramasivam Ramasubramaniam[Organization Members] @ Oct 27, 2017 - 06:46 PM (Asia/Calcutta)