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

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

Stored Procedure

View previous topic View next topic Go down

Stored Procedure

Post  akhileshgembali on Fri Sep 28, 2012 2:35 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: 1
Join date: 2012-09-23

View user profile Send private message

Back to top

akhileshgembali

Posts : 2
Join date : 2012-09-23

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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