diff options
author | Michael Meskes | 2017-08-25 13:15:03 +0000 |
---|---|---|
committer | Michael Meskes | 2017-08-25 13:17:29 +0000 |
commit | d22e9d530516f7c9c56d00eff53cf19e45ef348c (patch) | |
tree | 8d3d247aa4b7bc3d274343a5a83a0b1904084125 /doc/src | |
parent | 3f4c7917b3bc8b421c0c85cb9995974c55e7232b (diff) |
Implement DO CONTINUE action for ECPG WHENEVER statement.
Author: Vinayak Pokale
Reviewed-By: Masahiko Sawada
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ecpg.sgml | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index f13a0e999f2..3cb4001cc0c 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -4763,6 +4763,17 @@ EXEC SQL WHENEVER <replaceable>condition</replaceable> <replaceable>action</repl </varlistentry> <varlistentry> + <term><literal>DO CONTINUE</literal></term> + <listitem> + <para> + Execute the C statement <literal>continue</literal>. This should + only be used in loops statements. if executed, will cause the flow + of control to return to the top of the loop. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>CALL <replaceable>name</replaceable> (<replaceable>args</replaceable>)</literal></term> <term><literal>DO <replaceable>name</replaceable> (<replaceable>args</replaceable>)</literal></term> <listitem> @@ -7799,6 +7810,7 @@ WHENEVER { NOT FOUND | SQLERROR | SQLWARNING } <replaceable class="PARAMETER">ac <programlisting> EXEC SQL WHENEVER NOT FOUND CONTINUE; EXEC SQL WHENEVER NOT FOUND DO BREAK; +EXEC SQL WHENEVER NOT FOUND DO CONTINUE; EXEC SQL WHENEVER SQLWARNING SQLPRINT; EXEC SQL WHENEVER SQLWARNING DO warn(); EXEC SQL WHENEVER SQLERROR sqlprint; |