DSXchange

Tony, When I try to manually run the job, it stops with an 'abnormal termination' warning, only information listed in the job log. However, if I open the job with designer and go to the properties page of an ODBC stage and click on view data, I will see the correct data from the table. Or if I open ...

Guillermo,

You may want to try the checkbox for "Omit last new-line" on the format tab of the sequential file input tab.
This worked for me when sending files to IBM 390.

Steve

Good Morning, I'm receiving abnormal termination warnings when using both an ODBC stage and a native Informix stage to connect to the same database. I would like to retain this structure if possible, native connection for efficent stream flow and ODBC for multirow lookup. Does DS not allow multiple ...

Tony,
Sorry to keep rambling on here, but this might help.

How about establishing your bottom level parts by selecting all parts which are not within a sub-select of parent parts. That is obtain a list of all parts which are not the parent(s) of another part.

Then try what I listed above.

Steve

Tony,
If you have no way of telling when you are at the bottom level and able to look up, or at the top level and able to look down. Then you can't easily do what your tring to do. Cartesian product?

Steve

Tony, Do you have a way to identify the bottom level parts? Does each part row in your DB have only one parent(NHA), leading to multiple rows for parts which belong to multiple assemblies? If you say yes to these two questions, then the logic is fairly simple. Initialize the QPA for all base level p...

Tony,

How about trimming your key fields? If you press the view data button, do both sets of keys look to be the same format?

Steve

raviyn, For your first question, yes you can get around this problem. I assume you have already found the checkbox on the seq-file format tab for column headers in the first row. this will ignore the first row, but still cause an error if it is shorter than your regular rows. The possible patch for ...

Just throwing in my 2cents. Rounding, regardless of endpoints, requires logic to determine. Simple truncation alone can not be used for rounding. There is always a special case ie. it works for everything except 1.0 or 1.5, so logic is used to handle these cases. The fmt function mentions rounding i...

Tony, AFAIK you can only perform the multi-row lookup using an ODBC or a Universe stage for the reference source. We are planning on posing a question concerning this hash file functionality at our next users group. I have been experimenting with the multi-row lookup and can understand wanting to in...

Tony,

Thanks for the tip, I can now see the checkbox....just need to figure out how to get it all to work together.[:D]

Steve

Ray and Tony,

I was wondering if either of you know of a way to setup a multirow match to a hashed file? We are running DS 5.2 and I can't seem to find the multirow checkbox regardless of what I try.

Thanks for any help you can offer.

Steve