Hi,
Have created a very simple Stored Procedure to hit a Terradta dbase on SQL Assistant V12. ON SQL Assistant the SP works fine when called.
I am no however trying to call from Datastage using the SP stage and get ...
'RDBMS code 5510: Invalid session mode for procedure execution'.
I assume I must be in a different session mode on DS as I am on SQl Assistant but am not sure how to check/amend this on either side.
Any help gratefully received.
Store Procedure Failure
Moderators: chulett, rschirm, roy
Detail the settings you are using in the stage for us. Not sure if that will help but we may as well get as complete information here as we can.
You might also want to ask on a Teradata forum like this one to see what needs to be done in general to solve this.
You might also want to ask on a Teradata forum like this one to see what needs to be done in general to solve this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The settings in the job are ...
procedure type = source
DB proc type = SP
Generate procedure call is checked
The SP itself is ...
CREATE PROCEDURE TEST1 (
OUT CduCin BIGINT
)
BEGIN
SELECT FIELD1 INTO CduCin FROM TABLE1
WHERE FIELD1 = 1;
END;
I have posted on the dbase side as well.
Thanks & Regards.
procedure type = source
DB proc type = SP
Generate procedure call is checked
The SP itself is ...
CREATE PROCEDURE TEST1 (
OUT CduCin BIGINT
)
BEGIN
SELECT FIELD1 INTO CduCin FROM TABLE1
WHERE FIELD1 = 1;
END;
I have posted on the dbase side as well.
Thanks & Regards.