Search found 21 matches

by nekkalapudi
Mon Aug 14, 2006 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Error Failed to match node
Replies: 5
Views: 3106

Check whether the file is been written under each node pool. Try to recreate with another set of config file and try to do a lookup. Hi All, Sorry for the late follow up. I checked all the conditions and recreated the new file set and used. Still has the same problem. Did more investigation; actual...
by nekkalapudi
Wed Aug 02, 2006 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Error Failed to match node
Replies: 5
Views: 3106

Lookup Error Failed to match node

Hi, Created and used Lookup fileset using same configuration file: Failed to match node node2 (fastname colo-ascential-01) for LUT Fileset /opt/ds/dsdata/DEV/filesets/invmstr_lkup.fs Checked the forum and tried setting Preserve Partition flag to Clear. Still it's not working. any one have some info....
by nekkalapudi
Wed Aug 02, 2006 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Constrain is not working in Transformer
Replies: 6
Views: 2076

Re: Constrain is not working in Transformer

Hi, I have a fixed width char[30] field. This has some invisible characters. IsNull(), Trim(), substring none of them is working. I want to reject the records which have no value in it. How to check for hidden characters? Thanks, Hi All, Thanks for the information. Fixed the problem using trim : Tr...
by nekkalapudi
Tue Aug 01, 2006 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Constrain is not working in Transformer
Replies: 6
Views: 2076

Constrain is not working in Transformer

Hi,

I have a fixed width char[30] field. This has some invisible characters.
IsNull(), Trim(), substring none of them is working.
I want to reject the records which have no value in it.
How to check for hidden characters?

Thanks,
by nekkalapudi
Fri Jul 28, 2006 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to convert integer date (YYYYMMDD) to date
Replies: 14
Views: 19489

Re: Unable to convert integer date (YYYYMMDD) to date

All, Changed format. Every thing is working. Thanks for the information. Omkar Hi, I am trying to convert an integer date 20060706 to date 2006-07-06. Used Modify stage: - m_OHEDAT:date = date_from_string[%yyyy-%mm-%dd](OHEDAT) -- Output is NULL. Message:APT_CombinedOperatorController,1: Numeric str...
by nekkalapudi
Thu Jul 27, 2006 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to convert integer date (YYYYMMDD) to date
Replies: 14
Views: 19489

Unable to convert integer date (YYYYMMDD) to date

Hi, I am trying to convert an integer date 20060706 to date 2006-07-06. Used Modify stage: - m_OHEDAT:date = date_from_string[%yyyy-%mm-%dd](OHEDAT) -- Output is NULL. Message:APT_CombinedOperatorController,1: Numeric string expected . Use default value. Converted the integer to string still got the...