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

Select clause in the unload utility
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Farrauto

New User


Joined: 30 Aug 2007
Posts: 5
Location: Belgium
PostPosted: Mon Sep 17, 2007 3:28 pm
 Reply with quote
Hi,

I want unloaded a table but i want to specified a select clause in the unload utility.

my sysin is :
Code:
 
UNLOAD                                         
TABLESPACE DNNDB.SNNDB019                     
FROM TABLE NNDBD.DEU02 (CLIENT,DBD)           
WHEN (                                         
SELECT B.CLIENT, B.DBD                         
FROM NNDBD.DBEURO_CLIDBD_DEV A                 
     RIGHT OUTER JOIN NNDBD.DEU02_CLIDBD_DEV B
     ON CODE = CLIENT AND B.DBD = A.DBD       
WHERE A.DBD IS NULL                           
GROUP BY B.CLIENT, B.DBD                       
)                                             


I have an error => INVALID KEYWORD - B.CLIENT
DBEURO_CLIDBD_DEV and DEU02CLIDBD_DEV are views.

it's possible with join in my unload?

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

New User


Joined: 30 Aug 2007
Posts: 5
Location: Belgium
PostPosted: Mon Sep 17, 2007 6:05 pm
 Reply with quote
RESOLVED

I have used DSNTIAUL and you can make a select from your table (you want unloaded) and all is right.

THANK YOU :-)
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
PostPosted: Mon Sep 17, 2007 6:24 pm
 Reply with quote
Good news....Thanks for the follow up.
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 Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts REASON 00D70014 in load utility DB2 6
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us