DSXchange

Welcome aboard. Reading your installation instructions will help you greatly. You've probably missed most of the important steps to do prior to an installation, such as verifying and adjusting kernel parameters, installing/verifying your compiler, and setting up the appropriate installation userid a...

You can remove any ASCII character with EREPLACE or CHANGE using CHAR(n) where n is the ASCII value. A newline, or linefeed, is on the chart.

I suggest putting some "mile marker" actions into the bat script, such as creating a file right before running the exe to see if the your bat script even gets to that point. DS can run any command line program as long as that program doesn't attempt any GUI i/o or such. If the program has those acti...

See Arnd's reply, or simply check if any of the matching key column values in the hashed lookup are not null. To achieve the effect of an "inner join" you need to use a constraint that verifies if the lookup row is present. An "outer join" doesn't require a constraint, DS is ambivalent to whether th...

Yes, but your underlying problem is that you're trying to run a stored procedure to "DO SOMETHING" and need help. We appreciate your trying to organize your postings :D , but now you have 3 threads for your same issue. I'm trying to answer and guide you and I have to juggle 3 threads with folks addi...

If your stored procedure "does something" like drop constraints, build indexes, etc, then you DON'T want to use the STP stage. That stage is used to STREAM data.

Load parents before children, validate all data types and values for constraint conformance prior to loading.

Take your delta data set, scan it and build a distinct list of natural keys. Bulk load those keys into a work table in your target database. Inner join that work table to your target table and spool the row (natural and surrogate keys, or ideally the entire row) out to your hashed file. It will be p...

Why are you posting multiple posts for the same topic?

The stored procedure stage is used to stream output or input rows. If your sp "does something" you need to use sqlplus.

Verify the ORACLE_HOME and SHLIB paths in the dsenv file point to the correct Oracle 32BIT client and you're using the matching plugin.

You'll need to run sqlplus from the command line, using any of the methods available.

Then the path (which you have not shared) must be the problem. From your Batch job, use the DSLogInfo to log the command you are trying to execute. Maybe even do a "dir" command with DSExecute first on the file to see if the path resolves to the physical .bat file. Log the screen output from the dir...

It's considered a BEST PRACTICE to always have a Transformer between two Passive stages, because DS automatically puts one there when compiling the job. Since you're going to have one, you might as well design it that way from the beginning. What you're seeing is the effect of not having two physica...

Not to insult your intelligence, but the job runs on the server, therefore the paths must be local to the server. Any chance you're trying to run a file on your PC and not on the server?