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