Search found 3 matches
- Mon Jul 16, 2007 2:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Rounding Decimal values
- Replies: 2
- Views: 1986
Re: Rounding Decimal values
Fmt(expression, "R10") Try above thig as well I use a Routine to Round Decimal values. The code is as follows Value and Digits are the paameters passed to the routine If Digits > 0 then Ans = FIX(Value, Digits) End Else Ans = FIX(Value/100,50)*100 End I also tried PRECISION 14 If Digits > ...
- Wed Apr 18, 2007 2:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-03113: end-of-file on communication channel
- Replies: 31
- Views: 16051
Re: ORA-03113: end-of-file on communication channel
I am not sure if below comments will help you or not. But on my pervious job I encounter similar issue after experimenting I found answer. Which data stage version you using. If you are using 6.0 then you will face this kind of problem with oracla9i stage. If you using oracla9i stage then you can't ...
- Wed Feb 28, 2007 12:51 pm
- Forum: General
- Topic: Reading a sequential file from an EE job into a server job
- Replies: 16
- Views: 6759
Re: Reading a sequential file from an EE job into a server j
I am not sure but one of the possibility that in parallel job you creating file as dos file and when you tying to view the file in server job you might be reading the file as UNIX file please check that you should create and read file as UNIX file.