DSXchange

There are many ways to do this, including a small 'do nothing' job that connects to that database that you Validate rather than run. For the scripted approach, involve your DBA.

No, there's no "DataStage level" for schedules, it's all on the UNIX side.

There are a ton of discussions here on that subject, so be prepared to search and dig. One decent starting point would be here:

viewtopic.php?t=130037

You need to take that error to your SysAdmin so they can check things out and correct whatever the issue is.

What version of Oracle? Are you using CAST() at the moment?

Probably... again, it really comes down to what you mean by "complex".

Completely agree with what Arnd posted, with one clarification in my mind. In my context, a "physical node" would be the box, the physical server regardless of the number of CPUs on the box. You can further sub-divide a node into logical collections of resources, pools - scratch and resour...

Please don't post the same question multiple times.

This is being discussed here, please respond there if you'd like to help:

viewtopic.php?t=130190

Your friend is incorrect.

What you need to do is called a vertical pivot and an exact search would reveal many discussions here with several solutions.

You need to find the log file, no other clue to the error will exist. Also double-check you have permissions to that directory, that your user can actually create a file there.

If you really want help, you'll need to detail exactly what the differences are rather than say "not much". That and detail your job designs.

That would work if the prompt was on the command line. Since this is a dialogue box, that's going to make it more difficult.

You need to understand that the cron-based Schedule is per user, so if user A schedules something, only they will see it in the schedule. Any other user will see it as 'Not Scheduled'.

As long as the table is actually 'truncatable' - privs, RI, etc - then it should just take putting the truncate command in the OPEN option of the OE stage to accomplish that, I do believe.