DSXchange

With disjoint sets of keys Replace ought not to be a problem.

Matches is fine; but it uses an idiosyncratic pattern specification. A pattern is made up of a number of alphabetic characters, a number of numeric characters and/or a number of "don't care what type" characters. These are represented by nA, nN or nX respectively, where n is the number, or 0 for "an...

Could be that the doc_tool.mdb is Access 2000. Have you tried opening it directly from Windows Explorer, with the Shift key held down? This is a method for bypassing the auto-start macro.

Do you really need the Link Collector? DB2 will be quite happy with three inputs, so long as the sets of keys in each set are disjoint (so that there is no contention for locks). You may see substantial throughput gain as well.

Get help from someone experienced with scripts if you're not. Supply the variables as command line arguments to the script or through environment variables. Use shell variables $1, $2 and so on to retrieve the values of the command line arguments. Depending on which shell you use, you may need to us...

No. However they are stored in a file called DSParams. Search the forum for ideas.

Parallel jobs strictly enforce data types. You must make sure, using appropriate functions, that the data type of RUNDATE is correct, and that the data in this column do actually conform to data type.

New facilities in job sequences in versions 7.0 and 7.5 give you a lot of help in designing in recoverability. Plan what you need to do and design it in.

This post gives you a URL from which you can get the MQ Series manuals, from which you will be able to decode what 2024 means, which ought to give some insight into the cause of your problem.

That's a tricky one, because your job did not abort. It couldn't be started, because it was not in a runnable state. Is your execution rule "reset if required, then run"? There is also a problem with what you're feeding to the Notification Activity, but do solve the first problem first. After all, w...

Wrap your "code" in Code tags, use Preview to get the indenting right.
It's not easy to get a table definition from a spreadsheet; it would be way easier if you could dump it as a tab-delimited file.

I note in passing that this user has made 0 posts (as of today), and claims an expertise level of 5 for DataStage in the profile.

(server not yet available)

Welcome aboard. :D Job sequences (note, not sequencers) are a graphical mechanism for creating what's called job control routines. Batches are another way of creating job control routines, for a simple, one-after-another sequence of jobs. It is also possible to write your own on the Job Control tab ...

I vaguely recall that DS_JOBOBJECTS doesn't exist in version 4 - everything is in DS_JOBS. However, if you select everything with OLETYPE LIKE '%Input%' OR OLETYPE LIKE '%Output%' you will get fairly close. The nice thing here is you will have job name and job number immedidately available without n...