enviournment variable(password )in Dyanmic RDBMS stage

[abhay10]

Hi all,
i am struck up with a requirement where i have to execute a stored procedure after after the job finishes . and i am using the dynamic RDBMS stage to achieve this but i am not able to achieve it using environment variables like for (password) since it takes it in the encrypted form
can anyone plzz help me out with a solution for this

[chulett]

That really shouldn't matter. What 7.x version are you using? Do you not have the Stored Procedure stage available?

[abhay10]

ya thats true but it increases the number of jobs what we have to create

since i have to call the procedure after the job is being executed we need to create another job for executing the stored procedure .since the odbc stage can have only either the input or the output link .

is there any solution out where a we can insert the data to temporary table through the job and after that call a stored procedure to perform the task

[ray.wurlod]

In a parallel job, no.

No passive stage is permitted to have an input link and an output link (not counting reject links). This is an absolute rule in parallel jobs.

[chulett]

Of course, an after-job routine or script can execute your stored procedure. Suggest you code a script and get it running outside of DataStage first, then add it to your job.

[chulett]

Back to your original problem as stated, there shouldn't be an issue using an encrypted password in any DB stage. What makes you say you are "unable to achieve it"? What exact issue are you having?

[abhay10]

yup
thanks all i was able to achive it by opening the stage in the grid style mode

[abhay10]

yup
thanks all i was able to achive it by opening the stage in the grid style mode

[chulett]

Because you were then able to use the parameter helper tool to populate the field? Then your whole issue was a typing error?