View previous topic :: View next topic
|
Author |
Message |
manugeorge2004
New User
Joined: 17 Jun 2009 Posts: 38 Location: Denver
|
|
|
|
Hi
I have a proc which uses DSNTIAUL via IKJEFT01 to unload a table.
The entire table is unloaded. The sum of column lengths is 737. I have a requirement where I need to append couple of blank spaces to the end as part of a business requirement. The SYSPUNCH always have the sum of columns. Is there a way to force trailing spaces when I unload the table.
I want to avoid another step to copy the output to another file because of some RACF restrictions.
I tried to allocate my output file before hand with 739 as the LRECL. But the utility recreated that to 737.
Any advice is appreciated |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Manu,
Ask you DBA to increase the length of the last column for this table. Default is SPACES for CHAR data types.
Sushanth |
|
Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
You can supply SQL as input to the unload utility. I haven't tried running unload with the SQL suggested below but I suspect it will work:
Code: |
SELECT FIELD1,FIELD2,FIELD3...,FIELDn,' ' FROM YOUROWN.YOURTABLE |
The backdraw is that you have to specify all the fields to be unloaded instead of the default SELECT * where you cannot append additional information to be included.
Remember to set the PARM('SQL') when invoking DSNTIAUL. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Nice Idea Kjeld. |
|
Back to top |
|
|
|