|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.19 2001/08/24 18:08:25 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.20 2001/08/26 17:04:02 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter id="ecpg"> |
@@ -805,6 +805,53 @@ exec sql disconnect [<replaceable>connection target</replaceable>]; |
805 | 805 | </listitem> |
806 | 806 | </varlistentry> |
807 | 807 |
|
| 808 | + <!--WARNING: FROM HERE ON THE TEXT IS OUTDATED!--> |
| 809 | + <varlistentry> |
| 810 | + <term>Open cursor statement</term> |
| 811 | + <listitem> |
| 812 | +<para> |
| 813 | + An open cursor statement looks like: |
| 814 | + <programlisting> |
| 815 | +exec sql open <replaceable>cursor</replaceable>; |
| 816 | + </programlisting> |
| 817 | + and is ignore and not copied from the output. |
| 818 | +</para> |
| 819 | + </listitem> |
| 820 | + </varlistentry> |
| 821 | + |
| 822 | + <varlistentry> |
| 823 | + <term>Commit statement</term> |
| 824 | + <listitem> |
| 825 | +<para> |
| 826 | + A commit statement looks like |
| 827 | + <programlisting> |
| 828 | +exec sql commit; |
| 829 | + </programlisting> |
| 830 | + and is translated on the output to |
| 831 | + <programlisting> |
| 832 | +ECPGcommit(__LINE__); |
| 833 | + </programlisting> |
| 834 | +</para> |
| 835 | + </listitem> |
| 836 | + </varlistentry> |
| 837 | + |
| 838 | + <varlistentry> |
| 839 | + <term>Rollback statement</term> |
| 840 | + <listitem> |
| 841 | +<para> |
| 842 | + A rollback statement looks like |
| 843 | + <programlisting> |
| 844 | +exec sql rollback; |
| 845 | + </programlisting> |
| 846 | + and is translated on the output to |
| 847 | + <programlisting> |
| 848 | +ECPGrollback(__LINE__); |
| 849 | + </programlisting> |
| 850 | +</para> |
| 851 | + </listitem> |
| 852 | + </varlistentry> |
| 853 | + |
| 854 | + <!--STARTING HERE IT IS OKAY AGAIN!--> |
808 | 855 | <varlistentry> |
809 | 856 | <term>Other statements</term> |
810 | 857 | <listitem> |
|