DSXchange

Are you using generated or user-defined SQL? A bind variable issue usually means a column count mismatch between the metadata and the SQL. A "Optional feature not implemented" message means that the SQL is not supported via the driver.

How about totally create the parents and children first and write to flat files, using hash files as a means to stage your foreign keys. Then, when ready to load, issue a command like call to sqlplus to execute a couple lines of TRUNCATE TABLE commands in the right order, then bulk load your rows. S...

I suggest you use 2 PC's side-by-side and painstakingly recreate the job.

CDS_IDIN_IN_INDIC not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). This is a big clue. It even tells you how to troubleshoot it. I guess I can help out here and suggest that you verify the spelling, because the message indic...

Manually run means you used Director? But how does your job run every day? Whatever runs your job, Batch, Sequencer, script, whatever, is responsible for setting that value. It is apparently set to 50.

Use either a job parameter or a macro.

Okay, you're posting a Parallel question in the Server forum.

If the file is not local, then either command line FTP it local, use the FTP stage to read it remotely, NFS mount the remote file system, or use rcp to copy it local.

Given a choice between the same hardware running Windoze or running linux (Redhat), why would you give up 1 GB of memory just to run the GUI OS and suffer all of those security leaks? How about a sleak OS that doesn't gobble memory, supports shell scripting natively, and is greatly more stable to ev...

There's no automatic method within the tool. There are reverse-engineered "hack" utilities that could be written, but the only method I use in this circumstance is a staging database that can contain file layout information within a table and dynamically parse it. You could do the same, read the par...

Welcome aboard. Next time, please post in the Server forum. Put the ORACLE_HOME value in your dsenv file and make sure you're pointing to the 32bit Oracle 9i client libraries and use the OCI stage, not the OCI8. OCI is the Oracle 9i plugin, there's no 10g plugin. Be sure to stop/start the engine to ...

In the transformer stage, the primary input stream sets the variable @INROWNUM to be the row count of the data coming into the stage on that link. For each output link, there exists an @OUTROWNUM value that is the row count for all rows that have met the constraint condition to go down that link. So...

Unix over Windoze everytime.

Why? Windoze is a toy.

The issues are the same for everyone with any database: 1. Dates not in the proper form for the stage (OCI or ODBC) connecting to the database 2. Data type mismatches because the ETL didn't properly check or transform the source data 3. Truncations to columns during loading because source data large...

Servers have hostnames and IP's, I suggest you try using one of those.

No synonyms. For example, Oracle OCI plugin metadata import prompts you for ALL OWNERS or a specific schema. It's just selecting from ALL_TABLES to get the tables to import, so therefore, you need to know the schema of interest rather than the synonym. How can you create a synonym to a table you can...