Search found 3 matches

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