MVSFORUMS.com

[Manudamodar]

Hi

Iam using DSNTIAUL to unload a table to a sequential file. The current setup allows all date fields to be extracted in mm/dd/yyyy format. Is it possible to override this and extract it in ISO format i.e 'yyy-mm-dd'.

Is there any way I can do it other than using Scalar funtions on the date column to extract this info.

Sample Sysin JCL that I use is

//SYSIN DD *
SELECT *
FROM xxxxxxx ;
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
LIB('xxxx.xxxx.DSNLOAD') PARMS('SQL')
END

Thanks

[kolusu]

Manudamodar,

You can talk to your DBA and see if he can change the date format for the plan DSNTIAUL.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[CZerfas]

The other way is not using "SELECT *" but coding every column in the Select clause. Instead of the date-columns you code ..., CHAR(date-column, ISO), ... or any other of the predefined formats DB2 gives you.

regards
Christian

[sriramla]

I would prefer to leave the unload as is (no scalar function to manipulate the data). Once unload is done, use SORT / FileAID to reformat the data the way you need. In my view this will be faster compared to DB2 functions.