Stored Procedure
Page 1 of 1
Stored Procedure
I have an issue in SQL stored procedure,
I created a TXT type member, which contains sql statements,
File . . . . . . QSQLSRC
Library . . . . AKHILESH
SPCOUNT TXT COUNT OF EMPLOYEES INN EMPPF
code:
CREATE PROCEDURE EMPCOUNT1(OUT COUNT DECIMAL(4,0))
LANGUAGE SQL
BEGIN
SELECT COUNT(*) INTO COUNT FROM AKHILESH.EMPPF;
END
Then I gave the command, 'RUNSQLSTM' to create the stored procedure on the command line.
I gets into the below error,
SQL7032 30 1 Position 1 SQL procedure, function, trigger, or variable
EMPCOUNT1 in PMS203 not created.
please suggest to fix the error.
Thanks in advance,
Akhilesh.
I created a TXT type member, which contains sql statements,
File . . . . . . QSQLSRC
Library . . . . AKHILESH
SPCOUNT TXT COUNT OF EMPLOYEES INN EMPPF
code:
CREATE PROCEDURE EMPCOUNT1(OUT COUNT DECIMAL(4,0))
LANGUAGE SQL
BEGIN
SELECT COUNT(*) INTO COUNT FROM AKHILESH.EMPPF;
END
Then I gave the command, 'RUNSQLSTM' to create the stored procedure on the command line.
I gets into the below error,
SQL7032 30 1 Position 1 SQL procedure, function, trigger, or variable
EMPCOUNT1 in PMS203 not created.
please suggest to fix the error.
Thanks in advance,
Akhilesh.
akhileshgembali- Posts : 2
Join date : 2012-09-23
Similar topics
» Stored Procedure
» How to convert RPG program to Stored procedure (SP)?
» How to create and Use SQL Stored Procedures?
» Retrieve the program/procedure names in the call stack
» Procedure to APYPTF
» How to convert RPG program to Stored procedure (SP)?
» How to create and Use SQL Stored Procedures?
» Retrieve the program/procedure names in the call stack
» Procedure to APYPTF
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|