Search found 21 matches
- 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...
- 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....
- 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...
- 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,
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,
- 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...
- 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...