I686LINUX/util/I686LINUX/doc/postgresql/html/ecpg-include.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Including Files</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 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="Error Handling"
  19 HREF="ecpg-errors.html"><LINK
  20 REL="NEXT"
  21 TITLE="Processing Embedded SQL Programs"
  22 HREF="ecpg-process.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="ecpg-errors.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="ecpg.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 30. <SPAN
  68 CLASS="APPLICATION"
  69 >ECPG</SPAN
  70 > - Embedded <ACRONYM
  71 CLASS="ACRONYM"
  72 >SQL</ACRONYM
  73 > in C</TD
  74 ><TD
  75 WIDTH="10%"
  76 ALIGN="right"
  77 VALIGN="top"
  78 ><A
  79 HREF="ecpg.html"
  80 >Fast Forward</A
  81 ></TD
  82 ><TD
  83 WIDTH="10%"
  84 ALIGN="right"
  85 VALIGN="top"
  86 ><A
  87 HREF="ecpg-process.html"
  88 ACCESSKEY="N"
  89 >Next</A
  90 ></TD
  91 ></TR
  92 ></TABLE
  93 ><HR
  94 ALIGN="LEFT"
  95 WIDTH="100%"></DIV
  96 ><DIV
  97 CLASS="SECT1"
  98 ><H1
  99 CLASS="SECT1"
 100 ><A
 101 NAME="ECPG-INCLUDE"
 102 >30.10. Including Files</A
 103 ></H1
 104 ><P
 105 >   To include an external file into your embedded SQL program, use:
 106 </P><PRE
 107 CLASS="PROGRAMLISTING"
 108 >EXEC SQL INCLUDE <VAR
 109 CLASS="REPLACEABLE"
 110 >filename</VAR
 111 >;</PRE
 112 ><P>
 113    The embedded SQL preprocessor will look for a file named
 114    <TT
 115 CLASS="LITERAL"
 116 ><VAR
 117 CLASS="REPLACEABLE"
 118 >filename</VAR
 119 >.h</TT
 120 >,
 121    preprocess it, and include it in the resulting C output.  Thus,
 122    embedded SQL statements in the included file are handled correctly.
 123   </P
 124 ><P
 125 >   Note that this is <SPAN
 126 CLASS="emphasis"
 127 ><I
 128 CLASS="EMPHASIS"
 129 >not</I
 130 ></SPAN
 131 > the same as
 132 </P><PRE
 133 CLASS="PROGRAMLISTING"
 134 >#include &lt;<VAR
 135 CLASS="REPLACEABLE"
 136 >filename</VAR
 137 >.h&gt;</PRE
 138 ><P>
 139    because this file would not be subject to SQL command preprocessing.
 140    Naturally, you can continue to use the C
 141    <TT
 142 CLASS="LITERAL"
 143 >#include</TT
 144 > directive to include other header
 145    files.
 146   </P
 147 ><DIV
 148 CLASS="NOTE"
 149 ><BLOCKQUOTE
 150 CLASS="NOTE"
 151 ><P
 152 ><B
 153 >Note: </B
 154 >    The include file name is case-sensitive, even though the rest of
 155     the <TT
 156 CLASS="LITERAL"
 157 >EXEC SQL INCLUDE</TT
 158 > command follows the normal
 159     SQL case-sensitivity rules.
 160    </P
 161 ></BLOCKQUOTE
 162 ></DIV
 163 ></DIV
 164 ><DIV
 165 CLASS="NAVFOOTER"
 166 ><HR
 167 ALIGN="LEFT"
 168 WIDTH="100%"><TABLE
 169 SUMMARY="Footer navigation table"
 170 WIDTH="100%"
 171 BORDER="0"
 172 CELLPADDING="0"
 173 CELLSPACING="0"
 174 ><TR
 175 ><TD
 176 WIDTH="33%"
 177 ALIGN="left"
 178 VALIGN="top"
 179 ><A
 180 HREF="ecpg-errors.html"
 181 ACCESSKEY="P"
 182 >Prev</A
 183 ></TD
 184 ><TD
 185 WIDTH="34%"
 186 ALIGN="center"
 187 VALIGN="top"
 188 ><A
 189 HREF="index.html"
 190 ACCESSKEY="H"
 191 >Home</A
 192 ></TD
 193 ><TD
 194 WIDTH="33%"
 195 ALIGN="right"
 196 VALIGN="top"
 197 ><A
 198 HREF="ecpg-process.html"
 199 ACCESSKEY="N"
 200 >Next</A
 201 ></TD
 202 ></TR
 203 ><TR
 204 ><TD
 205 WIDTH="33%"
 206 ALIGN="left"
 207 VALIGN="top"
 208 >Error Handling</TD
 209 ><TD
 210 WIDTH="34%"
 211 ALIGN="center"
 212 VALIGN="top"
 213 ><A
 214 HREF="ecpg.html"
 215 ACCESSKEY="U"
 216 >Up</A
 217 ></TD
 218 ><TD
 219 WIDTH="33%"
 220 ALIGN="right"
 221 VALIGN="top"
 222 >Processing Embedded SQL Programs</TD
 223 ></TR
 224 ></TABLE
 225 ></DIV
 226 ></BODY
 227 ></HTML
 228 >