Token SQL was not valid.

[Keith]

I am trying to create my first stored procedure using ISeries
Navigator. I receive the following error.

Token SQL was not valid. Valid tokens: C CL COBOL COBOLLE FORTRAN PLI
RPG RPGLE JAVA.

In the New SQL Procedure form I have put the name of the procedure in
on the general tab and used the following code in the SQL Statements
tab.

CREATE PROCEDURE Quote_Report()
LANGUAGE SQL READS SQL DATA
BEGIN
DECLARE variable1 INTEGER;
SET variable1 = 22215;
SELECT PQCLQ#, PQBTC#
FROM OMQMPF
WHERE PQCLQ# = variable1;
END

I will enter parameters after I get this to run.

I have written many sp in MS SQL that I call from crystal reports,
which what my final goal is.

Thanks in advance

Keith

[Tonkuma]

I don't know so much about iSeries.
But, this Note may be related with your problem.

iSeries
DB2 Universal Database for iSeries SQL Reference
Version 5

Chapter2. Language Element

Tokens
....
....
Note: $, @, #, and all other variant characters should not be used in
identifiers
because the code points used to represent them vary depending on the
CCSID of the string in which they are contained. If they are used,
unpredictable results may occur. For more information about variant
characters, see the Variant characters topic in the iSeries Information
Center.