DSXchange

What stage are you using?

ORAOCI9

Does your support provider have a solution?

I have a PMR open with IBM, but not answer from them yet.

Hello all, I'm using the Oracle OCI Stage to populate an Oracle table, I have an strange behaviour, when the table is empty, i can populate it with no problem. If it has data, and one of the date fields has a date with a year in the range of XX32 - XX99, the job doesn't work raising the error "...

I guess you meant "start using custom SQL Statement ..."
I tried it and the custom SQL gets erased when I switched to SQL Builder

Hello all, Please take a look to the following question and leave your comments. The SQL Builder, for Oracle stages, has been of great help for my current project and I want to keep using it. My question is if there is some way to get a variable or parametric name as the schema name? Perhaps doing s...

can DataStage read/write data from it. I am afraid I don't quite understand your question: WBI is not a repository of data of any kind. It works as a router and reformatter of data but it does not storage it. Your questions is a little vague, so I can only guess what you are trying to accomplish: I...

Your problem might be with this: Wait Time is set to -1, so that MQ connectr keeps on reading msgs for infinite time. When using "Selective Reading" with MQ it is recommended to clear the MQMD fields used as filters after every successful loop thru the queue. Of course this is only possibl...

Probably IBM WebSphere Business Integrator, an old version of WebSphere MQ Broker.

Main post has some similiraty with this one.

Check if there is another application getting messages from the queue. Check IBM.com for patches for your Queue Manager installation. You will probably need to "trace" the queue from the WMQ perspective to see how the messages are extracted from the queue. I think MQ, after finishing one c...

Done. Thank you!
Excelent help as usual.

kcbland wrote:When the Transformer starts, the stage variables initialize themselves. This can include running a process such as a Function...

With this approach the function will be called once for every row processed by the job, right? Impacting job performance directly.

Hello all, I need your help again :) This time with a Before-Job Subroutine. I customized some code found in this forum to access an Oracle table from my routine, this is an excerpt of the code: Stmt= "select max(":field:") from ":table: " ;" Call DSLogInfo("Query ...

Apparently is a product bug. Opened a PMR, but still don't have final answer from IBM.

Change the value "0" to "1" for ReadOnly prameter... and import again..

I can't, Designer does not let me overwrite a ReadOnly routine.

It will not appear in DS_ROUTINES if it has not been compiled yet

It is compiled but still it does not appear there.
[/quote]