DSXchange

The job log logs what the job does. The Link Report entries will normally show the SQL that DataStage sends. As far as I am aware DataStage has no mechanism to capture any "translation" that might be done by an ODBC driver, database client software or database server.

Can I ask whether you connect with the Omit box checked, or supply a user id and password? If you do use Omit, try providing an explicit password. In many ways connection via LAN Manager rather than TCP/IP (which is what Omit does) is flaky.

Does the word "Kalashnikov" rattle any eardrums?

I fear we're drifting off topic again.

If you have 7.5 you can read the file once and use expressions in a User Variables activity to parse out the individual values, then use these user variables to supply values to the job parameters in Job activities. Such expressions are not available in versions prior to 7.5.

<musing>
I note that we have a poster called ak77. I wondered if there's an ak47.
</musing>

In the DRS are you specifying SQL Server or ODBC as the connectivity mode? If the former, what happens when you try ODBC within DRS? Are you 100% confident that the table definition on the link exactly matches what was imported from SQL Server? Could it have been imported from an earlier version of ...

It can also be represented as Fmt(InLink.Column, "R%5")

I always prefer reset (first, at least) after a problem, because it fetches and logs any outstanding diagnosting information from the previous run. Compile does not. Reset resets the job to the state it was in prior to the previous run. To do this it will drop cursors, close files, release locks, an...

Yes, my bad. The trace goes into a trace file; a file in the &PH& directory in your project. The file name ends in "Trace".

You haven't indicated what the problem, if any, might be. What - exactly - are you trying to achieve and how are you trying to achieve it? What part does the Link Partitioner have in regard to your function? It should make no difference whether you have row buffering in place or not. An IPC stage on...

Welcome aboard! :D

Sometimes that's defined as the problem being between the keyboard and the chair.

It does from ODBC stage.

Another possibility would be to execute an oerr command to translate the code into text. Sometimes the text, with both explanation and recommendation, can be a tad long-winded however.

Sure is, especially the number of dollars they want for an ODBC driver licence.

Welcome aboard! :D You may be lucky here in finding someone who knows how to do what you want, but why not post this question on an Excel forum somewhere? I doubt that you'll be able to invoke Excel macros from within your job, but you may be able to execute an external command - perhaps one written...

(I'm not able to check at the moment, but...) isn't there an Enterprise SQL Server stage in version 7.5?