DSXchange

Right, but is it 1 or 2 special characters that keep showing up or are they random?

There are really many ways to do this, but I am not certain that convert would be the best method. You could - Write a C routine to remove unprintable characters Write a sed/awk command that will do the same and invoke via a sequencer or during sourcing when using a sequential file You could import ...

Would this job design incorporate a stored procedure stage?

What version of the glibc etc... are on your system?

You may have to create a job sequence which retrieves the max() value, writes it to a seq file and then bind this value to a job parm in the sequence. This is one possible way to do it, I am sure there are others.

The filter stage is probably not the best choice for this type of requirement. The "Filter" stage evaluates the expression at runtime for every input row. Because the Transform is compiled it will always be faster than a Filter stage. Also, use of Filter stage should be limited to instance...

And if your desire is to have a contiguous value then the SK generator is not what you want to use anyways.

As far as connectivity is concerned there are really no post installation steps. You should be able to use the console, add a user and then connect. You will need to verify that you can ping the host system from your desktop. Make sure your hosts file on your desktop is correct if not using DHCP/DNS...

What error are you receiving exactly? There can be quite a few reasons that you cannot connect.

The framework does a pretty decent job of determining the best partitioning and sorting methods to use at runtime. If there are keys defined on the link then hash or similar will likely be used. If no keys then likely round robin will be used. If there are keyed operators then it will partition and ...

I think most stages default to 2000 for the commit - not 100% sure though.

Also, a better design might be to do deletes and inserts instead of updates.

Good point Craig, but I "thought" it was simply a disconnect in the original description of the problem

Yep - got to have an Oracle client if you are to use the Oracle Connector - might be why the libraries in question are not found

Have you defined both lib32 and lib in your LD_LIBRARY_PATH for Oracle? Your PATH is correct also and you have defined ORACLE_HOME?

The split in threads seems to actually be a logical one - 2 separate questions really. To answer this question reusable load jobs are perfect for what you want to do. You will need to do a few things in the load job and you will actually probably have three (3) separate load jobs (makes more sense)....

John,

Thanks for the update!

You are most welcome - report back and let us know what they find.