Hi Everyone,
This is my sequencer design.
Job1 ---> Execute Command ----> Job2
Job1 ---> In job1 I am generating one job name into a text file.
Execute Command ---> I am executing "type path....file.txt".
Job2 ---> I am passing the job name value as a parameter to the job2.
The above sequencer is Aborting and it is generating the below error message. I already searched for the same in the site. But, I didn't understand the exact problem for my sequencer failure. Can anyone help me on this? Thank you.
[b]"POC_Sequencer..JobControl (@Job_Activity_16): Controller problem: Error calling DSSetParam(pJobName), code=-4
[ParamValue/Limitvalue is not appropriate]"[/b]
ParamValue/Limitvalue is not appropriate
Moderators: chulett, rschirm, roy
There are 62 matches for that error message. I picked one at random and it seems to have everything you need in it. If it doesn't help, please let us know why, which part isn't making enough sense and we'll see what we can do about that.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thank you so much Chulett.
I am passing the Execute_Command output to a Before Subroutine as a job name to generate dsjob -report. With your suggestion I used below code in the job activity and it resolved my issue. Thank you.
Code: Trim(EReplace(Execute_Command_18.$CommandOutput,@FM,""),("":'"':""), "A")
Here I was trying to understand @FM behavior, I have gone thru the DataStage documentation this is what I got.
@FM Field mark.
@IM Item mark.
@SM Subvalue mark.
@TM Text mark.
@VM Value mark.
Can you please explain me how @FM is helped to resolve this problem. Thank you.
I am passing the Execute_Command output to a Before Subroutine as a job name to generate dsjob -report. With your suggestion I used below code in the job activity and it resolved my issue. Thank you.
Code: Trim(EReplace(Execute_Command_18.$CommandOutput,@FM,""),("":'"':""), "A")
Here I was trying to understand @FM behavior, I have gone thru the DataStage documentation this is what I got.
@FM Field mark.
@IM Item mark.
@SM Subvalue mark.
@TM Text mark.
@VM Value mark.
Can you please explain me how @FM is helped to resolve this problem. Thank you.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
look for the last comment by Craig in the topic mentioned below
viewtopic.php?p=308527&highlight=#308527
viewtopic.php?p=308527&highlight=#308527
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)