Page 1 of 1

How to Call DSSetUserStatus (value) in Oracle stage.

Posted: Tue Oct 18, 2005 7:25 am
by 120267
Hi,
Iam using simple one to one mapping,After the data get loads in to the target oracle stage.I want to call DSSetUserStatus (value) .Is there any possible to do this.

Thanks,
SivaG

Posted: Tue Oct 18, 2005 7:29 am
by kcbland
Have you looked at using the after-job routine? How do you propose to decide what status to set? You can't "see" the Oracle stage, so there's no way to return any information from that stage.

What need are you trying to meet?

Posted: Tue Oct 18, 2005 4:28 pm
by ray.wurlod
Stages that connect to persistent storage are properly passive stages; that is, they do not perform any execution. Therefore there is no scope in them to invoke routines.

Please advise what you are trying to achieve. It's likely, as Ken suggested, that you can achieve what you want to achieve in an after-stage subroutine (from the Transformer stage that drives the load) or an after-job subroutine.

The question is, what is the value that you want to load into the job's user status area?