Hi I am trying to create my first stored procedure on ISeries navigator but cant get it to work, transitioning from SQL server. I am trying to execute this inside ISERIES Navigator->stored procedures -> New stored procedure-> SQL Statement
CREATE PROCEDURE sp_test
select * from Customer.Table1
Create procedure Customer.SelectCustomers
LANGUAGE SQL READS SQL DATA
SELECT * from Customer.Customers;
It says A syntax error was detected at token SQL. Token SQL is not a valid token. A partial list of valid tokens is C CL COBOL COBOLLE FORTRAN PLI RPG RPGLE JAVA. This list assumes that the statement is correct up to the token. The error may be earlier in the statement, but the syntax of the statement appears to be valid up to this point.