Search found 35 matches

by Madhusv
Wed Sep 28, 2005 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringToDecimal
Replies: 3
Views: 2862

Hi Nagesh, Thanks for the Reply, Case 1:The Problem is If data is blank means data is having spaces,beacuse the record is of fixed width, Also if blank/space is there iw ant to set that to NULL(Not to 0.0). Case 2: Here from source i am splitting this field(9) into two fileds one is of 1 and another...
by Madhusv
Tue Sep 27, 2005 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringToDecimal
Replies: 3
Views: 2862

StringToDecimal

Hi All, I am getting the below error while converting from string to decimal. Case 1: APT_CombinedOperatorController,1: A numeric string was expected, got " "; using Decimal, the default value. String Data Type: Char[6] Decimal Data Type: Decimal[11,2] I am getting this warning only when t...
by Madhusv
Mon Sep 19, 2005 5:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate Entry +Lookup
Replies: 2
Views: 1675

Hi,

Source is coming from join stage also in db2 stage i am taking distinct of the key coulumn, I think the problem is with32 lookups, if any one has faced similar situation, Please let me know.

Regards,
Madhu
by Madhusv
Tue Sep 13, 2005 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Duplicate Entry +Lookup
Replies: 2
Views: 1675

Duplicate Entry +Lookup

Hi, I am using the lookup stage in which lookup is happenning for 32 fields, I am getting the below error, I couldn't make out from which link duplicate entry is coming, i have selected mulitple rows returned from link option for one link, Still i am getting the same error. Another thing is 31 looku...
by Madhusv
Tue Sep 13, 2005 4:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MEssage Text,Message ID from Log
Replies: 2
Views: 876

MEssage Text,Message ID from Log

Hi,
Is there any method get the message generated based on the message id that got generated in the log when the job is run.

Thanks,
Madhu