Hi All,
I am migrating the data from DB2 to oracle 10g. while exporting data from DB2 to some external files, i am able to export the data but when i want to export the data with columns name i tried this query( Intending to append the data file with the column file)
for data file:
1. db2 'EXPORT TO D:\Exp_files\Ex p_Tables\exp_cu st_details.csv OF DEL select * from tabschema.tabna me
for column file:
2. db2 EXPORT TO D:\Exp_files\ex p_custHead_deta ils.txt OF DEL modified by chardel"" coldel,decpt.da tesiso decplusblank SELECT SUBSTR(REPLACE( REPLACE(XMLSERI ALIZE(CONTENT XMLAGG(XMLELEME NT(NAME c,colname) ORDER BY colno) AS VARCHAR(100)),' <C>',','),'</C>',''),3) FROM syscat.columns WHERE tabschema='XXXX ' AND tabname='CUSTOM ER_DETAILS'
Then i am getting this error:
SQL3183W Multiple delimiter overrides in the filetmod parameter are not seperated by blanks.
SQL3100W column number '1' (identified as "1") in the output DEL format file is longer than 254 bytes.
I think all the columns name are cummulated in one single column.
Please help with this query
Regards,
Syed.
I am migrating the data from DB2 to oracle 10g. while exporting data from DB2 to some external files, i am able to export the data but when i want to export the data with columns name i tried this query( Intending to append the data file with the column file)
for data file:
1. db2 'EXPORT TO D:\Exp_files\Ex p_Tables\exp_cu st_details.csv OF DEL select * from tabschema.tabna me
for column file:
2. db2 EXPORT TO D:\Exp_files\ex p_custHead_deta ils.txt OF DEL modified by chardel"" coldel,decpt.da tesiso decplusblank SELECT SUBSTR(REPLACE( REPLACE(XMLSERI ALIZE(CONTENT XMLAGG(XMLELEME NT(NAME c,colname) ORDER BY colno) AS VARCHAR(100)),' <C>',','),'</C>',''),3) FROM syscat.columns WHERE tabschema='XXXX ' AND tabname='CUSTOM ER_DETAILS'
Then i am getting this error:
SQL3183W Multiple delimiter overrides in the filetmod parameter are not seperated by blanks.
SQL3100W column number '1' (identified as "1") in the output DEL format file is longer than 254 bytes.
I think all the columns name are cummulated in one single column.
Please help with this query
Regards,
Syed.