Stored Procedures on Online V5.1

[hrego]

Hi, I'm having trouble creating a Stored Procedure for the first time on a box running Online V5.1 and SQL V4.20.
I can create a s.p. with nothing in it (no statements of any kind), but when I add anything useful, it produces a syntax error on the first line.
e.g. Define a_variable INT;

Same result if the first clause is a Select statement, or whatever.
Is there an incompatibility between the product versions I'm running, or a setup/admin. issue ?
I'm using stored procs. quite happily on other servers, running Dynamic Server 7.3

 

[hrego]

Answered it myself. I was trying to create the SP via ISQL, which sees a semi-colon as an end-of-file character.
Stored Procs use semi-colons to delimit each statement.
Overcome by using dbaccess to create the SP.