PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Stored Procedure

Go down

Stored Procedure Empty Stored Procedure

Post  akhileshgembali Fri Sep 28, 2012 2:32 pm

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.

akhileshgembali

Posts : 2
Join date : 2012-09-23

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum