Search found 5 matches

by kiran reddy
Wed Jun 08, 2005 1:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage
Replies: 9
Views: 5485

In my previous message I forgot to stress on using only single quotes for a string type using HANDLE_NULL
by kiran reddy
Wed Jun 08, 2005 1:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage
Replies: 9
Views: 5485

Hi, Modify Operator does not exactly behave as described in the PX documentation. If you have a chance go through the Orchestrate documentation. I am doing the same by HANDLE_NULL This would definitely work. Stat_Qanty = HANDLE_NULL(Stat_Qanty,0) Stat_Qanty = HANDLE_NULL(Stat_Qanty,value) for a nume...
by kiran reddy
Wed Jun 08, 2005 12:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABS() function
Replies: 14
Views: 14590

In fact I didn't find any such environment variables in our project. May be something we need to set it up now ! Thanks for your response. Also we were getting all -ve numbers from source, so I guess we didn't actually take a +ve number and check, but somehow we got into this mis-conception, Thanks ...
by kiran reddy
Wed Jun 08, 2005 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABS() function
Replies: 14
Views: 14590

ABS() function

Hi, I have a strange experience working with the abs() function. We have a reqirement that should take the absolute value of an integer and then rounded to two decimals. When ever we are geting some -ve numbers these are converted to +ve numbers using the abs() function, but it is loosing the precis...
by kiran reddy
Wed Jun 08, 2005 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Insert and Update rows count
Replies: 4
Views: 2433

Re: Getting Insert and Update rows count

I think using the change capture stage will solve this.