Search found 9 matches

by nPower
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...
by nPower
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

The peek, a sequential file, a dataset all produce the incorrect answer.
This job runs fine on a UNIX 7.5.1 installation
by nPower
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...
by nPower
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...
by nPower
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
by nPower
Wed Nov 29, 2006 10:58 am
Forum: General
Topic: number of running instances of DataStage Version Control
Replies: 8
Views: 6895

Thanks for your advice.

After a long discussion, we went for the option of having two separate machines with each of them having VC open logged to two different repositories. (This has the advantage of being able to do simultaneous check in and promotions :) )
by nPower
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 ...
by nPower
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...
by nPower
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...