DSXchange

Are you logged in as qsadmin when starting qsrtmngr?

U did not respond. (U is the name of one of our posters. I understand that it is a fairly common Burmese name.) The second person personal pronoun in the nominative or accusative (objective) form in English is spelled "you".

You can find this error code in the DataStage BASIC manual, in the section that describes the STATUS() function. Having done so, please post the result of your researches.

IBM offers a training class. It is not routinely scheduled, so you will have to ask your local IBM Learning Services people about it.

Some sites use the DataStage export file (the DSX file) as the "source code" for the purposes of version control tools.

When you get to version 8.1 of Information Server there is a useful deployment tool available with - among other things - a command line interface.

Not possible. The ODBC driver for Excel requires absolutely that the first line is column names. This is not a DataStage issue; it is a rule in the ODBC driver.

Change the Hashed File stage to use Account (not Directory) and refer to the VOC entry that you created with SETFILE.

You do not want to convert to NULL, you want to convert to zero-length string.
Initialize stage variable svLF to Char(10) and do not supply a per-row derivation expression.

Can you try setting a job parameter (perhaps called jpHighDate, of type Date) to 2999-12-12 and using a reference to that job parameter in the derivation of expiration date?

Have you set the expiration date for the expiring Type 2 change record ? This is usually derived as CurrentDate().

Transactional (also called "real time") mode requires that the QualityStage Real Time manager (QSRT manager) be running. This in turn requires that you have purchased the real-time interface (RTI) components.

It's set the same way that any other environment variable is set. For DataStage processes the command to set the environment variable should occur in the dsenv script. Examine the SHLIB_PATH variable's value for any regular user and/or consult your UNIX system administrator. It is almost unheard of ...

Why bother? You can do this from within Excel itself. Do it manually while recording a macro, which you can subsequently turn into a script executed by DataStage if that's the way you really want to go.

It would appear that this may be the case. Try it and let us know.

The output from dsjob -ljobs kamal will be a list of jobs in the project. In a BAT file create a loop that iterates through this list, executing the command dsjob -logsum kamal $jobname for each jobname in the list. Redirect output appropriately to capture the output wherever you require it. I am go...

You can automate the process by deleting those entries from the job's status table that pertain to the particular invocation ID. That would require, of course, a routine that determines the job's job number (to establish the name of the status table), and the invocation ID in question. Learn about t...