View previous topic :: View next topic
|
Author |
Message |
Susanta
Active User
Joined: 17 Nov 2009 Posts: 126 Location: India
|
|
|
|
How to use 'Move for DB2' to extract data from two table usnig join between them ?
Please help. |
|
Back to top |
|
|
Gijz
New User
Joined: 27 Nov 2007 Posts: 9 Location: The Netherlands
|
|
|
|
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 |
|
|
Susanta
Active User
Joined: 17 Nov 2009 Posts: 126 Location: India
|
|
|
|
Thanks. It worked. |
|
Back to top |
|
|
|