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

'Move for DB2' Extract


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Mon Mar 15, 2010 2:45 pm
Reply with quote

How to use 'Move for DB2' to extract data from two table usnig join between them ?

Please help.
Back to top
View user's profile Send private message
Gijz

New User


Joined: 27 Nov 2007
Posts: 9
Location: The Netherlands

PostPosted: Tue Mar 16, 2010 8:34 pm
Reply with quote

Just specify both of them in option 1 (TABLES) of the EXTRACT Process or specify one of them as Start table and use the "GET TABLES RELATED" command to obtain the other.
Be sure to select the right acces path in the "Specify Relationship Usage" screen. You can get there using option 2 (PATHS).
Back to top
View user's profile Send private message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Mon Mar 22, 2010 2:15 pm
Reply with quote

Thanks. It worked.
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 -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts COBOL - Move S9(11)v9(7) COMP-3 to -(... COBOL Programming 5
No new posts optim extract file - SAS DB2 2
No new posts How to move the first field of each r... DFSORT/ICETOOL 5
Search our Forums:

Back to Top