DSXchange

Isn't  the correct way in HTML to represent Char(27) (Esc?).

The # indicates that what's following is a character number (ASCII code, if you will), and the x indicates that the number is in hexadecimal format.

In answer to Kim's question, there are no invocation IDs "out there" until run time (or schedule time), when the invocation ID is provided. Yes, there is a field in one of the RT_CONFIGnn records that notes the invocation ID, and in the log event record as well. Were I to reveal details (which I hav...

Your instructor was correct in saying that you can execute SQL in a routine. However, that is not the entire story, as Kim suggests. You can execute SQL against DataStage tables (including hashed files) via a call to DSExecute. You can execute SQL through an ODBC driver via the BCI functions. You ca...

This is multiple instances of server jobs, not PX. There is nothing in the design-time information (the DS_... tables) except an indicator that the job is multi-instance capable. The only location where the multi-instance capability has an impact in the repository is in the run-time tables (the RT_....

The dsenv file is read by every DataStage process.
It is a shell script.
You can add to it anything you need.

In version 6.0 and later of DataStage you can initialize job parameters with the values of environment variables.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The readme file that ships with DataStage usually contains a list of things ("known problems") fixed in the current release.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

That smacks severely of non-standard custom programming to me. It's the kind of thing we consultants do (in exchange for money). If you'd like me to quote, please respond via private message. [^]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

I sometimes get asked this question when running DataStage training. Open the doc_tool.mdb with MS Access (bypassing the startup macro, for example by holding the Shift key when opening it), and get it to analyze the relationships between entities in a normalized version of the repository database. ...

No. DataStage 390 does not give you any access to data on the mainframe, nor does it give any access to metadata on the mainframe. There is therefore no Browse capability. Metadata must be captured into a COBOL file definition (CFD) file or into a DCLGen file if from DB2/390. This file is then moved...

When you create a mainframe job using DS390, instead of compiling you generate one COBOL program and two JCL scripts. This occurs on your DataStage Designer client, on the client machine. A job property specifies the location of the files. From the Generate window you can view any of these and copy/...

... and I've been in paid employment [:D] Variables with names of this form ($nn) are the temporary variables that DataStage BASIC uses to store intermediate results in expression calculation. This is occurring in a Transformer stage called TRANS1 in your job. The source code can be viewed in a sub-...

Irony, Kim. [;)]

IIRC the shortest-lived release was 2.0, followed three weeks later by 2.1 to fix the bits they'd broken.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

"Phantom" simply means "background process" (see earlier), so you shouldn't be concerned about it. These processes redirect their output to a file in a sub-directory called &PH& in the project directory. DataStage internally, and therefore some posters to this forum, refer to &PH& as a "Type 19 file...

In 1999 there was an ad seeking someone with five years' DataStage experience. Version 1.0 was 1997; we remember it fondly.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Curiously, perhaps, dsjob began life as the demonstration of how to use the DataStage API! Full source for dsjob (in C) is in the Server Job Developer's Guide.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518