DSXchange

So it seems like this is issue with the odbc driver then and need to upgrade to fix pack 2.

1. make sure you catalog the db2 db in the remote server and that you are able to connect to that datbase.

I Have checked my odbc file and i noticed that my coworker setup the odbc setings for the sql server database to use : Description=DataDirect SQL Server Wire Protocol driver and there is thisparameter that i never use or when i set up the other odbc connections is call QEWSD=39927. What is this para...

I checked all the parameters---the only parameters the job has are just the connection credetials to both databses db2 and sql server. I dont understand if the sequence job could pass the wrong parameter i shoud have getting connection error to the database instead of data issue when writing into th...

my sequence job pas the paramters as pre-defined. db2_CONNECTION=(As pre-defined) ODBC_SQL03=(As pre-defined) and the starting event job: db2_CONNECTION = (As pre-defined) db2_CONNECTION.$DB = DW (Compiled-in default) db2_CONNECTION.$DBUSER = db2as (Compiled-in default) db2_CONNECTION.$DBPWD = *****...

Ray, thanks for your reply. I did your suggestion but file looks fine. After troubleshooting I find out that when i run the job manually it runs fine, the data gets insert it fine in the sql server (odb stage) table. but If i kick the job using the existing sequence job, here is where the job acts a...

Hello!! i am running into weird behive in one of my datastage server job. I basically have 4 stages (db2 udb (pull data from db2 table)--> transformer(trim the data)-->sequencial file-->odbc sql server table. so most of the time the job runs fine and move the data properly but there some other times...

why ODBC. because we dont have the oracle client software installed on the server. so I guess i will use the ORACLE Wire Protocol instead.
Thanks

I am trying to setup an odbc connection to connect to an oracle database. I have been researching just for my understanding do i need to install the oracle client in order to odbc to works?
I was just editing the .odbc.in file and uvodbc.cngf file.

ds_sai : you right, this error comes up after checking range lookup.

is anyone knows if we can use the same odbc driver to connect to any sql server database. I am running into this issue (have job that move data from db2plgin to odbc plugin -sql server 2005) and randomly the job add extra characters into the sql server 2005 table. so i am wondering if i need to use ...

so i think is has to be somthing with the NLS from the ODBC stage plugin.
you guys know how to determine wich type of NLS for each plugin to use?

Hello there,
i have an issue trying to insert data into a db2 table that is defined by partition by range. for some reason the db2plugin seems to hung and dont do anything; not inserts. just wonder if that is a bug on the datastage or soemthing?

Hello,
I have a server jobs that is pulling data from a DB2 plugin --> inserting it into odbc stage --sql server table. for some reason the odbc stage is if the source column has a null value the odbc stage will insert a special character. do i need to change some settings so i can avoid this?

i am using datastage enterprise edition. and my job is a server job. if ia m in the wrong forum is there anywya you can transfer this one to the server o should i close it and create a new one on server forum?