enviournment variable(password )in Dyanmic RDBMS stage
Moderators: chulett, rschirm, roy
enviournment variable(password )in Dyanmic RDBMS stage
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
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
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.