Search found 36 matches
- Fri Jun 25, 2010 5:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
- Tue Jun 22, 2010 4:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: adding new database to config and ini files...getting error
- Replies: 2
- Views: 2297
- Tue Jun 22, 2010 4:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
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...
- Tue Jun 22, 2010 1:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
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...
- Mon Jun 21, 2010 5:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
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 = *****...
- Mon Jun 21, 2010 2:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
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...
- Fri Jun 18, 2010 10:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC SQL SERVER special characters
- Replies: 11
- Views: 7815
ODBC SQL SERVER special characters
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...
- Wed May 19, 2010 2:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC connection for ORACLE
- Replies: 3
- Views: 3067
- Tue May 18, 2010 3:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC connection for ORACLE
- Replies: 3
- Views: 3067
ODBC connection for ORACLE
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.
I was just editing the .odbc.in file and uvodbc.cngf file.
- Tue Apr 27, 2010 2:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg:Fatal Error in the Datastage 8.1
- Replies: 3
- Views: 3960
- Mon Apr 05, 2010 11:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC plugin for sql server
- Replies: 0
- Views: 2003
ODBC plugin for sql server
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 ...
- Fri Mar 05, 2010 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc plugin
- Replies: 2
- Views: 2100
- Mon Feb 22, 2010 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: inserting data into db2 table partition by range
- Replies: 0
- Views: 1395
inserting data into db2 table partition by range
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?
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?
- Mon Feb 22, 2010 3:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: odbc plugin
- Replies: 2
- Views: 2100
odbc plugin
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 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?
- Mon Feb 22, 2010 3:51 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: insert into table using ODBC Stage
- Replies: 2
- Views: 16366