Unloading date from a DB2 ZOS table in format HH24:MI:SS



IBM's flagship relational database management system

Unloading date from a DB2 ZOS table in format HH24:MI:SS

Postby Nagesh_ZOS » Wed Sep 27, 2017 3:13 am

Hi All,

I am trying to unload a db2 tables and ftp this to Linux server and load this into a Oracle table. My tables have date field and they are unloading in format of HH24.MI.SS . But I want the output to be in a format of HH24:MI.SS. Can someone let me know to achieve the desired output. We have many tables with huge number of columns. Appreciate your help on this.
2016-07-21

Thanks,
Nagesh.
Nagesh_ZOS
 
Posts: 14
Joined: Wed Aug 16, 2017 10:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unloading date from a DB2 ZOS table in format HH24:MI:SS

 

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post