View previous topic :: View next topic
|
Author |
Message |
i_sivapras
New User
Joined: 04 Aug 2009 Posts: 4 Location: hyderabad
|
|
|
|
Hi,
How can we set default values for null columns in unload JCL itself. |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Hi,
Check for IF NULL condition,
Code: |
,COLL_1 DECIMAL(15, 2)
IF NULL VALUE (0.00)
|
Hope this help |
|
Back to top |
|
|
i_sivapras
New User
Joined: 04 Aug 2009 Posts: 4 Location: hyderabad
|
|
|
|
It's not working..Can you explain in detail |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Hi,
Which unload utility you are using for doing this ? |
|
Back to top |
|
|
i_sivapras
New User
Joined: 04 Aug 2009 Posts: 4 Location: hyderabad
|
|
|
|
We are using INZUTILB utility |
|
Back to top |
|
|
|