DSXchange

No.

If you have an active SELECT cursor on table abcd, then table abcd will be locked against INSERT operations. Reduce your transaction size to 1 row, and/or set to auto-commit. Even better, select the data into a staging area (a persistent Data Set or Lookup File Set) in a prior job to avoid a self-de...

This is, as the message tells you, an internal corruption in the hashed file. From the size of the addresses, it looks like it hit its 2GB limit at some point. The fix is to clear the hashed file of contents (or delete then re-create it) and assert 64-bit addressing, obviating the 2GB size limit. Yo...

It (error code -4) means that whatever you're providing as a date parameter is not a valid date format.

Does the job itself have an active SELECT on the same table?

Moi?!!

's a product name - can't avoid that. Original intention was to provide a UNIX tool set on Windows - folks (and Ascential engineers) just took it to another level.

On a Windows platform it's an uninstall, to clear the serial number (and a lot of other stuff) out of the Registry. The "Microsoft solution"! And you should, you will be surprised to hear, re-boot after uninstalling.

1. No. Just process. As a general rule DataStage does not use threads. (There are, of course, some exceptions, particularly in sorting.) 2. They both have section leader and player processes. The conductor node is usually the first-named node in the default node pool, unless you have specified APT_C...

IsNull() returns 1 or 0 (a numeric value). Therefore you can not use it as an operand of a concatenation operator, as you appear to be attempting to do. What data type is your stage variable?

Try disabling automatic load and inspecting the control file generated by DataStage.

That's kinda the same part of the world (yeah, not exactly) that once legislated the value of pi to be 3. Not every management decision is clever, or even intelligent. Some things are just not possible; other things are not cost-beneficial.

Please post the messages from the job log resulting from resetting the job. There should be three or four events logged.

There are no marks any more - they converted to Euros some time back.

This is precisely how version 7.5x2 works - it doesn't really run on Windows; it installs MKS Toolkit and runs on that. But I believe it's the only version that works that way. Craig: there's a trick you can use to impress your clients. Open up a CMD shell, enter sh as a command (the UNIX prompt app...