DSXchange

That's a server job solution that's not really relevant in the parallel job environment unless you want to use a UNIX shell script to modify the text file in advance. In the parallel job the easiest way is to read the file with a Sequential File stage whose schema matches the detail record. The head...

Definitely yes.

A job sequence is simply a special case of a server job, one that consists solely of job control code (which is read-only).

.odbc.ini is simply where you set up ODBC data source names, with all the other information required by the driver. It's just how we used to have to do it with Windows 3.1 and earlier. You may also need to put a simple entry into the uvodbc.config file in your project, indicating that this data sou...

Why should you have to?!! I still claim it's broken.

2 * 28 = 56, so I don't know where your 480MB comes from. Your product should yield 560,000,000. But that's just the overheads for storing the data, assuming complete packing. SPLIT.LOAD will guarantee that the file will never be more than 80% full. MINIMUM.MODULUS and LARGE.RECORD can also influenc...

RESIZE is the easiest way to force a hashed file to give up its internal free buffers.

Only ODBC and UV stage types support multi-row return on a lookup. Search the forum or check Designer help (search there for "multi").

Welcome aboard! :D This is one of the fundamental techniques in DataStage. You create a link from your DB2 stage to a Transformer stage (this is the "stream input" link) then create a link from the Hashed File stage to the Transformer stage (this is the "reference input link"). As well as editing al...

There are a couple of misspelled variable names JonHandle rather than JobHandle. Fix these.

If it's DB2/400, you can use the DB2 stage or the ODBC stage. You can also expose the AS/400 tables on your UNIX machine using DB2 facilities and write to those.

Can you pre-load the country-code to currency-code mappings from the file into a hashed file, and use standard lookup techniques?

Welcome aboard! :D What happens if you try to connect with the Omit check box checked (which uses LAN Manager rather than TCP/IP)? If you have the clients installed on the server machine, try connecting to localhost (127.0.0.1) from them, with Omit cleared. This will help to confirm whether it's a n...

What happens if you change the default warning limit (in Director, Tools > Options)?

7.1, maybe 7.0.x, and still in 7.5x2. You get to the first breakpoint then the job aborts with the message "Debugger client disconnected".

There are multivalued-handling equivalents of most intrinsic conversion functions and operators, usually constructed by adding "S" to the name. For example, IF becomes IFS (and a function), FIELD becomes FIELDS, GE becomes GES, OCONV becomes OCONVS, and so on. You may also need the REUSE function if...