EXPORT problem

[Thanos]

DB2 UDB ver8.1 does not support the EXPORT file type of
ASC(nondelimited) . If there a workaround I have the following table
that I need exported or unload to a flatfile as nondelimited fixed
width column format. Any help will be appreciated.

CREATE TABLE cf_recs ( BDY_REC_TYPE CHARACTER (3) , SOURCE_SYSTEM
CHARACTER (6) , EMP_NO CHARACTER (30) , EFFECT_DATE DATE ,
DEPARTMENT_ID CHARACTER (10) )

[Jan M. Nelken]

Thanos wrote:

DB2 UDB ver8.1 does not support the EXPORT file type of
ASC(nondelimited) . If there a workaround I have the following table
that I need exported or unload to a flatfile as nondelimited fixed
width column format. Any help will be appreciated.

CREATE TABLE cf_recs ( BDY_REC_TYPE CHARACTER (3) , SOURCE_SYSTEM
CHARACTER (6) , EMP_NO CHARACTER (30) , EFFECT_DATE DATE ,
DEPARTMENT_ID CHARACTER (10) )

db2 -x "select * from cf_recs" > cf_recs.asc

Jan M. Nelken

[pz]

Or

db2 export to file.asc of del
select bdy_rec_type || source_system || emp_no || char(effect_date) ||
department_id from cf_recs

Jan M. Nelken wrote:

Thanos wrote:

DB2 UDB ver8.1 does not support the EXPORT file type of
ASC(nondelimited) . If there a workaround I have the following table
that I need exported or unload to a flatfile as nondelimited fixed
width column format. Any help will be appreciated.

CREATE TABLE cf_recs ( BDY_REC_TYPE CHARACTER (3) , SOURCE_SYSTEM
CHARACTER (6) , EMP_NO CHARACTER (30) , EFFECT_DATE DATE ,
DEPARTMENT_ID CHARACTER (10) )

db2 -x "select * from cf_recs" > cf_recs.asc

Jan M. Nelken