DSXchange

Select the Stage Types branch of your Repository, choose New Parallel Stage. Fill in your C++ code on the appropriate tabs. Use the stage in a job design.

PIC 9(10) COMP-3 won't fit into an int32. If you need integer you will need int64. Or a decimal data type with sufficient precision.

Keep in mind that a saturated network can also cause this symptom. I was at a site in India during the World Cup Cricket and things were abysmally slow - the reason was 75 developers all watching the (live) cricket in their Internet browsers. No bandwidth left in the LAN.

Make sure you really are sending it a NULL, not "" (which is not the same thing) or some default value where the year is out of range.

Welcome aboard. :D Think about what Pivot stage is doing. It takes a lot of resources, particularly memory, for processing a lot of rows. There is nothing you can do about that. You can create your own Build stage to pivot your data according to your specific requirements, which removes all the nece...

An XLS file is not amenable to being read by a Sequential File stage; for a start it potentially contains multiple worksheets. If you have a UNIX-based ODBC driver for Excel you can use that. None ships with DataStage. Otherwise you need to save the worksheet as a text file (.TXT or .CSV) and proces...

Right click on the column in the Columns grid. Choose Edit Row from the menu. In the bottom left corner you will find Vector and Subrecord. Once you have chosen Vector a new column called Occurs appears in the Columns grid.

Best practice is to detect all knowable reject conditions before presenting rows to the database tables. It is much easier to deal with them if you do. You end up with a design that generates many fewer warnings, and then only when something unknowable (thanks Mr Rumsfeld) happens in the data or in ...

Same place: the folder specified by UVTEMP in the uvconfig file.

Provided you've been diligent with your metadata management, all you need to do is to select the table definition in the Repository and perform a Usage Analysis.

Installing NLS will definitely help, but it may not be necessary. Even with accented characters the western European languages should be able to be handled as a single-byte ("extended ASCII") character set. Please reset the aborted job in Director, then post any warning messages from the aborted job...

Have you investigated generating a "here script" as I suggested earlier?

Sort stage, as Ken suggests, is available in server jobs. But it's slow. If you have a DOS command line sorter available, it may be preferable to use that, perhaps as the Filter command in a Sequential File stage. Other possibilities include a UV stage (or any other database stage) - load the data i...

You need to check that the DataStage bin directory's pathname is one of those in your command search list - that is, your PATH environment variable. Temporarily you can include it. PATH=%PATH%;"D:\Program Files\Ascential\DataStage7.5\bin" Ultimately you want to make the inclusion more perm...

Then, as well as write permission on the client, check that you have a goodly quantity of free disk space on the drive on which DataStage client is installed. You might also search the forum for the exact error message.