DSXchange

Note that since you marked your post with a job type of Server I moved it to the Server forum and gave you a Server answer.

From what I recall, you'll need to change it. DataStage enforces field sizes at the target, so while it won't care as it flows through the job, it will check just before it sends the data to the target. If it sees something larger than your internal metadata allows, pretty sure that you'll get a mes...

I don't believe that it can be parameterized but perhaps you could use schema files to control that?

And you'll note that the first thing it says is that it is only for those circumstances when you can no longer do it from the client.

<relocated>

Please try to post in the correct forum.

You left out the domain.

I doubt anyone here could help with that, unless perhaps they've faced the exact same issue. Best to contact your official support provider for help with it.

Supply all of the proper credentials - user, password, domain at a minimum.

The support page says "Grant read and execute permission on all Oracle Client files", have this done on the server for the user executing the jobs. This is specific to the Oracle Connector, however - are you using that?

There are? That's good to know... off to check.

You need to talk to your cohort, it would seem.

viewtopic.php?t=144882

You'll need 'MS Access' ODBC drivers for UNIX to do that. You'll need to check to see if that shipped with the product, if not they will need to be purchased.

Yes. Look for the DSGetLinkInfo() function.

To me that would imply that the RSA keys weren't setup properly.

Don't you need to switch to sftp for that?