DSXchange

Unique sequence should be another topic.

There are two system variables that you can use, @INROWNUM and @OUTROWNUM (possibly added to a constant, which you can keep in a Stage variable).

This is a very common requirement. Your choices include a separate job to select the current maximum value from BATCH_ID_TABLE (ODBC stage), add 1 to it (Transformer stage) and update the value (BATCH_ID_TABLE). You can also use BASIC SQL Client Interface (BCI) functions if you have a licensed ODBC ...

Well, there's always DSStopJob(DSJ.ME), but it's definitely not recommended, as the job's status is then STOPPED and it would need to be reset before being eligible to run again. Best practice is to use two jobs, one to do the checking and one to do the remainder of the work, with their controller (...

&PH& is a directory. The message would have been in an operating system file in that directory. Or, the message may have been in the job log. Error code 911 represents a SIGSEGV (segmentation violation), which is a memory error. I'm surprised to see &PH& used in the same context. Unless there was so...

Usually the Template project is located as a sibling directory to DSEngine (that is, from DSEngine, you can cd ../Template). There should also be a file called Template.ini in the parent directory of DSEngine. Template.ini looks something like this: [Project] Location=/usr/Ascential/DataStage/Templa...

That said, most databases have an EXPLAIN command, so you can be advised of the execution plan. On this basis you might decide, for example, to add an index on a column that is constrained in your query. However, adding indexes slows down update times, so you can't just go adding indexes to your hea...

When you connect during the Import process, select just one table then click on the Details button. This should return a list of the column names in a message box. Also click on View Data. These will determine whether the problem is in what SQL Server is returning, or what DataStage is writing to th...

DataStage is perfectly at home with the idea of case under NLS. Definition of what is upper case and what is lower case and how to get from one to the other and back again are all part of the CTYPE category of the locale. For example, accented lower case letters lose their accents when converted to ...

You should not post this in the Looking for Talent forum.

The short answer, if you're on UNIX, is to use a filter in the Sequential File stage, running the file through tr. For example:

Clif Oliver has decided to close his list server at the end of March. It was the first DataStage "community" and archiving it here has formed the basis of a lot of valuable information available to the Search engine here. So a huge vote of thanks to Clif for the time and energy he has devoted to not...

Welcome to the Forum. As Ken said, the command that you need is dsjob.exe. The one you tried, Director.exe, is the Director client itself. The executable dsjob.exe is located in the bin folder within the DSEngine folder. The location of this folder is stored in your Registry, but there's an easy way...

I don't think Gartner fully appreciate that MetaStage is (can be) a product in its own right, rather that it's just a component of DataStage. It behoves someone in Ascential to educate them.

Quick response. Search for SMTP rather than SNMP. DataStage has its own inbuilt function DSSendMail, which is an interlude to sendmail() on UNIX or any other mail program. On Windows, a lot of people have had good experiences with blat. Again, search the forum for "email" and for "blat". It's straig...

Even just validating jobs in production will create the hashed files (32-bit only) associated with hashed file stages that have input links. The advantage of this approach is that you don't have to process any data. The disadvantage is that you can't create 64-bit hashed files, so would subsequently...

Using dsjob, the option is -ljobs.