DSXchange

I have Db2 Client installed on the ETL server and I am able to connect to Db2 database through Db2 Client on ETL server.

Now, this should be sufficient condition to use API or load stages right?

Thanks For your replies,

I was referring Db2 Bulk loader.

Now, can I trigger Command line load from Database stages? (ODBC Ent Stage) Can I use Db2 bulk load mechanism with Command line load?

Hi, We are planning to use ODBC Enterprise stage to load data into Db2 databse. Can any of you please clarify what data loading mechanism does ODBC enterprise stage uses? Is it SQL loader or Database Insert (in which chase Db2 fires inert query for each row). Due to OS Version mismatch on ETL server...

Hi Istsaur, Thanks for your reply. I have given full permission to /root/.bashrc. Currently its permissions are _RWXRWXRWX is there some other problem with dsenv? I have defined PATH in below manner. LD_LIBRARY_PATH=$APT_ORCHHOME/lib:$LD_LIBRARY_PATH PATH=$APT_ORCHHOME/bin:$PATH I am not sure what e...

After trying various things I figured out this problem is not really with ODBC connection. It is with Datastage not being able to get correct Env settings. Following is the Entry in my job log for the Env setting strp before it kicks off the job. Following are the entries from the log where it is ha...

Yes it creates the directory /home/dsadm/Ascential/DataStage/DSEngine . I have tried return it does not work. Then I tried killing the process ( I found PID with ps -ef |grep ade) Once I killed this process It throws a message do you want to continue instllation? and if I say Yes it will cotinue but...

I have given full permission to user dsadm.

Also I could not find file .bashrc under /root

Hi, I am trying to set up ODBC connection from Datastge 7.5.2 on Redhatt linux 3.0 to Db2 8.0 on Redhat linux. I did set up .odbc.ini , dsenv in $DSHOME and uvodbc.config in project directry. I am using Db2 wired protocol and have set up all the files accordingly. I have checked the connection throu...

Hi, I am trying to install Datastage 7.5.2 on RedHat Linux 3.0. I am facing problem where in installation just does not continue and halts at a particular steps in between. I have tried multiple times and every time it halts at this same step. I am able to provide all required details for the instal...

Hi All, Hope you are all having nice time in Holiday season. Can you please let me know how can I concatenate 2 filesin Server Ver on Windows Ver. I have a requirement to read mutiple files which have same metadata and process them before loading into Target DB. Note: Those files are generated by an...

Here is the resolution to this problem, I used SDK routine DataTypePicComp3 to convert comp3 into integer. I got it working only after reading the packed decimal field as BINARY from the source though it is defined as CHAR in the table. I just went ahead and changed datatype from CHAR to BINARY in D...

Thanks for your comments Precious. I have option of using CFF stage as well. I can take a dump of tables into a flat file and then read data through CFF stage. But like I said source field is defined as Char(2) how do I set up CFF stage to read this comp-3 field? I tried setting up this field as dec...

Hi All, I have posted this before, I am posting with some more information and a little different scenario, which could help me to get solutions faster. I am trying to read DB2 table (Db2 on mainframe) which has Packed decimal data (Comp-3) stored in CHAR (Char2) field. I am using Db2 API stage to r...

Will API stage automatically unpack the packed decimals stored in CHAR field?

At this point I am restricted to use ODBC, is there any way it could be done in ODBC stage?

I am trying to read DB2 table (Db2 on mainframe) which has Packed decimal data stored in CHAR field. I am using ODBC stage to read data. When I import table definitions, te field is defined as CHAR and 'view data' shows some un-readable data in the field. Now, how can I read that packed data from DB...