DSXchange

Look in the Director logs both for the job sequence and for the job itself. In the "job run requested" event for the sequence note the parameter values that were sent. In the "job starting" event for the job note the parameter values that were received. Verify that they are the s...

That was an edited note, added (I think) after I'd done theorizing. I have no explanation whatsoever for that behaviour. It may have something to do with the way that the two Transformer stages are combined in the process, but I'd have to spend a lot of time (which I don't have today) researching it.

vijay.barani wrote:I have a requirement like i have to update a table directly from a routine.

Resist stupid requirements.

As you observe, the bitwise functions require integer arguments. The easiest solution is to read your binary data with Complex Flat File stage which "knows" how to convert (or not, as the case may be). It seems to me, though, that your "binary" data is already at least in TinyInt...

Open Director. Disable (in View menu) display of categories. Sort by Status and find all the running jobs by that means. To find the connected clients, open a Command window in DataStage Administrator client and execute the following query. SELECT COUNT(*) FROM DS_LICENSE; Note that this technique w...

Look in DS_AUDIT, find out who made the change, and beat the information you want out of them.

Version 8 has comparison tools.

You can't.

However, you can do it with concatenation.

Resist stupid or ignorant requirements. You do NOT need to edit the dsenv file to connect to Oracle from a DataStage server running on Windows for the simple reason that Windows-based DataStage server installations just don't have a dsenv file. Was any part of that unclear? Please convey to the auth...

No, you do that in the email system. Create an address that is a list address, and have DataStage send to that.

What's different between DEV and UAT?

In particular what other processing was going on at the same time?

You may find some of the observations in this post interesting.

Why do you think it's there particularly? An access violation can occur when trying to put NULL into a not null column, or when trying to put a string into too small a field or buffer, but can also occur for about a million other reasons. Craig asked for 20 or so lines, you have provided two. Probab...

If you think about what was happening before, with both Transformers in one process, there wasn't really any output link from the first Transformer. That's why DSGetLinkInfo() returns zero row counts. Inter-process row buffering forces the two Transformer stages into separate processes so now there ...

Make the RT_SCnnn directories in the project read-only.

Your dscc users will complain about "compile errors", so take your phone off the hook as well.

This probably results from both Transformer stages executing in the same process. What happens if you enable inter-process row buffering?