DSXchange

The expression you used will work fine, provided that the target column data type is string (that is, Char or VarChar).

I'd use the ROWNUM or equivalent function in the SQL.

(This is probably not helpful.)
The last link in a job is the one that was added last (most recently) to the job design, and is therefore the link with the highest internal link/pin number.

Good question. I'll need to check that.

It might also prove difficult finding an operating system version that is compatible with both DataStage releases.

Try using Complex Flat File stage as your target.

DataStage executable code actually runs in a virtual machine (the DataStage engine) rather than needing to be linked. The codes you see in the export file are pcode instructions for that virtual machine.

There is only incomplete metadata provided for these tables, since the record structure varies for different record types. None of this is documented directly, though you can find some information about the structure in header files in the DSINCLUDE sub-directory. DO NOT open these hashed files with...

That is a perfectly good practice. The output of a passive stage (such as a hashed file stage) is not opened until its input is closed. The contents of Table A are loaded into the hashed file before anything else happens. If you want to be able to look up against changes too, you need to implement a...

1. Perhaps they wanted to use some additional filtering, via user-defined SQL? 2. UniVerse is a database product originally created by VMARK Software and on which DataStage was originally built. All UniVerse tables are hashed files, but also have "system table" entries that describe them, ...

I suspect your database metadata are defined in terms of bytes rather than characters. Did you import the table definition into DataStage and, if so, what were the imported data types? Try using VarChar(20) to cover all possibilities (some UTF-8 encodings can use a variable number of bytes per chara...

Orphaned scratchdisk files are most typically left by aborted jobs. This is one of the reasons I create job designs that do not abort. When a player process aborts, its controlling section leader (or even the conductor process) may attempt to clean up temporary/scratch files. I believe that this is ...

From memory the main ones are those where the Pick variant is radically different, namely CREATE.FILE, DELETE.FILE and COPY. One of us would have to check the UniVerse User's Guide to be sure. Changing flavor involves copying entries from the appropriate NEWACC subfile into VOC - you can create an a...

Hmm. Thanks, Ernie. Must get that patch.

Pivot.
Column Export.