DSXchange

What do wou want to do if it's still running? If you want to abandon execution for that hour, simply detect its current status and, if it is DSJS.RUNNING, simply don't issue the run request. If you want it to run every hour irrespective of whether it's currently running, then your solution must invo...

Welcome aboard. :D If you have it, it will be in the Docs folder with your client software. But you will have had to have purchased the XML PACK or some other PACK that includes the XML stages. The documents are also on the media via which that software was delivered, unless it was downloaded. Not s...

int8 stage variables consume only one byte - most of my 220 were int8

You do not have version 7.5x2 installed. This is the only version that permits parallel jobs to be run on Windows platforms. Other versions permit only development (design) of jobs.

This message is unrelated to choice of stage type.

Welcome aboard, and thank you for a useful first post. :D

Did you type the function name, or choose it from the Expression Editor? IsNull (and the other null handling functions) should be built in. Have you edited the DSParams file on the server to make them inaccessible?

What's wrong with loading the result from that query into a Lookup File Set, and using the same for performing your lookup? It's unclear from that SQL what key value will be being looked up, but I am confident you know which column that is.

You seem to have neither a database name nor a server name configured for the PSDB.

If you can be totally sure of that, then the job had not been compiled on B and there was no executable code. But you say that it ran successfully on B. There is an internal contradiction here.

Is there any reason you can't import the export from A into C, to see if that makes any difference ?

When you did the export from B you did not include job executables. The "error" is between the keyboard and the chair.

Virtual Data Set (control file name ending in ".ds") gives this way. Control files from virtual sets are in the $DSHOME.Configurations directory. These control files are not automatically, but are deleted when the job closes. Persistent Data Sets hang around until explicitly released. In the Data Se...

If you're prepared to wait for the next release , Hawk includes an SCD stage that does most of the work for you.

For single row jobs (such as select max(col) from table) a server job is probably faster, because its startup time is smaller. Using parallelism techniques in server jobs can handle surprisingly large volumes of data. However, the fact that parallel jobs can scale automatically is a big plus.i I'm s...

Oooppps please ignore the above query: Wrote the follwoing query in the filter stage without the 'IN" COL_NAME = 'Y' OR COL_NAME = 'BRZ' OR COL_NAME = 'KC' OR COL_NAME = 'T' OR COL_NAME = 'TK' AND SUBSTRING(ID,1,1) BETWEEN 0 AND 9 AND SUBSTRING(ID,2,1) BETWEEN 'A' AND 'Z' AND NOT SUBSTRING(ID,12,6)...

Status DSJS.STOPPED is "stopped because of operator request", for example Stop from Director, dsjob with -stop option, DSStopJob() invoked in job control code.