Hi All,

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
file.

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

a1,b1,c1,d1,e1
a2,b2,c2,d2,e2
a3,b3,c3 <--- Line that gives the SQL3100W
d3,e3
a4,b4,c4 <--- Line that gives the SQL3100W
d4,e4

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.

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.