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\Exp_Tables\exp_cust_details.csv OF DEL select * from tabschema.tabname
for column file:
2. db2 EXPORT TO D:\Exp_files\exp_custHead_details.txt OF DEL modified by chardel"" coldel,decpt.datesiso decplusblank SELECT SUBSTR(REPLACE(REPLACE(XMLSERIALIZE(CONTENT XMLAGG(XMLELEMENT(NAME c,colname) ORDER BY colno) AS VARCHAR(100)),'<C>',','),'</C>',''),3) FROM syscat.columns WHERE tabschema='XXXX' AND tabname='CUSTOMER_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.