AW: SQL Stored Procedure

Hi,

what syntax are you looking for? RPG free format or SQL?

1. RPG free format looks as follows:
If Field = 2;
   Statement1;
   Statement2;
Else;
   Statement3;
EndIf;

2. SQL syntax looks as follows:
IF Field1 = 2 THEN Statement1;
   Statement2;
   Statement3;
ELSE IF Condition THEN Statement4;
   Statement5;
ELSE Statement6;
   Statement7;
END IF;

Birgitta

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Banerjee, Amitava
Gesendet: Dienstag, 20. Dezember 2005 21:07
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQL Stored Procedure


Hi
I have some more question about stored procedures.

1. I am trying to use IF statement in the stored procedure. With in each IF
there will be a block of statements. How do I do that? I tried the
following:

IF Field1 = 2
     Statement1;
     Statement2;
     Statement3;
Endif;


IF Field1 = 3
     Statement4;
     Statement5;
     Statement6;
Endif;

While compiling, compiler is saying ';' is not valid token after the first
Endif.
Also, this logic is not saying the system that each IF has 3 statements. It
looks like there is only 1 statement attached to the IF conditions.

How do I take care of these two problems?

Please help.

Thanks
Amitava

--------------------------------------------------------

This message (including any attachments) is only for the use of the
person(s) for whom it is intended. It may contain Mattel confidential,
proprietary and/or trade secret information. If you are not the intended
recipient, you should not copy, distribute or use this information for any
purpose, and you should delete this message and inform the sender
immediately.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.