DSXchange

From what I recall, there is a Validate option in the stage somewhere. First question would be - do you have this enabled?

If you have access to ADN, it is posted there.

You really meant DUTCH_THE_NETHERLANDS.AL32UTF8 (no space) yes? Do you have NLS installed?

D wrote:(Craig - don't go there!)

Doh! Cut off at the knees. Ok, not going there.

Another reason why I suggested you stick with an Array Size of 1. Some of the advise here can be tuned if you 'know' what the maximum size of the data is in the CLOB. For example, we've got one table with a CLOB field that holds wildy different data in the CLOB. For some datatypes, I know that size ...

Probably best to ask Ascential Support so you know for sure.

Good to know.

I think you've listed the problem in your post - you are calling a Server function.

Do any of these DSGet* functions work for PX jobs?

I don't see anything in the readme for the MCM that mentions a version restriction. I seem to recall using for 6.x and 7.x, pretty sure you'll be fine. Multi-Client Manager -------------------- A Windows Service is used by the MCM. This service needs to be run using a user account that is part of th...

You are mixing up your processes. DSGetLinkInfo doesn't get information from the job's log but rather from the job itself. It doesn't get all errors, just the last one. And, as you've noticed, it won't get the text of the message only the error number itself. Why not put a 'reject' link against the ...

Question - one of the prerequisites of using Automatic mode is the Oracle instance being loaded must reside on the same server as DataStage. Is that the case?

Did you try a LongVarChar (not a VarChar) of "20000+"? No TO_CHAR.

Exactly. Failing to find it there, it will attempt to find private or public synonyms.

Make sure you connect to the instance with the user that owns the table.

Well, I guess if it ain't Arnd helping out, it must be Ray.

I can't confirm anything, but you should state the exact 7.x version that you are running as that could make a difference in the answer.