DSXchange

The ".so" file must not be the trace file. Otherwise you're attempting to overwrite the library that contains the tracing functions themselves!

Call your trace file something else, like /tmp/odbc_trace_yyyymmdd.

The language is C++.

You create the functions separately from DataStage, compile and link, and test them however you like.

A DataStage "parallel routine" entry in the Repository is simply an interlude that describes the location of the function to be called and what arguments it uses.

That is Teradata specialist knowledge, though you may be lucky here (there are a few Teradata specialists amongst us - I am not among them).

A better approach would be to open the file itself for sequential access, seek to end of file then start writing with WriteSeq. DEFFUN OpenSequentialFile(FilePath,OpenMode,WriteMode,Logging) Calling "DSU.OpenSequentialFile" t.Fvar = OpenSequentialFile(LogDir:"/":FileN...

Write is always a descructive overwrite. Openpath LogDir to t.fvar Then ReadU ExistingFile From t.fvar, FileName Then Write ExistingFile : @FM : JobStat to t.fvar, FileName Else Call DSLogWarn("Failed to write file ":FileName:" to directory ":LogDir, "GetJobLog")...

You have marked your job type as parallel and posted in the parallel job forum, so I am guessing that your calling routine is a before/after subroutine. To call another before/after subroutine, prefix its name with "DSU." in the Call statement. Call DSU.MyOtherSubr(InputArg, ErrorCode) To ca...

Try using an actual job name rather than the string "Job Name".

Oracle is not Teradata (you may have noticed). Oracle can wait for a very long time for a lock held by the same process (a "self-deadlock") to be released, either by the SELECT completing or the cursor being dropped. All you need to do is to prevent operator combination, so that the SELECT and INSER...

Please post the generated OSH, or at least the record schemas from it.

Without that it's impossible to tell, lacking a copy of your job design.

What is the value of Arg1?

Don't assume, check - maybe using DSLogInfo().

If the job name is not spelled and cased correctly, DSAttachJob() will fail to attach the job.

Ordinarily you would use some kind of remote execution protocol, such as "rsh" (remote shell) or "rlogin" (remote login).

Does U work at your site? Be that as it may (the second person personal pronoun in English is spelled "you"), the user ID you are attempting to use is clearly not the IS Administrator user, or someone has de-credentialled this user. If that's the case, and you no longer have any IS Admin user, then ...

If you can figure out how to shoehorn a five-character string into a two-character string, then there may be a solution. DataStage is warning you that your input might have more characters than can fit into the output string. Take a closer look at the error message - from which stage (operator) is i...

I've implemented something like this in the server environment using late binding techniques to invoke the function indicated by the discovered business rule. I guess you could do something similar with C++ routines.

Diable RCP in the Sequential File stage.