467,146 Members | 1,006 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,146 developers. It's quick & easy.

EXPORT problem

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
  • viewed: 2454
Share:
2 Replies
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
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.

Similar topics

13 posts views Thread by DarkSpy | last post: by
2 posts views Thread by Volker Zink | last post: by
1 post views Thread by steve | last post: by
205 posts views Thread by Jeremy Siek | last post: by
1 post views Thread by Janne Ruuttunen | last post: by
3 posts views Thread by Marja Ribbers-de Vroed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.