View previous topic :: View next topic
|
Author |
Message |
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Dear DB2 Experts,
I want to unload the data to a file from the table such that the fields of the colums should be delimited by '|'
Table:
Code: |
ID - CHAR(9)
COL2 - CHAR(4)
COL3 - CHAR(5)
COL - CHAR(22)
ID COL2 COL3 COL4
--------- ---- ----- ----------------------
ACD990795 JZZ SB SA34100
BCJ908765 ABC AB AH12345 |
Please give me the JCL |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi
You can use DELIMITED COLDEL '|' in your UNLOAD utility control card statement in the JCL.
Regards
Raghu |
|
Back to top |
|
|
|