Dear experts,
Thanks a lot for your kind replies and time.
Kind Regards.
Search found 74 matches
- Fri Jan 08, 2010 1:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter - String data type
- Replies: 7
- Views: 2727
- Thu Jan 07, 2010 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter - String data type
- Replies: 7
- Views: 2727
Craiga and Ray thanks a lot for your time and reply. Basically, I'm running a sequence and this string parameter value is an input to one of my jobs in the sequence. If by mistake the production team misses to provide the string value the job would abort. Is there any option in Director/DataStage to...
- Mon Jan 04, 2010 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter - String data type
- Replies: 7
- Views: 2727
Parameter - String data type
Dear Experts, In one of my jobs I have defined two parameters 1. CUST_ID - integer data type. 2. LOC_CD - String data type If I try running the job without giving any value for these parameter (at run time), I'm getting a small pop up window against CUST_ID as below: Error: Request CUST_ID must have...
- Fri Nov 13, 2009 7:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD Stage - compilation error
- Replies: 0
- Views: 1653
SCD Stage - compilation error
Dear experts, I'm trying to use SCD stage in DataStage Version 8.1 for the first time. I'm getting the following compilation error Invalid derivation for the SCD type 2 expired date column 'EXP_TMSP' - the correct derivation should be either a literal or SetNull() function call. Initially I searched...
- Thu Sep 03, 2009 4:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD Stage-Compilation Error
- Replies: 2
- Views: 2429
SCD Stage-Compilation Error
Hello all, I'm trying to implement SCD-Type 2 using SCD stage. (Version 8.1). Details: Source, Reference and lookup - DB2 tables source table has only one key column CUST_ID, generated by DB2. Reference table is not defined with any key column. But as per the business rule, If SourceTable.CUST_ID=Re...
- Thu Aug 20, 2009 3:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API Stage - Warnings
- Replies: 4
- Views: 6983
Hello Ray, Thank you very much for your time and solution. I have suppressed my warnings now. For the benefit of anybody who is facing similar issue: Steps to change Warnings to Info:(These steps are recommended only if the warnings are informational. Not for real warnings! :wink:) Step:1 - Goto Dir...
- Wed Aug 19, 2009 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API Stage - Warnings
- Replies: 4
- Views: 6983
Hello Klaus Schaefer thanks a lot for your valuable suggestion. Sorry for the confusion. Actually I'm using a DB2 Connector stage Under DB2 UDB category prior to DB2 API. The final stage in my job is a DB2 API stage referring to a different table. The table details given in DB2 connector stage meta ...
- Wed Aug 19, 2009 1:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API Stage - Warnings
- Replies: 4
- Views: 6983
DB2 API Stage - Warnings
Dear Experts, I'm using PX Version 8.1 and the following warnings are shown in the Director log against my target DB2 stage. DB2_TGT: [IIS-CONN-DAAPI-000253] Writing the WCHAR column CUST_ID into a CHAR database column can cause data loss or corruption due to character set conversions. DB2_TGT: [IIS...
- Wed Jul 22, 2009 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparison Error - PX Version 8
- Replies: 0
- Views: 798
Comparison Error - PX Version 8
Dear all, I'm getting the following error message when I try to compare two different jobs (Right click on the job and selected "Compare against..." option to do the comparison.) within the same project and both the jobs under the same folder. "The '$' character, hexadecimal value 0x2...
- Sat Jul 18, 2009 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format - Fatal error
- Replies: 8
- Views: 10138
Dear all, I have resolved this issue. :D I did the following: Step:1 Included two transformers Source column CRTDST_DATE - Varchar(10) Nullable YES TRANSFORMER1 ------------------- Stage Variable: Definition: svValidYMD char(10) Stage Variable Derivation: (Trans1Rec.CRTDST_DATE[1,4]:'-':Trans1Rec.CR...
- Tue Jul 14, 2009 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format - Fatal error
- Replies: 8
- Views: 10138
- Mon Jul 13, 2009 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format - Fatal error
- Replies: 8
- Views: 10138
- Mon Jul 13, 2009 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format - Fatal error
- Replies: 8
- Views: 10138
Date Format - Fatal error
Dear experts, The date value from source is expected to be in "yyyy-mm-dd" format. But one of the source files has different formats "yyyy-mm-dd", "dd-mm-yyyy", "mm-dd-yyyy".(Mixture of correct and incorrect formats). I'm trying to eliminate the incorrect form...
- Thu Jun 11, 2009 2:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date format - Log error - PX
- Replies: 5
- Views: 5817
- Fri Jun 05, 2009 7:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date format - Log error - PX
- Replies: 5
- Views: 5817