DSXchange

Is there any way that I could figure out whether a column is used in a particular job, without opening job in designer. i.e through Admistrator commands, or through TCL commands could we find out. I need to do impact analysis for so many columns in so many jobs. This is the reason why I am trying to...

chulett wrote:

Code: Select all

XFM --> SP --> OCI --> OCI

...

What does XFM mean here?

kcbland wrote:I'm glad your situation is now resolved. ...

Well. The problem is not solved but i guess i have got enough proof to say that SP will not work this way and we need to call the procedure from the before/after sql.

The SP stage will "do something" for you and give you back an answer, it will not pass rows thru it... If you want to use an SP to get data, then you use the OCI stage and select stored procedure as the SQL method. But SP does pass the rows. If i have a procedure which operates on the inp...

So is there no way i can make this job run i.e. collect the statistics in between two porcess. If splitting the job is the only option then i would rather split tjis job into 2 jobs and in the AfterJobSubRoutine of the first job, i would execute the same statement using ExecSH. No need to go for SP ...

Hold on a minute. Your looks like this: OCI --> SP --> OCI That won't work. Not a chance. Your rows have to stream from one passive stage thru an active stage and to anoth ... Ok. I changed the job like this: OCI_1--> TX1-->SP-->TX2-->OCI_2 OCI_1 is used to select data which is getting updated in a...

What rows were you expecting from this SP? I thought it updates your indexes, why does the returned rows matter? How do you know there are more than 1 row returned? ... The procedure stage is between two oci stages. One oci stage acting as an output selects records from a table and the other stage ...

Can anyone please help me in this.

I tried giving the name "test" in the procedure name and it actually worked!!! Now I am able to collect the statistics of the table but a new problem came up. In the output link, just one row is getting transferred. I read the manual and came to know that for STP to transfer multiple rows,...

It's certainly possible, we call that stats package quite a bit... but typically as a target at the end of a job stream... Can you please let me know how you call the dbms_stats even as a target. I mean the options that you set in the procedure stage. And here i am assuming that whatever statements...

Its not that i have to go for procedure stage. If there is no way we can run that statement in the procedure stage, then i will have to go back and say that DS procedure stage doesnt have the capability to run that statement and we have to go for after/before sql approach. But before that i need to ...

well.. i tried running the procedure in the before sql and t worked. but the standards in our organization says that if we have to run a procedure then we need to use the procedure stage provided by ds. so this problem. regarding input/output columns, Yes i have them but am not using them in the pro...

Hard to understand what you have or don't have defined in the stage at this point. Do you have any columns in your input and output links? ... Yeah. I have input and output links. But the error is not something related to the procedure statement i guess. I tried running the job by giving the wrong ...

Can you Please answer the query raised. How to make that statement run in the procedure stage.

Can you re post the answer... I am not a premium member, so am not able to see the full reply.

But from whatever i have gathered, the four parameters i have hardcoded. So do i still need to define in procedure stage?