How to Call DSSetUserStatus (value) in Oracle stage.

120267 · Post by **120267** » Tue Oct 18, 2005 7:25 am

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

kcbland · Post by **kcbland** » Tue Oct 18, 2005 7:29 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2005 4:28 pm

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?