DSXchange

Your configuration file has not specified a node pool or disk pool for sas (using the appropriate reserved name).

Surely the Wrapped stage will be called for every row processed?!

What you really want to do is to pre-process the file, perhaps in a before-job subroutine that executes an appropriate operating system command (or shell script). A before-job subroutine is executed exactly once.

It's a regular text file. Empty it any way you like. Probably the fastest is to copy /dev/null to it. Best to do this with dsdlockd shut down.

It won't let you create one. But there could be a bug in import or paste that lets you get away with it. Only waste time pursuing it if it's costing you sleep.

Actually, you don't need fnuxi for compiled BASIC code. The run machine checks the magic number to determine the byte order, and will adjust "on the fly". It's more efficient if you have corrected the byte order, of course, but it's not actually necessary . <positive spin> What this means is that co...

One of many errors in the manual. The functions that the Modify stage uses are similar but different from the functions that the Transformer stage uses; for example many of the Modify stage function names include underscores. Maybe they'll become more consistent in a future release. Meanwhile you ne...

If you report what you think is a bug, your support provider will demand that you prove what you are saying. You usually do this by supplying job designs and, if needed, test data that reliably demonstrate what you are claiming. This is a "reproducible test case".

If NLS is enabled, your CHARACTER locale category has a list of characters deemed to be printable. This will override the results that Arnd reported. Any other character is converted to "." by the MCP conversion code.

Iconv() and Oconv() functions are not directly available in parallel jobs.

You can't use a parameterised WHERE clause on a stream input link. Replace the :1 with something else - ROWNUM maybe - or just drop the WHERE clause; there is only one row in the DUAL table.

Log scrapers are to be resisted because of the danger that database vendors will change the format of transaction logs in future releases.

Or, just to supply an alternative, you can format it if you're confident in the input format.

Search the Forum; I have a vague recollection that the OCI stage requires an internal format date.

@KEY, @ID and @ are entries from the file dictionary, they ought not to appear in the data portion of the hashed file. My guess is that someone has somehow copied the dictionary entries into the data part. These will have "D", "I", "PH" or "X" in field #1, so should be easily detected. To see them S...

For each parameter name in controlled job If parameter name=value exists in file Then load controlled job's parameter with value, check for errors Else do not load controlled job's parameter; issue "default used" message EndIf End For Is that the design? More bullet proofing could be added.

At the risk of opening a (or another) can of worms, one can view the "assembly language" for this compiled code using the VLIST command. If you do you will make one fascinating discovery; there are quite a few multi-operand opcodes. For example, the multicat opcode can concatenate together any numbe...