DSXchange

Pick / make up a value for orchestrate.Val_Date and show us what the final sql that DataStage would run should look like.

Or did you want it selected as a literal?

If you are expecting your incoming row data to be substituted in as a column name in your query, that's not going to happen. Why not drive your select from the source end so that the inserts can just be inserts?

You'd have to explain what "no luck" means if you want someone to be able to help.

Of course, you're substringing out only the first 4000 bytes. What happens if you just select the field itself and declare it as a LongVarchar?

cnjelita wrote:It says that that job is running from the Director. When I click stop, it says that job is stopping at the Server.

Right, figured as much. Need to know if it is still running or just flagged as running - two different things.

The Task Manager on the Server, if someone has access to that.

Is it actually running or does it just say it is running in the Director? Does Task Manager show any processes for the job?

Does your connecting user have the grants you'd need to truncate and bulk load the table?

ps. The Oracle Enterprise stage does not use ODBC, nor is it available in Server jobs which is how you marked your post.

Or perfectly fine, as you've seen.

Manfred Hagedorn wrote:For restarting Datastage i have a small job, using a sleep of 60 between stop and start.

You really shouldn't do this on a timer, but rather after a check for open ports returns zero in that state:

Yes, I suspect it is a space issue and you'll need to tightly monitor that while the job is running to see if that's the case.

You seem to have combined his advice with mine. Please do one or the other... and his does not involve a cd.

Which was mentioned in your error message?

I would assume it could not be created, hence the error when it goes to open it. Strictly speaking there is no "filename" in the error but rather a named pipe that it is having the issue with. And you have no control over the name it uses, just the location. Well, unless you consider the s...