← Back to branch summary

~ubuntu-branches/ubuntu/precise/postgresql-9.1/precise-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/ecpg-sql-commands.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/ecpg-sql-commands.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>Embedded SQL Commands</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="ECPG - Embedded SQL in C"
 
16
HREF="ecpg.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="C++ Applications"
 
19
HREF="ecpg-cpp.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="ALLOCATE DESCRIPTOR"
 
22
HREF="ecpg-sql-allocate-descriptor.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="C++ Applications"
 
57
HREF="ecpg-cpp.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="ECPG - Embedded SQL in C"
 
67
HREF="ecpg.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 33. <SPAN
 
75
CLASS="APPLICATION"
 
76
>ECPG</SPAN
 
77
> - Embedded <ACRONYM
 
78
CLASS="ACRONYM"
 
79
>SQL</ACRONYM
 
80
> in C</TD
 
81
><TD
 
82
WIDTH="10%"
 
83
ALIGN="right"
 
84
VALIGN="top"
 
85
><A
 
86
TITLE="ECPG - Embedded SQL in C"
 
87
HREF="ecpg.html"
 
88
>Fast Forward</A
 
89
></TD
 
90
><TD
 
91
WIDTH="10%"
 
92
ALIGN="right"
 
93
VALIGN="top"
 
94
><A
 
95
TITLE="ALLOCATE DESCRIPTOR"
 
96
HREF="ecpg-sql-allocate-descriptor.html"
 
97
ACCESSKEY="N"
 
98
>Next</A
 
99
></TD
 
100
></TR
 
101
></TABLE
 
102
><HR
 
103
ALIGN="LEFT"
 
104
WIDTH="100%"></DIV
 
105
><DIV
 
106
CLASS="SECT1"
 
107
><H1
 
108
CLASS="SECT1"
 
109
><A
 
110
NAME="ECPG-SQL-COMMANDS"
 
111
>33.14. Embedded SQL Commands</A
 
112
></H1
 
113
><DIV
 
114
CLASS="TOC"
 
115
><DL
 
116
><DT
 
117
><B
 
118
>Table of Contents</B
 
119
></DT
 
120
><DT
 
121
><A
 
122
HREF="ecpg-sql-allocate-descriptor.html"
 
123
>ALLOCATE DESCRIPTOR</A
 
124
>&nbsp;--&nbsp;allocate an SQL descriptor area</DT
 
125
><DT
 
126
><A
 
127
HREF="ecpg-sql-connect.html"
 
128
>CONNECT</A
 
129
>&nbsp;--&nbsp;establish a database connection</DT
 
130
><DT
 
131
><A
 
132
HREF="ecpg-sql-deallocate-descriptor.html"
 
133
>DEALLOCATE DESCRIPTOR</A
 
134
>&nbsp;--&nbsp;deallocate an SQL descriptor area</DT
 
135
><DT
 
136
><A
 
137
HREF="ecpg-sql-declare.html"
 
138
>DECLARE</A
 
139
>&nbsp;--&nbsp;define a cursor</DT
 
140
><DT
 
141
><A
 
142
HREF="ecpg-sql-describe.html"
 
143
>DESCRIBE</A
 
144
>&nbsp;--&nbsp;obtain information about a prepared statement or result set</DT
 
145
><DT
 
146
><A
 
147
HREF="ecpg-sql-disconnect.html"
 
148
>DISCONNECT</A
 
149
>&nbsp;--&nbsp;terminate a database connection</DT
 
150
><DT
 
151
><A
 
152
HREF="ecpg-sql-execute-immediate.html"
 
153
>EXECUTE IMMEDIATE</A
 
154
>&nbsp;--&nbsp;dynamically prepare and execute a statement</DT
 
155
><DT
 
156
><A
 
157
HREF="ecpg-sql-get-descriptor.html"
 
158
>GET DESCRIPTOR</A
 
159
>&nbsp;--&nbsp;get information from an SQL descriptor area</DT
 
160
><DT
 
161
><A
 
162
HREF="ecpg-sql-open.html"
 
163
>OPEN</A
 
164
>&nbsp;--&nbsp;open a dynamic cursor</DT
 
165
><DT
 
166
><A
 
167
HREF="ecpg-sql-prepare.html"
 
168
>PREPARE</A
 
169
>&nbsp;--&nbsp;prepare a statement for execution</DT
 
170
><DT
 
171
><A
 
172
HREF="ecpg-sql-set-autocommit.html"
 
173
>SET AUTOCOMMIT</A
 
174
>&nbsp;--&nbsp;set the autocommit behavior of the current session</DT
 
175
><DT
 
176
><A
 
177
HREF="ecpg-sql-set-connection.html"
 
178
>SET CONNECTION</A
 
179
>&nbsp;--&nbsp;select a database connection</DT
 
180
><DT
 
181
><A
 
182
HREF="ecpg-sql-set-descriptor.html"
 
183
>SET DESCRIPTOR</A
 
184
>&nbsp;--&nbsp;set information in an SQL descriptor area</DT
 
185
><DT
 
186
><A
 
187
HREF="ecpg-sql-type.html"
 
188
>TYPE</A
 
189
>&nbsp;--&nbsp;define a new data type</DT
 
190
><DT
 
191
><A
 
192
HREF="ecpg-sql-var.html"
 
193
>VAR</A
 
194
>&nbsp;--&nbsp;define a variable</DT
 
195
><DT
 
196
><A
 
197
HREF="ecpg-sql-whenever.html"
 
198
>WHENEVER</A
 
199
>&nbsp;--&nbsp;specify the action to be taken when an SQL statement causes a specific class condition to be raised</DT
 
200
></DL
 
201
></DIV
 
202
><P
 
203
>   This section describes all SQL commands that are specific to
 
204
   embedded SQL.  Also refer to the SQL commands listed
 
205
   in <A
 
206
HREF="sql-commands.html"
 
207
>Reference I, <I
 
208
>SQL Commands</I
 
209
></A
 
210
>, which can also be used in
 
211
   embedded SQL, unless stated otherwise.
 
212
  </P
 
213
></DIV
 
214
><DIV
 
215
CLASS="NAVFOOTER"
 
216
><HR
 
217
ALIGN="LEFT"
 
218
WIDTH="100%"><TABLE
 
219
SUMMARY="Footer navigation table"
 
220
WIDTH="100%"
 
221
BORDER="0"
 
222
CELLPADDING="0"
 
223
CELLSPACING="0"
 
224
><TR
 
225
><TD
 
226
WIDTH="33%"
 
227
ALIGN="left"
 
228
VALIGN="top"
 
229
><A
 
230
HREF="ecpg-cpp.html"
 
231
ACCESSKEY="P"
 
232
>Prev</A
 
233
></TD
 
234
><TD
 
235
WIDTH="34%"
 
236
ALIGN="center"
 
237
VALIGN="top"
 
238
><A
 
239
HREF="index.html"
 
240
ACCESSKEY="H"
 
241
>Home</A
 
242
></TD
 
243
><TD
 
244
WIDTH="33%"
 
245
ALIGN="right"
 
246
VALIGN="top"
 
247
><A
 
248
HREF="ecpg-sql-allocate-descriptor.html"
 
249
ACCESSKEY="N"
 
250
>Next</A
 
251
></TD
 
252
></TR
 
253
><TR
 
254
><TD
 
255
WIDTH="33%"
 
256
ALIGN="left"
 
257
VALIGN="top"
 
258
><ACRONYM
 
259
CLASS="ACRONYM"
 
260
>C++</ACRONYM
 
261
> Applications</TD
 
262
><TD
 
263
WIDTH="34%"
 
264
ALIGN="center"
 
265
VALIGN="top"
 
266
><A
 
267
HREF="ecpg.html"
 
268
ACCESSKEY="U"
 
269
>Up</A
 
270
></TD
 
271
><TD
 
272
WIDTH="33%"
 
273
ALIGN="right"
 
274
VALIGN="top"
 
275
>ALLOCATE DESCRIPTOR</TD
 
276
></TR
 
277
></TABLE
 
278
></DIV
 
279
></BODY
 
280
></HTML
 
281
>
 
 
b'\\ No newline at end of file'