DSXchange

Welcome! :D First suggestion would always be to Search the forums because more than likely you're not the first person to have the issue. I just did an Exact search on "does not fulfill the sort requirements of the downstream operator" and got 23 matches. Check'em out, see if they answer your questi...

in server B i just type gouv and project name. No such thing out of the box as 'gouv' so this must be something 'you' created. If you want it on Server A, copy it over there. If you launch dssh from the DSEngine directory, you'll connect to the UV account. To move from there to any Project, simply ...

Server job, source from a transformer, constrain link to @FALSE and then sql to drop your table. Two tables, two links.

The only difference when running under control of a Sequence job should be parameter values. Have you double-checked what was actually passed to the job?

Windows laptop running what O/S?

The OCI stage does not like the trailing semi-colon and it will generate an Oracle 'Invalid Character' error.

id4dstech wrote:E@: id4dstech@yahoo.co.in

Umm... no. You ask in the forum and get answers in the forum, not via email. You can, however, configure the site to email you a notice when an answer is posted, hopefully you've done that.

First step - read the Plug-In Installation and Configuration Guide manual in your 'Docs' folder wherever you installed DataStage on your PC.

AFAIK, a reject link should handle anything that is rejected by the database - in other words that generates an ORA error. This will not happen silently, if that's what you are expecting, all those warnings will still be logged and if you log more than the Warning Limit for that run the job will abo...

I guess I was thinking of the entry logged by an Execute Command stage in a Sequence job, something where the command was auto-logged by the running process. Never mind.

chpraveen.msc wrote:Is there any way that we can explicitly specify the path for Bad file.

Just the .bad file? I don't believe so, but you should be able to control where all the files are written. I don't recall the exact answer but a search should turn up the APT variable that needs to set.

Have you not added a reject link from your Oracle Enterprise stage to wherever you want to collect them?

There should also be a log entry that shows the actual command executed. Please post that.

Right... in other words, just repeat the -param and the new parameter / value pair as needed.

While it's running? No can do.