|
View previous topic :: View next topic
|
| Author |
Message |
Prasanna Kamthekar
New User
Joined: 03 Aug 2009
Posts: 14
Location: Pune
|
|
|
|
Hi all,
I am once again back with new challange.
Requirement: I would like to unload the data from table based on some formating rule using IBM utility D2IUNLD(Program DSNUTILB).
Formating rule: I would like to move special character '~' after first column field in output file. (or between any two field of the table).
NOTE: Dont provide the solution which uses keyword 'FORMAT'. Because it seems to be invalid for IBM utility. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| I am once again back with new challange. |
sounds more like a do my job for me. |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| dbzTHEdinosauer wrote: |
| Quote: |
| I am once again back with new challange. |
sounds more like a do my job for me. |
LOL, i have a few good laughs here since i signed up. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Prasanna,
Why can't you use DSNTIAUL ?
Sushanth |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I have requirement to test it using DSNUTILB.So I cant use DSNTIAUL. |
Amazing the things that become requirements. . .
Hard to believe this is any business requirement. Maybe it is a homework assignment. |
|
| Back to top |
|
|
Prasanna Kamthekar
New User
Joined: 03 Aug 2009
Posts: 14
Location: Pune
|
|
|
|
Thanks to all for your valuable suggestions.
My problem has solved as i tried to unload the data using High Performance Unload utility (PGM=INZUTILB).
But still i am thinking that we can unload the data with proper formating using DSNUTILB. I will let you know once I get the solution. |
|
| Back to top |
|
|
|
|
