Search found 24 matches
- Tue May 19, 2009 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to get all flat files into one flat file
- Replies: 6
- Views: 2496
Need to get all flat files into one flat file
I have a requirement that I need to get all the output flat files into one flat file separated with file name. Can any one help me on this how to get this done.
- Thu Apr 09, 2009 1:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while viewing data
- Replies: 1
- Views: 1059
Error while viewing data
Error when I am trying to view the data in the sequential File stage input properties page.
The following is the error message
Error executing View Data command:
##E TOIX 000139 15:18:52(019) <Seq_SE_Demo_IR> Import validation failed.
Any help would be appreciated.
Thanks.
The following is the error message
Error executing View Data command:
##E TOIX 000139 15:18:52(019) <Seq_SE_Demo_IR> Import validation failed.
Any help would be appreciated.
Thanks.
- Thu Mar 26, 2009 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to check the condition?
- Replies: 3
- Views: 1316
Re: How to check the condition?
Like this in mapping document :-- Populate with MPS.CHN_T1.CHN_STAT_DTE if T5_CUST_MERCH.MERCH_PRNT_CHN_NBR is not null and the Chains status code is closed (MPS.CHN_T1.MCT_STAT_COD = 'C'). Otherwise set to '99991231' I have stag variable called svChnStatDate: - If IsNull(In_Amex_Chnt1_Demo.CHN_STA...
- Thu Mar 26, 2009 6:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to check the condition?
- Replies: 3
- Views: 1316
How to check the condition?
Like this in mapping document :-- Populate with MPS.CHN_T1.CHN_STAT_DTE if T5_CUST_MERCH.MERCH_PRNT_CHN_NBR is not null and the Chains status code is closed (MPS.CHN_T1.MCT_STAT_COD = 'C'). Otherwise set to '99991231' I have stag variable called svChnStatDate: - If IsNull(In_Amex_Chnt1_Demo.CHN_STAT...
- Wed Mar 18, 2009 10:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handling Null for a Concatenation column
- Replies: 3
- Views: 1613
Handling Null for a Concatenation column
I have two source columns like AGT_PHN_INTL_PFX length 3 nullable yes, and second one AGT_PHN_PHN_NBRlength 25 nullable No. I am trying to concate these two columns in the transformer derivation like AGT_PHN_INTL_PFX : AGT_PHN_PHN_NBR. In the target sequential file these two column values should be ...
- Fri Feb 27, 2009 10:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: invoke vi from the DataStage system prompt
- Replies: 3
- Views: 1177
invoke vi from the DataStage system prompt
How do I invoke vi from the datastage system prompt?
- Mon Feb 16, 2009 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit conversion from source type "decimal[38,10]&qu
- Replies: 3
- Views: 3412
Implicit conversion from source type "decimal[38,10]&qu
I am getting following warning message for a copy stage in the job when i am running. Rej_Cp_T5_SalesChannels: When checking operator: When binding output schema variable "outRec": When binding output interface field "ORD_SEQ_NBR" to field "ORD_SEQ_NBR": Implicit conver...
- Tue Jan 13, 2009 9:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom Routine
- Replies: 2
- Views: 876
- Tue Jan 13, 2009 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom Routine
- Replies: 2
- Views: 876
Custom Routine
How can I see a custom routine code, created by somebody else in parallel jobs?