DSXchange

asorrell wrote:See? That's how you dodge lightning...

Turned out Thor is busy at the moment.

All my lightning hurling is now outsourced, because it's not part of my core business. (Sound familiar?)

So now you know what the actual error is. The INSERT statement may suggest which actual CHECK constraint was violated; or there may be more information in the job log or in the Oracle logs.

Enable server side tracing then open Designer and delete a job. Disable server side tracing and close Designer. Examine the trace file to see what happens when a job delete request is processed. Create a routine that makes the same calls. Don't be surprised that it's quite complex.

Your specification is good. Contemplate conditionally using UtilityRunJob() to run the job when the value is not null.

Welcome aboard.

Usually the fastest way to get an answer is to Search DSXchange. In this case an exact search on "Fault occurred in BASIC program DSP.Open" might be a good start point.

*Topic Relocated - Content Editor*

There is no practical limit. The parameter set's contents still have to be stored in the repository so there will be a size limit resulting from that, but it's huge.

You set it in the import dialog itself.

There is something like this coming in a future version (8.2?)

If you like you can build a DataStage job to use this query in a UniVerse stage (DSN = localuv) and use the results to populate your database table.

Change the array size to 1 to get correct error reporting.

1. Only if the data are sorted on the grouping keys (anything else doesn't make sense anyway). 2. Set enforces downstream stage to use same partitioning, Propagate recommends that downstream stage uses same partitioning, Clear does not care what partitioning downstream stage uses. It only affects th...

I'm talking on the telephone. Suddenly there is silence on the device.

May I know the reason for this ...

I'm expecting favorable solution from your side...

It was unexpected.

How can you therefore expect to know? Some intermittent glitch in communication between processes, maybe.

Can you telnet to the server, get in to a DataStage shell in the DSEngine directory, and execute this command successfully? Note that it must be all upper case.