scriptengine/tests/createproc.sql

/* This test illustrates the different ways it is possible to define a stored procedure */

/*Case 1. No statement terminator - also tests ignoring reserved words in comments*/

Create Procedure MyProc1
As
  Declare THECOUNTRY VarChar(32);
Begin
 //Begin
 THECOUNTRY = '';
  Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = :THECOUNTRY;
 /* End */
End


/*Case 2. ';' as statement terminator*/

Create Procedure MyProc2
As
Begin
  Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = '';
End;

/*Case 3. '^' as statement terminator*/

set term ^;
Create Procedure MyProc3
As
Begin
  Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = '';
End^
set term ;^


Revision:	37
Committed:	Mon Feb 15 14:44:25 2016 UTC (8 years, 9 months ago) by tony
Content type:	application/sql
File size:	661 byte(s)
Log Message:	Committing updates for Release R1-4-0
#	Content
1	/* This test illustrates the different ways it is possible to define a stored procedure */
2
3	/Case 1. No statement terminator - also tests ignoring reserved words in comments/
4
5	Create Procedure MyProc1
6	As
7	Declare THECOUNTRY VarChar(32);
8	Begin
9	//Begin
10	THECOUNTRY = '';
11	Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = :THECOUNTRY;
12	/* End */
13	End
14
15
16	/Case 2. ';' as statement terminator/
17
18	Create Procedure MyProc2
19	As
20	Begin
21	Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = '';
22	End;
23
24	/Case 3. '^' as statement terminator/
25
26	set term ^;
27	Create Procedure MyProc3
28	As
29	Begin
30	Update COUNTRY SET COUNTRY = 'None' Where COUNTRY = '';
31	End^
32	set term ;^
33
34
35