IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Exclude Null Columns while unload db2 table using DSNTIAUL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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:23 pm
Reply with quote

Hi
Anyone explain how to Exclude the Null Columns while unload db2 table using DSNTIAUL utility?
Is there any way code in SELECT statement to exclude null values to unload data set??
Back to top
View user's profile Send private message
Gurmeet

New User


Joined: 22 Feb 2006
Posts: 46
Location: Pune

PostPosted: Tue Jun 06, 2006 9:52 pm
Reply with quote

You can do so by creating a view and exclude the null columns from the view.

~Gurmeet
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 11:37 am
Reply with quote

Since DSNTIAUL supports normal select statements, you can code select statement which would exclude the nullable columns(provided you know which are the nullable columns) or else if you just want to supress the null indicators you can just use COALESCE function in SELECT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top