Search found 103 matches
- Thu Jul 22, 2010 4:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failure not passing NULL
- Replies: 20
- Views: 11833
- Thu Jul 22, 2010 4:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failure not passing NULL
- Replies: 20
- Views: 11833
- Wed Jul 21, 2010 12:37 pm
- Forum: General
- Topic: Frequent deadlocks
- Replies: 4
- Views: 2096
- Wed Jul 21, 2010 10:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer concatenate
- Replies: 3
- Views: 4208
If any of your three fields are NULL then your output is going to be NULL, bcause concatenation with NULL will result in a NULL. You will get the same length in the output only if your are concatenating CHAR fields. If you are concatenating varchar type fields then the length might differ. If the ab...
- Tue May 25, 2010 2:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance tuning in DS for Join..
- Replies: 4
- Views: 2721
- Tue May 25, 2010 10:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_STRING_PADCHAR - Varchar datatype
- Replies: 7
- Views: 7809
- Tue May 25, 2010 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance tuning in DS for Join..
- Replies: 4
- Views: 2721
- Sun Apr 18, 2010 9:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_DB2LOADER_TIMEOUT
- Replies: 1
- Views: 2617
APT_DB2LOADER_TIMEOUT
Hello, Some jobs keep failing for the error below. I set the APT_DB2LOADER_TIMEOUT to 5000 and still no luck. The target is a DB2 table and the job is attempting to do a db2 load. Failed opening fifo /Scratch/ordb216303200189da23_.013 after 90 seconds: No such device or address. Please review DB2 lo...
- Mon Jan 25, 2010 10:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_STRING_PADCHAR - Varchar datatype
- Replies: 7
- Views: 7809
- Mon Jan 25, 2010 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_STRING_PADCHAR - Varchar datatype
- Replies: 7
- Views: 7809
APT_STRING_PADCHAR - Varchar datatype
Hello, If I set the APT_STRING_PADCHAR=0x20 then it pads spaces to the character and varchar type columns as well. This is causing quite a bit of issue, because I want only the character columns to be padded with spaces. The varchar type columns are long and consume lot of space if padded with space...
- Wed Jan 06, 2010 10:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special Character - ^Ö
- Replies: 4
- Views: 2166
- Tue Jan 05, 2010 10:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special Character - ^Ö
- Replies: 4
- Views: 2166
- Fri Nov 06, 2009 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Different versions of DataStage on the same box
- Replies: 2
- Views: 1656
Different versions of DataStage on the same box
Can we have DS 7.5 and DS 8.1 installed and running on the same Unix box?
- Tue Sep 29, 2009 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure Stage - BigInt issue
- Replies: 1
- Views: 880
Stored Procedure Stage - BigInt issue
Hello,
I am unable use the BigInt column type in the Stored procedure stage and get the right results. Is it a known bug in DS 7.5.1A? The BigInt column always gets set to the maximum 32-bit Integer value 2147483647.
Thanks
I am unable use the BigInt column type in the Stored procedure stage and get the right results. Is it a known bug in DS 7.5.1A? The BigInt column always gets set to the maximum 32-bit Integer value 2147483647.
Thanks
- Fri Sep 18, 2009 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CONFIG_FILE
- Replies: 2
- Views: 1563
APT_CONFIG_FILE
Hello, One of our jobs failed during a join because the scratch space defined on one of the nodes got filled up. The rest of the nodes did not even come close to filling up. If I define additional file systems for scratch in that failed node will it scale across the rest of the file systems and henc...