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.
Paramasivam Ramasubramaniam[Organization Members] @ Oct 27, 2017 - 06:46 PM (Asia/Calcutta)