DSXchange

C++

mpunktmayer wrote:The example below was not real.
I tried to describe my problem as easy as possible.

ps. Never a good idea. Real examples get you real answers.

Yes. Of course the metadata will need to be correct, match the COBOL FD.

And just me being anal again but there's only one "I" in EBCDIC.

Also, this FAQ post may help as well:

viewtopic.php?t=143596

'Directly' in what sense? COBOL picture clauses are noted here and can be a little odd / confusing if you've never worked with them before. You are correct in that X is character and 9 is numeric but the addition of an S means the number is signed (+/-) so you have to account for it in the size. Tha...

1. CFF as that is exactly what it was built for.
2. Pretty sure you can read them directly but technically S9(4) would be a CHAR(5).

So not hung up or 'locked' but rather just... slow. From the full table scan each update had to perform.

That would have been my next question.

Excellent!

It's hard for anyone to say anything other than 'ensure there are no data issues that will cause rejects'. Look at why those 16 (that I assume you think shouldn't be) are getting rejected and see what you can do about them. Design issue? Settings? Data? If you need more help we would need much more ...

From what I recall, those 'errors' are normal when (for example) there is no matching master record and they would go down the reject link you should have in place. And apparently you should get 100 of them. Ignore them. Do you get the 100 that you want as well, not rejected? And the Merge stage req...

What makes you think you can't merge them? Have you tried? If you have and you had either errors or unexpected results, explain for us what you did and what results you had.

How would you call it if you weren't using DataStage?

You're not going to be able to design a job that dynamically adjusts the number of target tables. You can, however, design one that targets all known target tables where not all will actually receive data during any given run. And yes, the CFF can handle multiple record types but there are other mec...

Version.