DSXchange

First, get yourself a copy of UniVerse. Since 2000 UniVerse (the database product) has been owned and sold by IBM, and DataStage is a separate product. Technically, therefore, and even though the executable is called uv, we should be referring to DataStage Engine.

Welcome aboard/bienvenue. :D

Add APT_DISABLE_COMBINATION environment variable as a job parameter in your job, set it to True, and re-run the job. This will help to diagnose in which stage the problem occurs.

If you are using DataStage to put the file in the Data directory, you don't really need any of them. If you must, use the DataStage Metabroker.

Welcome aboard. :D The UniData 6 stage is certified only for UniData 6.0 as far as I am aware. Check with IBM, who own both DataStage and UniData. It may be that the stage works with UniData 6.1 but is not certified only because IBM believed there was no-one using the combination. Or they may need t...

This error message can also occur if the file has an empty line at the end. Search the forum; it has been discussed previously.

I assumed that the mention of the Data directory in the original post meant that the run profile had already been established, but it's a good point nonetheless.

Perhaps an all-NULL row does not get written into a bad file. Check with your Oracle DBA or Oracle documentation. Or experiment outside of DataStage.

1. Comparison is against the files that make up the USNAME rule set. Open the Rules Management utility (from the Tools menu) and expand the USNAME branch to see them. 2. Initially it will be marked as "unhandled". Most last names fall into this category. You can also get unhandled patterns. 3. Unles...

Did you export the routines as well? Or are you using old versions of the routines in the newer environment?

What exact version of DataStage? The Notification activity (there is no such beast as a Notify stage) was quite restrictive about what could be done prior to version 7.5, which led quite a few sites to create routines that invoked DSSendMail().

It is best to write a BASIC routine if you are not sure about the number of group of x you are about to get. False. It is easier to create a Transformer stage with that number of outputs, propagate the rows where the input value changes, and use stage variables to construct the output lines. The te...

You need an MQ Series server coresident with the DataStage server. This restriction will, I understand, be removed in the next (Hawk) release. Rachitha, MQ Stage is a DataStage plug-in (= optionally installed) stage that can read from or write to an MQ Series queue. If you want to know more about wh...

It doesn't matter. Iconv() is clever enough to work it out. All you must provide is the first "D" and the date component designators (for example "MDY").
This article may help to explain why this is so.

The message suggests that there are characters in your password that can not be processed by your NLS map (MS1252, US-English). Or this may be an incompatibility with Oracle's NLS mapping. Are you using the same settings for DataStage character mapping and for Oracle character mapping? What is the N...

Does the upper case string "QUOTECHAR" ever appear in the first nine positions of F1? And what's the value of F2?