DSXchange

I am seeing the same behaviour on AIX 5.2, but investigating it is way down on my list of priorities at the moment, with a major deadline looming in the project.

If you are working on a DataStage installation with a supported licence you are entitled to enrol on Ascential Developer Net. The only way that you can compile a parallel job that has been developed on a Windows-based DataStage server is to deploy the job design to a UNIX-based DataStage server on w...

If you are creating an output link to handle rejected rows you can specify 1 in the "Abort after rows" for it.

See page 15-19 and 15-20 of the Parallel Job Developer's Guide for full information.

I have searched the forum and determined that "official" support for Oracle 10g is in DataStage 7.5. I also found suggestions that Oracle 10g could be accessed from Oracle 9 clients. Has anyone used DataStage 7.1 (ideally 7.1r1 on AIX 5.2) to connect to an Oracle 10 database? If so can you please ad...

If they have identical layout, why not use a Sequential File stage? Apply cat * as the Filter command. DataStage uses the output of the filter command as its input.

Use your Administrator client Command window. The SETFILE command, if entered correctly, will work from there. It reports that a pointer has been established or that an error has occurred. If the latter you must not proceed until your SETFILE has been successful. A hashed file is a database table, s...

As a short cut, you CAN concatenate them together for sorting, if the character between is a decimal place character and you enforce five decimal places. Iconv(TheDate,"D...") : "." : Fmt(Iconv(TheTime,"MTS"),"R%5") This will sort as a ...

A large portion of the world does not use Julian or Gregorian calendar. For example, the Islamic (or Hijri) calendar is the official calendar in countries around the Gulf, especially Saudi Arabia. This calendar contains 12 months that are based on the motion of the moon, and has a year 354.36 days i...

Version Control became part of DataStage in version 5.2. Prior to that it was available as a third party product from the good folks who host this forum. Who still maintain it.

None of these approaches using stage variables can output the previous value, because all stage variables have been evaluated before any output link is processed. You could introduce an additional stage variable. svPriorValue svPrevValue svSeenAlready InLink.columnname <= svPrevValue And @INROWNUM <...

Most sites with which I've worked use a shell script started from cron. The script uses find to identify files (in particular directories) that haven't been touched for some time (7 days seems to be the most common) and removes them.

There's not a great deal of value installing a 7.1 server on a Windows machine (as you state in your text, though your heading suggests server on UNIX) if you're planning to work with parallel jobs. You can certainly design them, but you can't compile or run them. DataStage clients connect to the Da...

This message indicates that there is an edit (read for update) lock on the job design in the Repository database. It may mean any of a number of things including, but not limited to: job open in another Designer session job properties open in Manager job being monitored in Director job being debugge...

You've made the reject file a fixed-width format file. You've specified a display (storage) width for the column Exchrate to be 16 characters. You've specified a NULL-replacement string that is fewer than 16 characters. This is what DataStage is complaining about; you must follow the rules that you ...

Welcome aboard! :D This message is usually the harbinger of bad news. DS_JOBOBJECTS is the pivotal table in the DataStage repository, and this message suggests that it has somehow become corrupted. Or, perhaps, that you lack permission to use it (in which case you'd be getting lots of other errors t...