DSXchange

And, of course, Microsoft intercept Char(128) to mean the Euro symbol, so you have to map a different character for NULL when on a Windows platform. This can be done in the uvconfig file. I don't believe that any two databases have the same rules for null representation or even handling. Some have a...

No provision exists for invoking DataStage from SAP R/3. The only thing even resembling this is that you can specify "push" or "pull" for accessing data.

Please don't double post.

A comprehensive answer exists on the SOA forum

Been there done that. I must say, however, that I have found most IT departments who "push" software to be amenable to cogent discussion about DataStage clients' requirements, and usually happy to oblige in getting it right within their SOE procedures.

Welcome aboard! :D Try using the link variable called DBMSCODE (there isn't one in DataStage called SQLCODE). SQLSTATE is the ODBC-specific generic error code (such as "S1000"), while DBMSCODE is the code returned from Oracle - usually a negative integer or zero. Are you really doing this in a paral...

I wonder if their answer will include Carter's routine? Ya shoulda put a copyright notice into it before "they" do.

Ain't easy. My first thought is to put a Folder stage into a Server Shared Container. That definitely captures the file name, as the "key" column. Problem with it is that the Folder stage reads the entire file into its "record" per file. You'd need to parse that out somehow (more text files?!!).

Please advise HOW you resolved it.

Anyone else who encounters this problem will search the forum and find this thread. Wouldn't it be nice if they could find the solution here?!

It's because - intentionally or otherwise - you designed your job to do that. You have not provided anything like enough information to enable anyone to diagnose this. For example, how many processing nodes are defined in the configuration file under which the job was run? Have you tested it with a ...

Have you verified that executables for sed and dbx are both installed on your machine, and that their parent directories are referred to in your PATH environment variables for DataStage processes - that is, the PATH set up in the dsenv script? That is, have you taken the investigative/remedial actio...

Running the job executes the osh script - you don't need to worry about that. You do need to worry about the missing or unfindable ".o" file. Perhaps you could try re-compiling your job with "force compile" selected. There is an environment variable (variously called LD_LIBRARY_PATH, LIBPATH, SHLIB_...

If you pause to think about what @OUTROWNUM is doing, it is counting the rows that are sent along the output link while the job is running. The job continues to run, because of the RTI components. It follows that the answer to your question ("can I reset @OUTROWNUM", implicitly "without stopping the...

prabu wrote:Ray, are you listening

Not while I'm working. While I'm working I give my client's tasks my full attention. I only visit DSXchange during breaks, or before or after work.

Do the inserts and the updates separately. Use a lookup to determine whether the row already exists; choose one of two output links on this basis.
You might even consider directing these links to text files ready for bulk loading into the table.

This is a fairly common problem in sites where there is an SOE environment; that is, software is pushed out to PCs rather than allowing staff to install anything on their own PCs. "They" need to be informed that write permission is required to the DataStage installation folder, not just for job sequ...