View previous topic :: View next topic
|
Author |
Message |
Vinodc
New User
Joined: 01 Dec 2005 Posts: 33 Location: Prague
|
|
|
|
Hi,
I have a simple requirement for creating a job which will -
- Read a sequential file,
- Extract a particular value from the 3rd record.
- Assign that value to a symbolic parameter which is used in a proc in next step.
I know how to code first two steps, but am not quite sure about third. Is there any way to assign a value to symbolic parameter used in catalogued procedure by reading a sequential file.
I tried referring manuals but could see only two way - SET and assigning in EXEC stmt for assigning values to symbolic parameters. So I am not very optimistic that my problem will have a solution, but you never know, there are many experts in this forum.
Any sort of help will be appreciated, Thanks in advance.
Vinod Chawda |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Quote: |
Is there any way to assign a value to symbolic parameter used in catalogued procedure by reading a sequential file?
|
Not within the same job. Any symbolics must be resolved by the job BEFORE the job can be submitted for execution.
You'll have to pass the symbolic value to a subsequent job, or pass it by some other means. |
|
Back to top |
|
|
Vinodc
New User
Joined: 01 Dec 2005 Posts: 33 Location: Prague
|
|
|
|
Quote: |
Not within the same job. Any symbolics must be resolved by the job BEFORE the job can be submitted for execution.
You'll have to pass the symbolic value to a subsequent job, or pass it by some other means. |
Hi SuperK,
I can create a new job to add third step to it and make it successor of the first, so no issues in it. Can you please explain me how to pass this value to the new job?
Thank you so much.
Vinod |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Use a combination of the INCLUDE and SET statements. |
|
Back to top |
|
|
|