Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
paddu
Premium Member
Posts: 232 Joined: Tue Feb 22, 2005 11:14 am
Location: California
Post
by paddu » Fri Feb 22, 2008 5:48 pm
Filename i need to access has varying timestamp. I am trying to get filename at run time using pattern matching through command prompt.
My command in Execute command Stage is
dir ETLserverpath\R_test_Product* /B
Output from command ====>
R_test_Product_200802141522.csv
I am passing this value to job parameter as
File_Name:Execute_Command_1.$CommandOutput
I got following error .
Exception raised: @Job_Activity_0, Error calling DSSetParam(File_Name), code=-4 [ParamValue/Limitvalue is not appropriate]
What am i doing wrong???
Any suggestions appreciated
Thanks
Paddu
There is nothing good or bad, but thinking makes it so. --William Shakespeare
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Feb 22, 2008 6:27 pm
What are you doing wrong? Not searching before posting. This has been discussed a bajillion times, please have a go at searching for a significant portion your error message, such as:
ParamValue/Limitvalue is not appropriate
-craig
"You can never have too many knives" -- Logan Nine Fingers
paddu
Premium Member
Posts: 232 Joined: Tue Feb 22, 2005 11:14 am
Location: California
Post
by paddu » Fri Feb 22, 2008 6:56 pm
Thanks chulett.
I did not search efficiently . Will search the keywords
There is nothing good or bad, but thinking makes it so. --William Shakespeare
paddu
Premium Member
Posts: 232 Joined: Tue Feb 22, 2005 11:14 am
Location: California
Post
by paddu » Fri Feb 22, 2008 7:19 pm
Thanks it worked fine now .
I gave Field(Execute_Command_1.$CommandOutput,@FM,1) in job parameter and it worked .
Sorry for not doing thorough search at first step.
Thanks
Paddu
There is nothing good or bad, but thinking makes it so. --William Shakespeare