DSXchange

There is a DataStage NLS manual. Read it.

This is your problem, not DataStage's. Learn about the command search path (PATH environment variable) - that is, about how to execute commands in the operating system.

MarkB's response is not correct for versions earlier than 8.0.

Sounds like your DataStage server was installed without NLS, or that you were not in the UV account when you executed the COPY command.

The answer is no. This is only possible by scanning the job log. DSGetJobInfo() can return the current (= most recent) job run's information.

What stage type are you trying to use to read from the Data Set? A Sequential File stage is wrong. You must use a Data Set stage, you must specify the exact pathname of the *.ds file that was created by an earlier job, and you must be using a compatible configuration file in the reader job to that u...

Yes, and you probably got the same error in the job run that aborted prior to your resetting the job. You still need to address that, even though you can ignore it in the reset run. Search DSXchange for the actual error message; others have had it (and solved it) before now.

Investigate using the START command with /MIN switch. I don't know if this will work, as I've never done it.

The command is dscc - Search DSXchange or the manuals for further information.

1. Learn DataStage BASIC programming language.
2. Create new server job, open job properties, enter job control code on Job Control tab. Save and compile.

Easy.

Welcome aboard. As you note, you can open the Reporting Assistant. You need to upload the jobs and table definitions from DataStage Repository to the Reporting Assistant. Then, and only then, will the information you require be in the Microsoft Access tables so that you can generate your reports. Op...

... because it is the only way to do a join within a server job. To nagarjuna900, we need to see an image of your Transformer stage. The only way the reference input can be red is if there is a key expression that is either missing or syntactically incorrect. Therefore, when you post the image, plea...

Nothing is urgent when, like Arnd, you're taking your leisure in the Caribbean.

Can you get these "special" characters (whatever they are) into the database if DataStage is not involved? What code page/map is the database table using?

Not possible. The status of each job is recorded in a separate table. Thus for 30 jobs you would need 30 SELECT statements. Don't do it. There's a perfectly good API available. You still need to cycle through all the job names, but it's easier to do in the API than in DataStage/SQL. Incidentally, Da...

Cool. Create a Switch, Filter or Transformer stage with 48 outputs.

It is not necessary that operating system user IDs exist. DataStage users can be created as ordinary Information Server users and the roles and credentials managed through Information Server. Such is the site where I am currently working.