Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 tables using the utility DSNTIAUL- Null Indicator Handle

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
contact4me
Warnings : 1

New User


Joined: 02 Jun 2006
Posts: 2

PostPosted: Fri Jun 02, 2006 10:29 pm    Post subject: DB2 tables using the utility DSNTIAUL- Null Indicator Handle
Reply with quote

Hi

While unloading data from DB2 tables using the utility DSNTIAUL, the allow null columns unload the Null indicator byte as well into the dataset. How do I avoid unloading the extra byte ?

For eg:- If Col1 (char (1), Allow Null ) has a Value 'A' in the table. While unloading this field the dataset will Have 'A.' My question is how do I skip the 'dot' while unloading ? Is there any function or any Parms available ?

Appreciate your help

Thanks
Back to top
View user's profile Send private message

anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Wed Jun 07, 2006 3:40 pm    Post subject: Re: DB2 tables using the utility DSNTIAUL- Null Indicator Ha
Reply with quote

1. If your are using Unload file for further processing in yout job stream, then you can use SYNCSORT utility to remove the dots in your unload file.
2. if the number of columns are less, then in the select statement you can use COALESCE function for nullable columns.
3. if BMC is supported in your installation, then go in for BMC unload which supports replacemt of null value. while unloading you can just say ' IF NULL VALUE( whetever in single quotes)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us