DSXchange

The explicit hard-coded value for APT_CONFIG will take precedence and that job will run with that config file.

The instance name tab isn't initially visible, in the Oracle stage Input Properties tab click on "Connection" in the left pane and you will see "Remote Server" on the right drop down list.

That doesn't look quite right and didn't help much, please try CALL DSLogWarn('Command "':DB2Cmd1:'" returned status ':ErrCode:' and screen output "':ScreenOutput:'".','') My first guess is that DB2CMD is not in the path for your shell; but the output of the debugging sta...

nkreddy_3 - are you also working on the same file and problem as the original poster? If not then we should wait for the original poster to reply if his/her file has empty or zero values.

nkreddy_3 - You see what effect stating that your problem needs the attention of DSXchange "ASAP" has? It means that many people who might otherwise have responded haven't done so. DSXchange is an all-volunteer site and in order to get immediate and professional attention you would need to pay far m...

rubik - the original error posted was "The current soft limit on the data segment (heap) size is less than the hard limit, consider increasing the heap size limit"; so how can you be getting the same error message after setting it to unlimited? Or is this another error that might best be covered in ...

The syntax in DataStage is quite different from UNIX regular expressions. The FMT() function can cover much of what is normally needed. The DataStageBASIC Reference Guide guide discusses both the FMT() function as well as the conversion options with OCONV/ICONV

I would call up ExecSH in the sequence to display the file, then parse the return string into the correct format in a variable and then use that as the delimited list.

Mystuff - what was wrong with my suggestion? It worked on my system.

You could round mathematically, i.e. INT(In.DBLCol*100)/100 or use an interim Decimal data type with 2 decimal places.

Good on you, I am certain that you can do this in DataStage.

But if you want help in doing this, you need explain exactly what it is you are asking - what stage, converting from what type to what type?

How about just redirecting everything, try

Craig - I just had to recheck and saw that I missed your post. I think that yourself, Ray and I concur that "it depends". This is a polite way of saying that any answer to this question depends upon the context and the way it was posed leads to ambiguous answers.

I wonder if you get an error if you set APT_DISABLE_COMBINATION to true; perhaps these two modify stages are being optimized to just one at runtime.

Do a derivation of