DSXchange

They DO show up in the Message Handler Manager if you've got the right job open in the log and with the "messages handled" event selected.

So much for multi-tasking.

Still to figure out where in the Repository these are stored, but that's a question for another day.

Check out the Difference and Compare stages. Change Capture stage is really only preparing a structure that can be used by a Change Apply stage to reconstruct the "after" input from the "before" input. Compare stage generates a result (enumerated) and two subrecords containing the original rows. Dif...

And joining Rays class would be worth it. Good luck. Which class is that? There is an IBM class called Programming with DataStage BASIC that has not, as far as I am aware, been presented in more than three years. (Am I allowed to advertise here?) I do offer this kind of training, but it's on demand...

OK, you're forgiven. It's all part of the learning experience. Remember that probably more than 50% of this world-wide resource do not have English as their first language, so abbreviations of this kind are even more confusing. Contemplate if j started using French abbreviations for v.

It's created by right-clicking on the warning message in the job log, and selecting "Add rule to message handler..." then, in the dialog thus opened, choosing "add rule to local runtime handler for job jobname ." Apparently the message handler is stored with the job (or log) properties, not with the...

Which link is "left" and which is "right"? Maybe you need a right outer join?

They're not viewable in the Message Handler Manager.

A mixed bad approach is my recommendation for PX sites. Use the tools appropriate, if it's a shell script, SQL script, Server job, PX job, or blend of those. I understand that but i am not allowed to use server at the site. Thanks smita Challenge that decision. It is based on a false premise, which...

Is there any convenient way (that is, without hacking the Repository) to disable a local message handler for a job? That is, if one has created a local message handler (one that is not stored in the MsgHandlers directory), how can one disable its effect?

The FTP stage does not really support mget in FTP. A script gives you complete control over what you get FTP to do; it can still be invoked from DataStage (in a number of different ways).

There are six system variables there for you to use. Their names are @USER.RETURN.CODE and @USER0 through @USER4. They are automatically initialized to zero, but remain untouched by DataStage after that. You CAN use environment variables as job parameters in DataStage jobs. Beware, however, that som...

There are rules, documented in the ODBC API manual (Microsoft Press) about what are and are not legal identifier (table, column, etc.) names. The hyphen character ("-") is not legal in an identifier name. Hence your problem and your solution. The worst offender is Microsoft itself (publisher of the ...

Beware that your ulimit setting may impose a file size limit.

Either SHAD_UPDATE is not identified as a key column or there is an imbalance between the number of columns in your schema and the number of columns referenced in the UPDATE statement. This can occur when you try to update a key column; you need to work around it, perhaps with a synonym for that col...