DSXchange

Then you need to ask that. That 'process to follow' is fully documented. As to your other qestions:

1) Depends on if your have MQ installed on your DataStage server or not, from what little I know, never having played with it.

2) That one should be obvious based on what you posted.

If you're asking if the Server Sequential File stage can automatically write EBCDIC and/or COMP fields, the answer is no. From what I recall, the PX stage can, however.

In datastage how to implement the audit logs mechanism :idea: When someone asks you to explain what you mean, you cannot simply repeat the same string of words over and over. You rephrase, you explain using different words, you go into details so people know what you need help with rather than havi...

ArndW wrote:Since the CFF stage is only for reading and that original SDK cobol routines come from me, I'll supply a COMP-3 conversion routine.

Nice! Not sure I knew that... but I do now.

Of course, really meant to mention that in my other post but somehow didn't.

Right, completely agree with your assessment of the non-involvement of the FTP stage proper.

True... but for converting from those types not to them, from what I recall.

You generally tune sql not loads but as noted, let's start with the gory details of what you are doing now, be it a bulk load or whatever.

Usually a Sequential File stage is feeding the FTP stage for a 'put' so I'm guessing that any 'resorting' may be coming from there if multiple nodes are involved.

There's no "port on the DataStage side" here, that is the one you need to have opened.

That sounds familiar... but one should still check to find out was it setup with as that default value is not guaranteed to have been used. Or just try it and then check if it doesn't work.

So, If I am understanding both the problem and Craig's explanation, the count on the hashed file link plus the count from the output link should equal the input count. If my understanding of the design is correct as well - that a reference hashed file of existing keys is checked and only new keys a...

There's only one output link from the transformer, so it doesn't really make sense to have it as a reject link. As noted, first double-check everything - that you are referencing the right hashed file, using a proper key value, etc etc. Then let us know what counts show in the monitor when you run t...

Sorry, any other option than aborting? No, not if you want the rollback to occur. Some stages have a 'Treat warnings as fatal' option you can check or you can run with a very low warning threshold (like 1 for example) but the job must abort. Or... I take that back. The ODBC stage does not enforce me...

OK, that I've seen before and I don't recall if there is a true solution for this or even a good workaround. For some reason PX really doesn't handle those embedded quotes well in a quote delimited string, don't know why.

Hopefully somebody else will chime in here.