Thread: Problem With Export
02-15-06, 12:33 #1Registered User
- Join Date
- Jun 2005
Unanswered: Problem With Export
I am using UDB V8.2 on AIX . When I do an EXPORT in DEL format , it gives a
SQL3100W on certain rows.
mainly, This warning occurs on rows that do not have any columns that are
over 254 chars.
When I go and look at the .DEL export file , the rows that got the
warning are broken into two and appear as two seperate lines in the unix
for example let us say that the table has 5 columns A,B,C,D and E and
let a1,b1,c1,d1,e1 represent the data exported then my file looks like this
a3,b3,c3 <--- Line that gives the SQL3100W
a4,b4,c4 <--- Line that gives the SQL3100W
and when i do it with the .IXF then i am not getting any errors. Please explain me why it is happening and also please do explain me the difference.
Your help is really appreciated.
Thanks in advance.
02-15-06, 14:16 #2Registered User
- Join Date
- Nov 2005
In Command ref on page 365 second paragraph it says that if the char col is greater then 254 and using DEL format only you will get an error. IXF stores data diferently then DEL does, thus not effected by this limitation.--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
DB2 v184.108.40.206 os 220.127.116.11