DSXchange

Correct.

It's the downside of having a GUI. If you were doing it all in code you could manage it, but it'd be more difficult to maintain.

Welcome aboard! :D
Please post the entire error/warning message.

You get the Orchestrate manuals when you attend a DS314PX class (DataStage Essentials - Enterprise Edition).

No, it means that the parent directory of the orchadmin command does not appear in your command search path (the PATH environment variable).

A is derived as If X = Y Then X Else ... B is derived as If X = Y Then Y Else ... You can't derive two stage variables with one expression - each has its own derivation expression. The mere fact that they're in a grid should make that clear. You've posted this in the server forum with a job type of ...

Static hashed files are also - by default - limited to 2GB.

To bypass the 2GB limit, you need to create hashed files - dynamic or static - with 64-bit internal pointers rather than 32-bit.

The argument for one stage type over another is identical to the argument over one loading method over another. In most databases bulk loading is faster, or much faster, than INSERT statements. On the other hand, most databases don't have an update/replace mode for their bulk loaders. You choose the...

The easiest way is to use the dssh or uv command in the project directory. This can take a double-quoted command (query) as its command line argument. You may need to have set environment variables first by sourcing the dsenv script. . $DSHOME/dsenv $DSHOME/bin/dssh "SELECT NAME FMT '32L', CATE...

It's downloadable from ADN - you can find a link to the Orchestrate manuals by searching here at DSX.

You can't do "AS CHAR(12)". It's not legal as an alias. You use a CAST specification (if necessary) to change data type temporarily. The result of concatenation is necessarily string, so it's probably not necessary in that case.

That's very clear in the VC manual. It's called "initializing".

The DataStage Repository is a database. Like any other database it must be queried using a query language (for example SQL) within its own environment.

You can wrap this in Perl or any other scripting language, but you still need to know how to construct the query.

"So do i have to specifically be a member of the local Operating system group Administrators to log in or is there any other way?"

No, not to log in. But you do need to be in the Administrators group (which user dsadm should be) to perform administrative tasks, such as controlling security.

In the Table Definition in the Repository edit the SQL types to what they should be. Then reload the table definition into the job so that there are no "Unknown" data types.

Line terminators are converted to field marks (@FM) when captured.