DSXchange

Either that or switch to 'wired' drivers, if they are available, as they don't require the client.

If you have the client, why not use the native stage for Oracle - OCI?

You can (mostly) do this via the Subject line when you reply and say that all is well with your problem.

Your input date for Iconv is not in 'MDY' format. It is in 'DMY' format, so your second attempt is more correct. I can't check right now, but your "[,A,]" qualifier must not be correct for that format. FYI - the only way to check on the status of these kind of conversions is to do it in a custom rou...

Keep in mind, the BCI functions require licensed version of the ODBC drivers to work. For folks with UNIX servers, anywho.

As posted elsewhere, simply have the job in your Sequencer twice, once to validate it every run and then another to run it if the validate goes well.

Welcome aboard! I have questions regarding an ODBC stage with 2 input links, both inserting into the same table. I can enter certain properties per input link, e.g. update action or transaction size. What happens if I define different transaction sizes for both input links (5000 and 1). Does the gre...

Just trying to point out that you don't need a special job to do it, that you can use your 'normal' first job in an 'extra' step at the beginning of your sequence. Truth be told, I'm not sure why in the heck else they have the 'Validate only' option to the Job Activity stage. Anyone have any other u...

Welcome aboard! One thing you could have done was post this in the thread you mentioned rather than start a new one on the same subject. The other thing would have been to simply monitor the answers they received and see if they made any sense, perhaps adding questions of your own. Check what I post...

Reread my post. If your first stage is a Job Activity stage set to 'Validate' your job, success or failure will tell you if the database is up or down. Have a 'Success' trigger go from there to another Job Activity stage that actually runs the job for real this time, and an 'Otherwise' trigger from ...

Do you remember some of the "topics" related to this subject matter? Searching for 'multirow' in this forum worked fine for me, returning several posts including this one on the subject, which contains some specifics. BTW, I am using ORAOCI8 stage to access the DB table. As mentioned above - you ca...

Tim, KeyMgtGetNextValue is an 'sdk' routine supplied with DataStage by Ascential. It reads a record from a specific hash file in the current project, gets the requested record (which holds a numeric value) increments it and writes it back to the hash. It's basically a methodology to generate surroga...

Sorry, I seem to have lost track of what Forum I was in and gave you a Server answer. My apologies if it isn't applicable.

Derivations are one of the places where Job Parameters should not be wrapped in pound signs. Try just using DSN in the function.

No need to shout.

Unless you could somehow transform one of the file formats to match the other (and then combine them into a single file) then YES the lookup is your only option.

Welcome aboard! :D

Not via DataStage directly. You'll need to handle this in your database itself. In Oracle, for example, via database links to the 'remote' database(s).