SELECT CTR_POL_NUM, CTR_RSA_TOT_PREM
FROM DMIDBO.CTR_TRANSACTION
WHERE CTR_SOURCE_SYSTEM IN ('HC' , 'HF')
AND CTR_POL_NUM IN (#ppFNDPolicyList#)
GROUP BY CTR_POL_NUM
WITH UR
;
And I have successfully imported the data using the exec command stage, however it seems to not like putting the data into my above parameter (which is defined as a List).
db2testing..JobControl (@jobDB2FNDtest): Controller problem: Error calling DSSetParam(ppFNDPolicyList), code=-4
[ParamValue/Limitvalue is not appropriate]
Is what I am trying to do even possible?? Should I be using a script in the command line instead of just reading my sequential file? can this parameter handle multiple values?
a2love wrote:And I have successfully imported the data using the exec command stage, however it seems to not like putting the data into my above parameter (which is defined as a List).
Make it a String - List sounds highly inappropriate for what you are doing. Any value that you send in that is not in your List of valid values will generate the -4 error.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Ok that makes sense about the list, thanks for the input I was unaware of how exactly the list setting worked.
I have formatted my input .txt file to have all values on one line... i.e. '12345','54321',
This parameter is now defined as a string as well. I am still recieving the same error.
Where exactly/how should i use the format() command? this may be a dumb question but I'm pretty new.
And are there any alternate methods to this approach? I have recieved a suggestion to use routine activity with sql code to grab the information. Is that possible? If so, any tactics on how to accomplish that?
Now you need to follow DSGuru's advice re: the @FM characters. If you are using a Sequence job and $CommandOutput to populate the parameter, try changing it to $CommandOutput<1> and see if that does the trick by itself.
-craig
"You can never have too many knives" -- Logan Nine Fingers
db2testing_exec_command..JobControl (@Execute_Command_8): Executed: type \\Nho04\micpriv\Adam\CPC_Datasets\ER_CPC_Unmatched_HUON_PolicyNumbers.txt
Reply=0
Output from command ====>
'0136530000','0322430008','0414643009','0532516008',
however I am still getting the same error. My parameter is defined as a string, yet the string I pass in using Exec. command seems to always give me this error:
Your errors are due to the LF or @FM as i suggested before. If you can run the above without compilation errors, you should be able to run Field(). Also, dont do this at the triggers. Do it inside job activity while providing expression for your job parameter.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.