Search found 46 matches
- Thu Oct 13, 2005 8:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Invalid string or buffer length. SQLSTATE=HY090
- Replies: 3
- Views: 4710
Invalid string or buffer length. SQLSTATE=HY090
Hi All. I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error - [IBM][CLI Driver] CLI0131E Invalid string or buffer length. ...
- Thu Sep 08, 2005 11:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: After-job subroutine
- Replies: 3
- Views: 1581
- Thu Sep 08, 2005 8:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ..<column name> not found in the view based input sche
- Replies: 3
- Views: 1824
- Thu Sep 08, 2005 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ..<column name> not found in the view based input sche
- Replies: 3
- Views: 1824
- Wed Sep 07, 2005 10:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ..<column name> not found in the view based input sche
- Replies: 3
- Views: 1824
..<column name> not found in the view based input sche
Hi - I am having a job that reads the xml data from RTI input stage and then processes it. The job runs fine in development environment. However, when I try to run the exact same job in a test environment, I get the error "..<column name> not found in the view based input schema.." for one...
- Sun Jun 05, 2005 8:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Px Insert Array Size for Oracle
- Replies: 3
- Views: 2096
What happened to the other rows? Were there any warnings logged about their being rejected by Oracle? Did you set up a rejects link to capture them? For so many rows, I'd counsel using bulk loader techniques. Datastage did not give any rejects or any warnings for this job. I would check with the DB...
- Sat Jun 04, 2005 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Px Insert Array Size for Oracle
- Replies: 3
- Views: 2096
Px Insert Array Size for Oracle
Hi All, We hae a Px job that inserts 6M rows. For this job we increased the Insert Array size to 100000. The job completed in less than 1/10th of the time it normally takes, but did not insert more than half of the rows. It did not give any error either. My question is what is the purpose of this pa...
- Fri Mar 04, 2005 9:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with RT_CONFIG file
- Replies: 4
- Views: 3085
- Thu Mar 03, 2005 1:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with RT_CONFIG file
- Replies: 4
- Views: 3085
- Thu Mar 03, 2005 12:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Structure of DS Tables -- DS_JOBS
- Replies: 16
- Views: 11471
- Thu Mar 03, 2005 12:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with RT_CONFIG file
- Replies: 4
- Views: 3085
Problem with RT_CONFIG file
Hi all- I am having problem with RT_CONFIG file for one of our jobs. I get the error "Cannot Open executable job file RT_CONFIG2196" whenever I try to open the job. Also the job is visible in manager and designer but not in director. Going thru the previous posts, I tried the following - 1...
- Thu Mar 03, 2005 11:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Structure of DS Tables -- DS_JOBS
- Replies: 16
- Views: 11471
Take another RT_CONFIG file/directory in your unix project and copy it to the errant/missing name. This will at least allow you to import the job or delete it. As I keep telling everyone, it's BAD to run out of disk space on your project. I am having a similar problem. I copied an existing RT_CONFI...
- Wed Feb 23, 2005 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Analyzing directory Hash Files
- Replies: 6
- Views: 3609
I am trying to run hash.help on a directory based hash file. I am running the following command from the datastage executable directory and getting the following error - /opt/ascential/Ascential/DataStage/DSEngine/bin> hash.help /files/cdo/ua/batch/shared/hash/HashLookup_POSN_1 Unable to open VOC fi...
- Tue Feb 15, 2005 2:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS7.5 new features PDF
- Replies: 3
- Views: 1872
Hi - Can you e-mail me this file as well.chucksmith wrote:Done. Let me know if this is the file you want.
Below is the e-mail address
anjanroy@yahoo.com
-Thanks
- Tue Feb 08, 2005 5:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error Calling Subroutine
- Replies: 15
- Views: 6724