DSXchange

I'm reminded of nothing more than the PHB who wanted a document faxed on green paper. My response to the customer would be to ask why a "pure" PX solution is required; doesn't the fact that you can use a BASIC Transformer stage directly from the PX palette mean that you have a "pure" PX solution? Cu...

Iconv() and its partner function Oconv() are primarily for server jobs. You posted your query in what it intended to be the server jobs forum; I know you are aware of the parallel jobs forum because you also post there. These BASIC functions are available in PX (parallel jobs) but only in limited ci...

Don't do it at all during execution. One of the fundamental principles of performance is not to impact performance by trying to measure it. These statistics are collected for you. You can get them from "active stage finishing" events in the log (using BASIC code if you must). Why not just invoke the...

Welcome aboard! :D I'm not sure you can do this with dsjob as supplied. Director client sends a request that constrains on invocation ID, but I'm not aware that this capacity exists in dsjob . You can view source code for dsjob in the Server Job Developer's Guide (servjdev.pdf), since dsjob was orig...

Not every ten digit number is an integer.
The largest (four byte (32 bit)) signed twos-complement integer is 2147483647; the largest unsigned is 4294967295.

Welcome aboard! :D DataStage has optional (separately priced) components for working directly with SAP R/3, either through RFC or FTP. For example the SAP R/3 Extract PACK contains the plug-in stage and the libraries that it uses. This has been certified by SAP as generating valid ABAP code and lice...

Yes, I've done this, but without writing any code, using Sequential File stages in some cases, and using an after job subroutine (ExecSH) to execute a UNIX mv command in other cases (move file once processed). If you're needing to interact with some other application, you may find the capacity of th...

How about encrypted environment variables?

I vaguely recall there was something in the 7.5 readme about this being fixed. (My current client is on 7.1, so I can't check.)

I'd put it in a separate thread, since it's not about "empty source file"

Come to Australia (it's springtime!).

DB2 is my DB env. in DataStage. How do you implement this in DataStage?

You use user-defined SQL in the stage type that is extracting the data from DB2.

While there are tools for moving hashed files between operating systems, it's much easier to have DataStage create them in the new environment than to learn the tools. To save anyone asking, the tools include uvbackup / uvrestore and format.conv / fnuxi with -export and -import options. The answer t...

Surely all these variable pieces of information can be set up as job parameters? Then there is no need for any opening of the job design; you can have the job read-only in production (always recommended). Change the default parameter values - if desired - using Director. (I tend to recommend to clie...

There's nothing special about DataStage.
You configure the ODBC driver information exactly the same way that you would for any other ODBC client.