You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Add to support implicit cursor using like Oracle
for example:
FOR X IN (
SELECT statement
) DO
BEGIN
IF (X.F1 > 0) THEN
INSERT INTO TABLE2 (
F1, F2, F3
) VALUES (
X.F1, X.F2, X.F3);
END
It's good to be reduced a many declaration of local variable.
For example:
AS
DECLARE VARIABLE V1 INTEGER;
DECLARE VARIABLE V2 INTEGER;
DECLARE VARIABLE V3 INTEGER;
...
DECLARE VARIABLE Vn INTEGER;
BEGIN
FOR
SELECT
F1, F2, F3, ..., Fn
FROM
TABLEX
INTO
V1, V2, V3, ..., Vn
DO
...
END
The text was updated successfully, but these errors were encountered:
Submitted by: Montri Patchaiyo (k1)
Duplicates CORE4403
Add to support implicit cursor using like Oracle
for example:
FOR X IN (
SELECT statement
) DO
BEGIN
IF (X.F1 > 0) THEN
INSERT INTO TABLE2 (
F1, F2, F3
) VALUES (
X.F1, X.F2, X.F3);
END
It's good to be reduced a many declaration of local variable.
For example:
AS
DECLARE VARIABLE V1 INTEGER;
DECLARE VARIABLE V2 INTEGER;
DECLARE VARIABLE V3 INTEGER;
...
DECLARE VARIABLE Vn INTEGER;
BEGIN
FOR
SELECT
F1, F2, F3, ..., Fn
FROM
TABLEX
INTO
V1, V2, V3, ..., Vn
DO
...
END
The text was updated successfully, but these errors were encountered: