Search found 9 matches
- Wed Jul 25, 2007 2:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal calculations
- Replies: 14
- Views: 11074
Folks Thanks for trying, IBM are looking for a patch. To answer a few questions, I'll repeat what I've said before 1. The values are hard coded into the stage variables - initial value not deivation 2. The row generator is ther to provide a row not data so it doesn't matter that it doesn't support t...
- Wed Jul 18, 2007 1:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal calculations
- Replies: 14
- Views: 11074
- Wed Jul 18, 2007 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal calculations
- Replies: 14
- Views: 11074
Folks... Did I mention a database ? the job is a row generator to give me a row to process nothing more. then a transformer with 3 stage variables 2 with hardcoded values and a peek output for the 3 stage variables. it's a mock up of what i have in a real job, in an attempt to isolate the problem. N...
- Tue Jul 17, 2007 6:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal calculations
- Replies: 14
- Views: 11074
All columns are Decial (38,15) seems enough precision to me The values I supplied are examples not a complete list can't round as I don't know what precision I need on each one. Another one I've had is a = 10000.0 b = 1.245 This gives decimal places so no rounding would work as it should effectively...
- Mon Jul 16, 2007 7:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal calculations
- Replies: 14
- Views: 11074
Decimal calculations
I've got a problem multiplying 2 decimals and getting the right answer
3 stage variables a,b,c all defined as decimal 38,15
a = 1.254
b= 610097.000
c = a * b ====> 765061.637999999975424
close but not quite
Any idea how I can the right answer and maybe even why it gives the wrong one
3 stage variables a,b,c all defined as decimal 38,15
a = 1.254
b= 610097.000
c = a * b ====> 765061.637999999975424
close but not quite
Any idea how I can the right answer and maybe even why it gives the wrong one
- Wed Nov 29, 2006 10:58 am
- Forum: General
- Topic: number of running instances of DataStage Version Control
- Replies: 8
- Views: 6895
- Thu Nov 23, 2006 2:30 am
- Forum: General
- Topic: number of running instances of DataStage Version Control
- Replies: 8
- Views: 6895
Thanks for your replies. Yes, the repositories are located on mainframe and unfortunately, all the data has to travel through a very slow network :? Thanks for the advice, Version Control is really basic and non-optimal so I'm going to investigate other alternative such as ClearCase. So does anyone ...
- Wed Nov 22, 2006 10:25 am
- Forum: General
- Topic: number of running instances of DataStage Version Control
- Replies: 8
- Views: 6895
Re: number of running instances of DataStage Version Control
Yes, the way you've done it is one of the option. If I understand properly. you share multiple repositories from one instance of VC? But you have to log out and log in everytime which can take up to 15 min in our case :-( My idea was to to be able to check in code into two repositories simultaneousl...
- Wed Nov 22, 2006 9:48 am
- Forum: General
- Topic: number of running instances of DataStage Version Control
- Replies: 8
- Views: 6895
number of running instances of DataStage Version Control
Hello, I was wondering if anyone experienced this situation before... Version Control does not support multiple instances of itself running in parallel. So I created a copy of the versioncontrol.exe called secondversioncontrol.exe. I am now able to run two instances of VC sharing different repositor...