Helpful Information
 
 
Category: DB2 Development
export db 2 data into a text file

I am having some problem with exporting db2 time fields into a excel file as i am doing some of database mirgation.

first, i have exported db2 data into a excel file,and change the time format to read as hh:mm:ss, after that i import them into mysql database.

whem i export the time filed (hh:mm:ss) into a excel it become hh.mm.ss,hence, when i import them into mysql database only ss got imported.

You help will be much appricated!

Regards and thanks.
NY

Just a quick question, why are you exporting from db2 to excel and then to mysql.
Why not just export to a file then import that file to mysql.

This is more of an excel problem because it munges the field.

Just a quick question, why are you exporting from db2 to excel and then to mysql.
Why not just export to a file then import that file to mysql.

This is more of an excel problem because it munges the field.


actually, I exported the db2 into a txt file and open it using excel to conver the date and time column as db2 date format is dd-mm-yyyy whereas mysql yyyy-dd-mm.

Thanks and regards.

Use the modified by command for export. Try dateiso or timestampformat=. See this doc: http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0008303.htm

Use the modified by command for export. Try dateiso or timestampformat=. See this doc: http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0008303.htm


Thanks for your reply.










privacy (GDPR)