Team,
DB2 V8.1 fp11 AIX

We are trying to figure out what is the best way to export data from a db2 table in a fixed format?

Previously we used to have ASC format of export.
Now looks like it has been removed from db2.

>db2 "export to B.asc of asc select * from employee"
SQL0104N An unexpected token "asc" was found following "OF". Expected tokens may include: "IXF". SQLSTATE=42601

Thanks,
R

An option is to do

db2 -x "select * from t1" > file.asc

Sathyaram

asc is for windows only - you could use previous hint or delimited - del

Use

Export to file.csv of del select * from tablename

>>>>>

File.csv.... and del .... does not work.

Select *... works for Fixed format.

Thanks Gang
-R

Select * works if the rows are smaller size.

If the table has 96 columns and spread over unix limit of 258. Then we have a problem and we have to think about different approach.

Thanks Team
-R