Search found 24 matches

by reshma11
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.
by reshma11
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.
by reshma11
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...
by reshma11
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...
by reshma11
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 ...
by reshma11
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...
by reshma11
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

Mike wrote:Ask the routine creator where to find the source code. The parallel routine definition will only tell you where to find the .o or .so file.

Mike
Thanks. Yes, I opend the .c file and able to read the code.
by reshma11
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?