|
View previous topic :: View next topic
|
| Author |
Message |
Susanta
Active User
Joined: 17 Nov 2009
Posts: 129
Location: India
|
|
|
|
Hi All
I want to use DB2UJHPU to unload rows from a table. to be used by non db2 team.
need to unload the date with FORMAT EXTERNAL .. to get the the binary date in display format.
when i run the job it gives the ouput with fileds without any delimiter.
is there any option to direct the jcl to use a delimiter say ;
Thanks
The JCL SYSIN:
| Code: |
//SYSIN DD *
UNLOAD TABLESPACE
DB2 FORCE
LOCK NO
QUIESCE NO
QUIESCECAT NO
OPTIONS
NULL OFF
SELECT *
FROM XYZ.ABC_TBL
FETCH FIRST 10 ROWS ONLY
WITH UR
;
OUTDDN (UNLDD1)
FORMAT EXTERNAL
/* |
|
|
| Back to top |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
What does the manual say?
And why post a DB2 question in the JCL section (moved to DB2 for you)? And, surely you know how to use the code tags (coded for you)? |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| I don't think anything implicit available as such so you need to code for but most importantly why did you not talk to DBA Yet as they are the right group to answer accurately at your site? |
|
| Back to top |
|
|
|
|
