DSXchange

Assuming you're talking about server jobs with mult-instance capability checked, all you need to do is to use a dot notation: jobname.instanceID For example: dsjob -run -param database=test -param passwd=test ProjectName JobName.1 However, the error code DSJE.BADSTATE means that the job is not in a ...

My guess is that, somehow, you have managed to lose the table name from the link called DSLink1. This can happen when, for example, you switch to user-defined SQL and back again. Open the stage called ORAOCI8_0, then open the link properties tab (probably called Outputs) and check there for the miss...

SLEEP should work, though your text says 30 minutes but your SLEEP is only for 300 seconds (5 minutes). To diagnose, adapt your code as follows: 1. Put the following directive at the beginning of the code. $DEFINE TESTING 2. Wrap the SLEEP statement as follows: If (job$4$status = DSJS.RUNOK ) Then $...

A job activity runs job JOB1. There are two possible outcomes, success or failure (according to your specification; in fact other outcomes are possible). Thus there will be two output links from the Job Activity that runs JOB1. On one, which tests the Failed possibility, it leads to a Job Activity t...

You can use a Sort stage wherever you have a stream of data that you want to be sorted. However, there are typically more efficient means of sorting data than the Sort stage. For example (if you spend the money) you can purchase the CoSort plug-in from this site. Why might you want sorted data? Two ...

Use appropriate triggers in your job sequence to direct the logic of job dependencies. If you don't believe this offers sufficient complexity, you can create your own job control code, or hire a competent consultant to do so. There is no limit on what job control code can do within DataStage. Ray Wu...

Beware that you can also have a long-running after-stage or after-jon subroutine that can cause the job finish to occur well after the final row has been processed. Even DataStage itself can take a while to clean up, for example if you've been using write cache for large quantities of data in hashed...

You certainly can do what you want to do in a BASIC before-job subroutine, because a before-job subroutine is executed before any connections, files, etc., are opened. You create the Routine with type "before/after subroutine" (not the default of "transform function" - adjust on the General tab). Th...

The client tool is accessing a record in a table into which the DataStage job records the status of the job and of the active stages in the job (the stage status can be viewed using the monitor). If the job never got the opportunity to update this table (for example an after-job subroutine returned ...

1. A Merge stage reads data from two text files. Its output is the join of the rows from those two text files, as specified in the properties. The pathnames of the two text files are properties of the stage in a job design; the stage therefore does not support any input links. 2. The Sort stage does...

1. SAP Extract PACK is sufficient. It generates ABAP code, which is executed against SAP R/3. There are two modes for this. You obtain it from your DataStage vendor; there is a charge, which reflects the fee that SAP AG charges Ascential for certification of the PACK as being suitable to work with S...

It really depends on how you prefer to design your ETL. DataStage uses more of a top-down approach, where you visualise and model the data flow, then fill in the details of what data and where. I like its automatic management of metadata, too. Last time I looked at Informatica, it was more of a bott...

Miguel's answer is correct, except for the exceptions! Statements with multiple clauses (such as IF, READ, and so on) can have their clauses spread over multiple lines; though still one statement per line. If the clause-introducing keyword (ON ERROR, LOCKED, THEN or ELSE) is the final word on its li...

This kind of stuff is, as you're encountering, quite tricky. It depends on how the stage itself is written. Remember that 0x00 marks the end of a string in C. I'll have to give this some thought. Meanwhile, what does your support provider have to say? Ray Wurlod Education and Consulting Services ABN...

In this environment I would counsel you to take a good look at Parameter Manager (follow link from this site), which will allow you to manage your parameters wherever they occur. There is no really "best" method. In most cases a "native" connection (for example Oracle OCI for Oracle, Sybase OC for S...