How do i import table definitions from DB2

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
RakshaPai
Participant
Posts: 35
Joined: Fri Jun 15, 2007 11:21 pm

How do i import table definitions from DB2

Post by RakshaPai »

Hi all,

is there any way to import a DB 2 table definition? i checked all options but none specify about importint DB2 table defnitions.

Thanks in advance!
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

In the manager do a Import -> Table Definitions -> Plug-In Meta Data Definitions and choose your DB2.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Or (and maybe better) in Manager choose Import > Table Definitions > Orchestrate then choose the third of the three options offered, the one that allows you to use orchdbutil to import the table definition. This will open extra fields in which you can supply the connectivity and authentication information for DB2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RakshaPai
Participant
Posts: 35
Joined: Fri Jun 15, 2007 11:21 pm

Post by RakshaPai »

Thanks Guys....

Will try out both :)
Post Reply