DSXchange

Clearing a hashed file at the end of the run does not gain anything because hashed files, by default, hang onto any disk space that has been allocated to them. You would need either to delete the hashed file at the end of the run, or to create a paragraph to clear then resize the hashed file. Either...

You must be in a project for the DS_JOBS table to exist. If you're in the UV account, there is no DS_JOBS table, which might indicate why you got the "DS_JOBS not found" message. Redirection using redirection operators does not work at the TCL prompt; instead you can use COMO (as already suggested) ...

Why not pre-load the "current" lookups into, for example, a Lookup File Set (that is, those with end date IS NULL) and perform business key to surrogate key lookups therein?

Substrings(x, 12, 19) returns a 19 character string, that may include fractional seconds if present. Did you want Substrings(x, 12, 9)?

DATA is a reserved word. Put it in double quotes in the Derivation column.

This is probably most easily solved with three separate targets containing some sortable keys to allow the data to be merged subsequently. What form is your source data in?

Using the Administrator client can you connect? (It uses a slightly different mechanism.) Otherwise, get into dssh on the server while attached to a project and enable server side tracing from the DS.TOOLS menu then try to connect a client. Disable server side tracing. The trace file will be in the ...

What you do from Director is an asynchronous stop request in much the same way that a run request from Director is asynchronous; the server will get around to it. It's akin to kill -15; there is a "grace time" in which the process in question can close files, drop database connections, release locks...

You leave out any piece that needs the C compiler and it's OK. That's because none of the other pieces needs a C compiler; they generate only OSH. Clearly, then, there's a compatibility problem between the C compilers on the two systems. You do have a C compiler on system B?

Welcome aboard! :D

You nailed it with "it doesn't matter so long as it's somewhere in $SHLIB_PATH".

Either machine is adequately configured for installation of DataStage server edition, presumably for a development-only role. The question, however, is one of legality; do you have a proper licence for the other installation?

Initially, at least, this has to be investigated by the Oracle DBA, who may need to drop and re-create the index. A search on this site for "unusable" or for -1418 may throw more light on what's needed for your information.

If you're using a Sequential File stage there may be an even easier answer. On the Columns grid scroll across to the right where there's a "contains line terminators" rule. The stage itself can handle this situation!

It's both. The line terminator for DOS (Windows) is CRLF. Two characters.

Tell us the exact error. Also tell us if you've included JOBCONTROL.H in your routine, where the DEFFUN for DSGetParamInfo() function lives. (It is not necessary to include it in a job control routine.) If there's no DEFFUN, the error is likely to be something like "dimensioned array not defined".