little tips and tricks, which i stumbled upon randomly

Tuesday, May 29, 2012

Sybase IQ equavelent for while break structure


Sybase IQ uses labes to exit loops. Instead of break you have to use exit label structure.

Sample "while break" code:
.
.
lbl:
WHILE 10 <15 LOOP
SET i = 1;
IF i = 1 THEN
     LEAVE lbl;
END IF;
END LOOP lbl
.
.

0 comments:

Post a Comment