Need assistance with LUW Stored procedures

Jay Huffman

Need assistance with LUW Stored procedures
All -
I need some assistance with stored procedures on my AIX machine.
Any assistance would be appreciated -

I think it is some basic environmental thing -
code:
CREATE PROCEDURE simple1 ()
LANGUAGE SQL
NO EXTERNAL ACTION
PARAMETER ASCII
SPECIFIC simple1

dd: BEGIN
DECLARE var1 INT;
END dd;


errors below -
this simple code should compile and load --

> db2 -vf simple1.sql
CREATE PROCEDURE simple1 ()

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1760N The CREATE statement for stored procedure "SIMPLE1" must have a
valid LANGUAGE clause, EXTERNAL clause and PARAMETER STYLE clause. LINE
NUMBER=1. SQLSTATE=42601

LANGUAGE SQL
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "LANGUAGE
SQL". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601

NO EXTERNAL ACTION
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "EXTERNAL" was found following "NO ". Expected
tokens may include: "JOIN <joined_table>". SQLSTATE=42601

PARAMETER ASCII
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following
"PARAMETER ASCII". Expected tokens may include: "JOIN <joined_table>".
SQLSTATE=42601

SPECIFIC simple1
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "SPECIFIC
simple1". Expected tokens may include: "JOIN <joined_table>".
SQLSTATE=42601

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm