By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

EXPORT problem

P: n/a
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) )
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.