var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Export with coldel § [ Help !!! ]
Is anyone know how to extract data with § symbol as delimeter in DB2?
In addition, server is using Unix OS.
I try using below command, but it failed to extract. Anyone has solution?
Appreciate anyone can help. Thanks.
db2 "EXPORT TO /tmp/migration/std_dtl.dat OF DEL MODIFIED BY codepage=1252 COLDEL§ NOCHARDEL SELECT STD_NM, STD_ID FROM EBK.STD"
Originally Posted by mark.b
Looks good. But I think I make a mistake. Now I want to migrate data from DB2 to Oracle. So means move data from AIX to Solaris OS.
If look back the command that I post, I am using codepage=1252, seems like not correct. Do you know what is the proper codepage and coldel to use?
This depends on which codepage and delimiters for your text files Oracle SQL*Loader can process correctly for loading to your database tables.
Originally Posted by weicia
If SQL*Loader can do the codepage conversion 1252->"your_oracle_db_codepage" - great.
If not - choose another codepage for 'modified by codepage' clause.