By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Token SQL was not valid.

P: n/a
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

Aug 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Aug 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.