DSXchange

If you use ODBC stage you can set it to return multiple rows on a lookup, and make your own arrangements about getting the last of these. The OCI stage does not support this functionality.

I do not recall receiving any private mail/message on this topic.

Welcome aboard. :D

This can occur if someone is performing an administrative task that requires exclusive access to the Repository.

If that process was interrupted (killed) then the lock may continue to be held, though spuriously. Restarting DataStage may help.

It is possible that running UVFIXFILE in FIX mode has made DS_JOBOBJECTS "terminally ill". My advice at this point would be to rename DS_JOBOBJECTS and restore it from your most recent UNIX backup. This way you will at least get something back, provided DS_JOBOBJECTS wasn't corrupted prior to the ba...

In any scenario - real time or otherwise - it depends on what you're looking up and why. For example, to detect existence, you need only the key values in the lookup table (or hashed file). Even in India this is unlikely to get anywhere near 2GB. But, if it does, all you have to do is change your ha...

The ODBC stage is limited in the maximum row size it can work with. This is configurable via MAXBUFFSIZE in the uvodbc.config file (iirc). Search the Forum for uvodbc.config to be sure. It's out there somewhere. (Yes, I'm in an airport lounge, away from DataStage again.)

Put in timing points in the job control code or in the job sequence (note: it's sequence, not sequencer). Use a Routine activity to do this in the job sequence. Find out where the delay is.

Or you can use format.conv (the "proper" name for fnuxi) -export and -import options to do the transfer for you, and thereby byte order is handled automatically.

There are no SQL data types within server jobs. This means that, even though you perform a "string" operation, if the metadata specify that the column is TimeStamp, it will be stored as TimeStamp.
:D

Since you're new to the forum, and I'd guess even newer to DataStage SQL (especially for multi-valued fields), here's a starter pair of queries. SELECT INSTANCE, CREATOR, DTC FROM DS_AUDIT WHERE CLASS = '2' AND INSTANCE = '<<JobName>>'; SELECT MODIFIER, DTM FROM UNNEST DS_AUDIT ON MODS WHERE CLASS =...

This paper may also shed some light on date conversions.

Just to strengthen the point that Arnd made, intra-process (or within-process) row buffering is not acceptable. There must be a process boundary, because the Link Collector stage must run in its own process. You can enable inter-process row buffering. You can also place an IPC stage between each Tra...

There is a significant problem with your DS_JOBOBJECTS hashed file. One of the pointers has become corrupted; I am guessing that this is the fundamental cause and that all the rest are consequent errors. These errors can sometimes be fixed and sometimes not; it depends whether it's a "legitimate" BL...

What is the meaning of error code 80011? The putty telnet client connects via telnet (port number 23). The DataStage clients connect via DataStage RPC (port number 31538). It seems highly likely that the DataStage RPC daemon (dsrpcd) is not running, which means that it did not start automatically wh...

Then concatenate " 00:00:00.000".