DSXchange

Hi,
Iam using aggregator stage for calculating amounts. In the output iam getting small difference. Below is the example

Input Output
12.34 12.32
99.99 99.97
78.23 78.21
Should i need to change any options so that i can get acurate result...

Hi I have a doubt regarding the copy stage is it required to set TRUE or FALSE in copy stage properties. If so can you please mention the reason for doing so?? "Where you are using a Copy stage with a single input and a single output, you should ensure that you set the Force property in the st...

Hi I have a doubt regarding the copy stage is it required to set TRUE or FALSE in copy stage properties. If so can you please mention the reason for doing so??

Iam new to datastage and i came to know about sparse lookup. I tried to see that option in the Look Up Stage but i coudnt find it. Can you please specify me in brief how to specify and where in the lookup stage.

Thanks for the information Kryt0n. My problem was solved. But this is not due to the Packed decimal fields. Below is the problem and the solution I implemented to make it work. There are the 4 types of fields listed in the copybook and below different phases of changes I found for these fields. Cop...

What is your actual error - the heap size message is a warning, not a fatal error and might have nothing at all to do with your real problem. ... Iam using Datastage 8.1 and iam unable to read the cobol data and write it into the sequential files. Iam not flattening the arrays ,Removing the group c...

Was "S9(5) COMP-3" a typographical error? Can you do a "view data" from your DataStage designer (I am assuming the HEAP error is a runtime one)? Also, could you cut-and-paste the complete actual error message? Sorry it was S9(5) Comp -3 data i was reading from Mainframe to Seque...

Welcome aboard. If you import the "table definition" from a relevant COBOL copybook, then all of the required metadata will be there for you. As a general rule field sizes are fixed in mainframe data, so there is no field delimiter and no need for quotes. The record delimiter will depend ...

Hi All, Iam having trouble reading the data from Mainframe Dataset using the complex flat file. It has dataset S9(s) comp-3.( Datastage version 8.1.1) can you please help me with this issue. I had seen all the posts and followed everything but still it dint work for me.. Can you please speficiy 1.wh...