DSXchange

What does the date look like in the text file?
What is your default date picture for Oracle?

RAS is a new variable in the equation. So, if I understand correctly, you are dialled in to your corporate network, and trying to effect the installation and connection on a machine in that network? Is that machine also your RAS server?

Program sources, for server jobs, are the generated BASIC routines resulting from compiling Transformer stages.

That's about it, though you might like to format the result. For example do you need no leading zeroes on the hour component?

No.

Though the Omit (connect via Windows LAN Manager) will obviously be available, since the DataStage server is on a Windows platform. It may be this that's fired your neurons.

There is an additional property that you have to set to allow the use of a reject link. However, such a reject link can not capture bad rows from sqlldr. DataStage creates the control and data files then invokes sqlldr; control is actually passed to sqlldr. To determine what rows were rejected you n...

We still don't know what the solution to the "installation error" was.

Try specifying the IP address rather than the host name. Tell us whether that works. Also verify that DataStage is running on the server.

TMPDIR is on the conductor node only, scratchdisk is per processing node. Scratchdisk is explicitly used by stage types that exceed their memory allocation; TMPDIR is more generically used, and occasionally is used for files unrelated to memory allocation. There is also UVTEMP, used by server job co...

Unless your test environment consists of protected projects there's nothing to stop you connecting to them with a client tool and effecting a multi-job compile that way. Of course, as others noted, you can obviate the requirement completely by exporting and importing the job and routine executables.

If you use Sort mode it's a reasonable assumption, per partition. There's nothing to guarantee that the overall Data Set is sorted - you would need either a Sort Merge collector or a sequentially executed Sort stage to achieve that. If you use Hash mode it's not a reasonable assumption; the output o...

DaysSinceFromDate() is a Transformer stage function, not a Modify stage function.

The Combine Records stage combines identically-keyed records from its single input into a single record containing a vector of subrecords.

There's a problem with dsenv.

sh: OME/java/jre/lib/PA_RISC2.0/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:/opt/cobol/lib:/usr/dmexpress/lib: not found.

It appears to be an incomplete (or broken) line when setting LD_LIBRARY_PATH

You don't seem to undertand how the command search path works. You must provide the pathname of the executable even if you are in its parent directory unless that parent directory is in your command search path (the PATH environment variable). Thus, if you are in /opt/product/Ascential/DataStage/DSE...