DSXchange

You could submit this to IBM/Ascential support and see if there is an alternative. We'd be curious to hear what the response it.

The function/derivation you are looking for is FMT(In.Column,'5"0"R')

Kab123, there are a few who use CDC. Yours would be the first post that I see where no answer at all is forthcoming. I get the same warning for all columns that are neither key nor used for CDC and think that this is just the way that things work, I can only get use a handler to demote the message t...

I am mystified. Can you run the job on a temporary 1-node configuration file and see if the duplicates go away (or on a 4-node to see if they multiply). Also, do you specify the Oracle stage "partition" value?

I tend to re-compile jobs when working on them and they abort; but for server jobs at least both will result in a program that is in a runnable state. The RESET has additional function of checking data sources and targets and I find that this can take longer to check uneccessarily than a quick recom...

Odd.

Do you have a 2-node configuration and do the duplicate rows show up together in your text file? You should be using the "Auto" partitioning going into your transformer stage, and I cannot change my Oracle enterprise stage away from sequential here .

By default that is what PX does, it doesn't send all rows down all streams unless you explicitly tell it do do so by specifying "entire" for the partitioning algorithm.

How are you ascertaining the row duplications in your job?

Piotrek, you have the option of doing bulk inserts in DB/2, are you doing this or using some form of update/insert? Is this table partitioned - if so then the PX load ought to be faster than a server job. Do other tables load faster? Does this table have constraints/triggers or is it some form of a ...

Sreenivasulu, I won't argue with your stating that you "need" to connect to Oracle from the job control; since there are other easier methods of doing this - i.e. writing a dummy job that takes your SQL command as a parameter and uses that in a OCI or ODBC stage. Since you can run unix scripts from ...

I don't recognize that quote, but I think if we continue along this vein someone is going to put us on double secret probation

Your DEFFUN is fine, but a function returns a value, so needs to be part of an assignment statement. You need to specify a line like:

The first paragraph was too obscure, sorry. The DSAttachJob() routine is written in the BASIC language, as are many DS internal functions and routines. I think that when the job log is cleared a filelock is taken, but my system here is too fast to let me confirm that. Can you change your autopurge s...

No direct problem, except the scripts wants a complete file but is only getting one row per call. Create a pipe somewhere on your system with mkfifo mypipe.fifo Execute a shell command at the beginning of the job in the before-job call doing a nohup {yourscript} mypipe.fifo param2 param3 &...

Since the log file is present, the failure to open the log file should only come if the OPEN statement is executed without the LOCKED option (something Ray always puts in and I never do, I just let it fail in my programs). So if such a statement without a LOCKED clause is used in the DSAttachJob() r...

I was thinking that you could do a begin-transaction wrapper in a database programming system around every step done and not to do a commit until the end; but that would only work if staying within the database itself - and as long as enough disk space is available. But Craig is right in pointing ou...