DSXchange

Hi, Today I'm getting strange results from surrogate key generator. There are 53 input rows going into surrogate key generator. It is supposed to generate 53 integer number which it is doing fine. I've specified initial value of surrogate key as 1. So no sequence should be from 1 to 53. But the no ...

snassimr wrote:what happend when I set the limit on limits tab during running the job ?

DSSetJobLimit (DSJ.ME, DSJ.LIMITWARN, 4)

But that's not during running the job, that's while making the request to run the job - that is, before the job is running.

I reran this job in our dev environment , and can see the files being created in /tmp -rwxrwxr-x 1 dstage oasadmin 524336 Sep 19 12:37 2005dev.P423LoadCOCDSContCompCorr00..TransformA-Transform.OutA The files are not huge ,only 524K so it can't fill up /tmp which in our system had more than 3 GB. Th...

There is no documented limit. In theory, an oversized record can be as long as necessary, since it occupies a daisy-chain of oversized record buffers. Each of these has a pointer to the next, the pointer size is governed by the 32-bit/64-bit setting of the file. In practice, I've never seen the limi...

My point is that you didn't SHOW any error message in your original post. Or that one.

If there are two triggers, Otherwise and Failure, you have two branches. On the non-Failure branch you could use a Nested Condition activity to decide whether to log anything based on the job status. Or you could have four triggers; one OK, two Warning, one Otherwise. The OK and one warning run into...

In the manuals and sometimes in the on-line help for any stage type that can handle it. For example, the CFF stage and FTP stage can do this kind of conversion. There is some capacity in other stage types. Why not use Adobe Acrobat's search capability?

Oh ye of little patience! Of course the Administrator goes into a wait state; cleaning up a large process will be quite a time-consuming process. Make sure there is no entry for the project in UV.ACCOUNT and UV_SCHEMA. Get into TCL in the directory if there's still a VOC file there, and determine wh...

Change your invalid requirement to read certain fields as "Date" data type - there are no data types in text files, only text.

Transmogrify it into a date once you've gotten it into DataStage.

What version of Oracle? RTFM?

That post also makes the point that there are some out and out errors in the Parallel Job Developer's Guide - you should not rely on it, particularly the chapter on Modify stage (which one guesses was written by someone who grew up with Transformer stages)

There are a few possibilities along these lines. For example you can have a Custom condition encompassing both success and warnings, like Rich suggested, on each Job Activity. Another approach is to have a Failed trigger and and Otherwise trigger (this has the benefit of colouring your Failed trigge...

WHAT following error message?

Kumar has answered the Version Control part of your question. DataStage configuration management configures only its own environment and consists of a few configuration files that you edit. In some cases you need to run a utility to give effect to the changes, for example uvregen after changing uvco...

Same advice to you, Ian, also look at the start up entries to determine the actual SQL statement that was sent to the database to be prepared.