hi all
try to all a dos sqlplus command:
sqlplus -s #user_name#@#dbname#/#passwoard#@#name.sq#
i need to parameter all the values in ##
i found this thread:
viewtopic.php?p=377537
I created a sequential wrapper job to pass all the parameters in but it still doesn't work, does anyone know why?
put parameter in before-job subroutine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No idea, because you have not told us what's in your wrapper.
The job is already executing when its before-job subroutine executes, so it's too late to try to set parameter values at that point. You can only set job parameter values before the job run request is actually made.
This will typically involve using a sequence job, or running your job from a dsjob command line or from a Job Control routine.
The job is already executing when its before-job subroutine executes, so it's too late to try to set parameter values at that point. You can only set job parameter values before the job run request is actually made.
This will typically involve using a sequence job, or running your job from a dsjob command line or from a Job Control routine.
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.