Retrieving data from AS400 DB2 tables into DSEE
Posted: Fri Apr 13, 2007 12:49 pm
I am trying to connect to an AS400 system and retrieve data from DB2 tables using the
DB2 UDB API stage. After going through the posts in this forum, I have concluded that I need to do the following. I would appreciate it if anybody could correct/help me in this regard:
1)I need DB2 Connect installed on the Datastage server.
a) What is DB2 Connect? I am assuming that they are DB2 drivers for
Datastage. I am running Datastage on a Linux box.
b) Where can I install it from?
2)I need to change my dsenv file to add the path of where the DB2 Connect is installed. Exactly what is the line that I add in the dsenv file?
3)Configure the uvodbc.config file. There should be 2 entries for Collection and Location. What should they look like?
4)Catalog TCP/IP node? What is "Cataloging TCP/IP node"? How do I do it?
5)Catalog remote database? What is "Cataloging remote database"? How do I do it?
6)Catalog DCS database? What is "Cataloging DCS database"? How do I do it?
7)"Bind packages". What is "binding a package"? What package are we talking about?
8)Add an entry to the .odbc.ini file? What is the entry going to be? Do I add an entry for a specific project?
Thanks to anyone who responds.
DB2 UDB API stage. After going through the posts in this forum, I have concluded that I need to do the following. I would appreciate it if anybody could correct/help me in this regard:
1)I need DB2 Connect installed on the Datastage server.
a) What is DB2 Connect? I am assuming that they are DB2 drivers for
Datastage. I am running Datastage on a Linux box.
b) Where can I install it from?
2)I need to change my dsenv file to add the path of where the DB2 Connect is installed. Exactly what is the line that I add in the dsenv file?
3)Configure the uvodbc.config file. There should be 2 entries for Collection and Location. What should they look like?
4)Catalog TCP/IP node? What is "Cataloging TCP/IP node"? How do I do it?
5)Catalog remote database? What is "Cataloging remote database"? How do I do it?
6)Catalog DCS database? What is "Cataloging DCS database"? How do I do it?
7)"Bind packages". What is "binding a package"? What package are we talking about?
8)Add an entry to the .odbc.ini file? What is the entry going to be? Do I add an entry for a specific project?
Thanks to anyone who responds.