DSXchange

Hi I need to query the DataStage repository to know the Jobs using an Oracle8i Stage with a table name "pippo", for example, and to display the type of operation on that table. I can't access directly the repository. May I do a Job, Server or Batch, reading it for extrat the information I ...

Umberto, I am not sure about what you need to do; you posted the question as a UNIX server one, but are asking about DOS; you stated that you want a "before routine" to do something after the job completes successfully. If you has a DOS server installation, you can simply execute date /t ...

Hi there I have to exec a Dos command in the before routine as this: "Echo 2006/03/20 > pippo.dat" to create a flat file at the end of this job, if it run without errors. In this file I have to insert only one row with the current data, as for example "2006/03/20". How can I do t...

No, all I meant was exactly what I said - it all happens as a single unit of work. All the rest is under your control via the link ordering, array size and lastly transaction handling - the number of rows per transaction - that you setup in your job and the Oracle stage. Ok, I understand what do yo...

But the question is. An Oracle Stage used to insert some rows from two input links includes the two insert operation in the same transaction or not? Yes, same transaction as long as we're talking about a single OCI stage. DataStage create only one transaction including both the insert from the two ...

Oracle only locks rows on updates, never on reading. So if you can make sure that for writing/updating DataStage only uses 1 Oracle "connection/session" you don't have a problem. But it may require some creative rewriting of the DataStage job. Use a link collector and you should be fine (...

Umberto, if your designer canvas has those 3 stages and just 2 links then it will do both loads to your table in parallel and using different processes. You can design and configure your job to do things differently, for instance by using a link collector stage for links 1 and 2 to make just one da...

Hi I need of an help about this question. I have a Job, for example, with three stages. - An Oracle8 Stage: To read data from an Oracle table. The output link is link1. - A sequential file Stage: To Read data from a sequential file. The output link is link2. - Another Oracle8 Stage: Insert all the d...

If the second Transformer stage is downstream of the first, all you need to do is to add the stage variable as an extra output column on the output link from the first Transformer stage. No, in my case the second Trasformer stage is not subsequently to the first. In anycase I have to do that for so...

balajisr wrote:It is not possible to refer stage variable of a transformer in another transformer.

--Balaji S.R

Ok, as i supposed it is not possible. Thank you very much

-- Umberto

ArndW wrote:As Balaji has already said, it is not possible; particularly when those transform stages are executed in separate processes. You should pass the data downstream by adding a column with the variable's value to the next transform.

I supposed that. Ok thank you for your answer.

Hi there Does anybody know if it is possible and how to reference to a stage variable created in a trasformer stage from another trasformer stage? For example: ---Trasformer Stage "TStage1" In this stage I createa Stage Variable "X" -- Trasformer Stage "TStage2" How can...

ray.wurlod wrote:No.

However, there is a document about the UniVerse equivalent, that can be found among the UniVerse manuals (use version 9.6) at the IBM "manuals online" website.

I just do it. Thank you again.

Umberto

If, as you claim, you know UV, then you will know of UniObjects, an interface that can present objects via a COM control or as Java classes. DataStage has its equivalent, called dsobjects.dll. This will make available to you all the object you require to access a DataStage repository database. A wa...

kduke wrote:You could also look at processing an export in XML format and not the normal DSX format. Should help get specific things quicker.

Hi
I know that but I need of accessing directly, if it's possible, throught DS API, from a program written c++ language. Thank you anyway for the answer.

Umberto