Job parameter in Stored procedure.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Mon Aug 08, 2005 12:51 am
Job parameter in Stored procedure.
Hi
I'm using Stored Procedure Stage to run a procedure which will truncate the table before loading it Target table.
Issue:
When I pass the job parameters in the fields Database , Datasource, UserId and Pssword, it is throwing a run time error(Invalid username/pwd).
Since, this is the first time I am using a stored procedure stage, can anyone please confirm the usage of job parameters in this stage. Whether it can be used or we should hard code the UID credentials.
Thanks
Deepak
I'm using Stored Procedure Stage to run a procedure which will truncate the table before loading it Target table.
Issue:
When I pass the job parameters in the fields Database , Datasource, UserId and Pssword, it is throwing a run time error(Invalid username/pwd).
Since, this is the first time I am using a stored procedure stage, can anyone please confirm the usage of job parameters in this stage. Whether it can be used or we should hard code the UID credentials.
Thanks
Deepak
-
- Participant
- Posts: 11
- Joined: Mon Aug 08, 2005 12:51 am
-
- Participant
- Posts: 11
- Joined: Mon Aug 08, 2005 12:51 am
-
- Participant
- Posts: 11
- Joined: Mon Aug 08, 2005 12:51 am
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
Hold on there Tex. Some stages, like the Teradata API will NOT work correctly with environment variables. That is, parameters that contain dollar signs. It could be that the 8.x Stored Procedure is also such a stage. Try a parameter without the dollar sign. If it works, there you go, you can't use the Project level parameters. Politely ask IBM why and if it wouldn't be too much of a bother, would they mind too awfully, coding a friggin patch.
That could very well be, considering it doesn't just give some sort of "invalid userid/password" response but instead falls over dead.
Keep in mind the original question was "can we use job parameters in the SP stage" which the answer is still an emphatic yes. The issue of using User Defined Environment Variable job parameters in the stage, however, is a whole 'nuther kettle of fish it seems.
Keep in mind the original question was "can we use job parameters in the SP stage" which the answer is still an emphatic yes. The issue of using User Defined Environment Variable job parameters in the stage, however, is a whole 'nuther kettle of fish it seems.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers