DSXchange

You can issue the query SELECT * FROM DS_JOBS WHERE NAME = 'XYZ'; (or just SELECT JOBNO FROM DS_JOBS WHERE NAME = 'XYZ';) from within the DataStage environment on the server to determine the job number associated with a job name. This environment is no longer called UniVerse - it has not been UniVer...

Checkpoint information IS cleared if the job sequence completes successfully, and there is an event logged in the job sequence's log to inform you that this has occurred.

DSLogEvent() allows you to write to a job log from a different job or routine. You could, for example, invoke this from a Routine activity in a job sequence.

Have you considered a solution involving database replication services?

What error message is generated? I believe this to be a restriction in the database itself, not in DataStage. Check your UDB documentation for the timestamp (or whatever) data type.

Curious to learn how TO_CHAR could return a week number. What are the business rules that define "week 1 in a month"? (For example read post from dsguru2b.)

Are there any non-printing characters, such as tab, in the data?

Checkpoint information is recorded in the status file for the job sequence; that is, RT_STATUSnnn where nnn is the job number of the job sequence from DS_JOBS. Nothing else is documented.

Clearly no. What file name could be generated if the file name were to be based on a repeating element?!

Use Windows Task Manager to find whether or not a process called qsrtmngr is running. This must be looked for on the server machine, not on the client machine.

What exactly IS your problem? That's the third different problem you've posted against this thread.

If qsrtmngr is not running then you won't see it in a ps report.

How would you do it without DataStage? That method may be easier and faster than using DataStage.

Welcome aboard. :D How do you detect that a change has occured in db1? What kind of change detection mechanism do you use? Have you implemented triggers in db1? If so, can a trigger invoke an operating system command? To insert rows into two tables as a single transaction, you can use an ODBC stage ...

You need first to understand the message. Answer these questions. Which stage is involved? To what is "input port 0" referring? What Data Set is associated with input port 0? (Hint: inspect the generated OSH.) What setting have you given for partitioning on this particular input link? Why is tsort (...

Use a job parameter to supply the initial value for the cycle.