File: gnade.html

package info (click to toggle)
gnade 1.2.0-4
links: PTS
area: main
in suites: woody
size: 3,036 kB
ctags: 245
sloc: ada: 11,642; sh: 1,827; makefile: 591; sql: 422; awk: 29
file content (728 lines) | stat: -rw-r--r-- 9,370 bytes
<HTML
><HEAD
><TITLE
>GNADE User's Guide</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="NEXT"
TITLE="Preface"
HREF="ch00.html"></HEAD
><BODY
CLASS="BOOK"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="BOOK"
><A
NAME="GNADE"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="TITLE"
><A
NAME="AEN2"
>GNADE User's Guide</A
></H1
><H2
CLASS="SUBTITLE"
>GNADE, The GNat Ada Database Environment</H2
><H2
CLASS="SUBTITLE"
>Version 1.2.0</H2
><H2
CLASS="SUBTITLE"
>Document Revision $Revision: 1.26 $</H2
><H3
CLASS="AUTHOR"
><A
NAME="AEN9"
>Michael Erdmann</A
></H3
><H3
CLASS="AUTHOR"
><A
NAME="AEN12"
>Jrgen Pfeifer</A
></H3
><H4
CLASS="EDITEDBY"
>Edited by</H4
><H3
CLASS="EDITOR"
>Michael Erdmann</H3
><P
CLASS="COPYRIGHT"
>Copyright &copy; 2001 by <SPAN
CLASS="HOLDER"
>J.Pfeifer, M. Erdmann</SPAN
></P
><DIV
CLASS="LEGALNOTICE"
><P
></P
><BLOCKQUOTE
CLASS="BLOCKQUOTE"
><P
>      Permission is granted to copy, distribute and/or modify this document
      under the terms of the GNU Free Documentation License, Version 1.1
      or any later version published by the Free Software Foundation;
      with no Invariant Sections, with the Front-Cover Texts being 
      "The GNat Ada Database Environment".
      A copy of the license is included in the section entitled "GNU
      Free Documentation License".
   </P
></BLOCKQUOTE
><P
></P
></DIV
><HR></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
HREF="ch00.html"
>Preface</A
></DT
><DT
>I. <A
HREF="part1.html"
>Introduction</A
></DT
><DD
><DL
><DT
>1. <A
HREF="objectives.html"
>Project Objectives</A
></DT
><DT
>2. <A
HREF="license.html"
>Software License</A
></DT
><DT
>3. <A
HREF="trademarks.html"
>Trademarks</A
></DT
><DT
>4. <A
HREF="platfforms.html"
>Supported Databases and OS platforms</A
></DT
><DT
>5. <A
HREF="getstarted.html"
>Getting started</A
></DT
><DD
><DL
><DT
><A
HREF="getstarted.html#AEN106"
>Installation on Unix like systems</A
></DT
><DT
><A
HREF="x137.htm"
>Installation on Windows NT</A
></DT
></DL
></DD
><DT
>6. <A
HREF="yourdb.html"
>Using the release with your database</A
></DT
><DD
><DL
><DT
><A
HREF="yourdb.html#AEN155"
>If your data base is not supported</A
></DT
><DT
><A
HREF="x173.htm"
>Installation of the ODBC Interface</A
></DT
><DT
><A
HREF="x180.htm"
>Prepared Example Programs</A
></DT
></DL
></DD
><DT
>7. <A
HREF="gnadeparts.html"
>Contents of the GNADE distribution</A
></DT
><DT
>8. <A
HREF="contact.html"
>Contact</A
></DT
><DT
>9. <A
HREF="authors.html"
>Authors</A
></DT
></DL
></DD
><DT
>II. <A
HREF="esql.html"
>GNU Embedded SQL Translator for Ada 95</A
></DT
><DD
><DL
><DT
>10. <A
HREF="esqlintro.html"
>Introduction to Embedded SQL</A
></DT
><DT
>11. <A
HREF="esqlsyntax.html"
>Embedded SQL Syntax Specification</A
></DT
><DD
><DL
><DT
><A
HREF="esqlsyntax.html#AEN252"
>The GNU Ada 95 Embedded SQL</A
></DT
><DT
><A
HREF="x255.htm"
>Embedded SQL statement</A
></DT
><DT
><A
HREF="x264.htm"
>SQL Query and FETCH clause</A
></DT
><DT
><A
HREF="x271.htm"
>Embedded SQL declare section</A
></DT
><DT
><A
HREF="x281.htm"
>Embedded Exception Declaration</A
></DT
><DT
><A
HREF="x303.htm"
>Handling of return codes</A
></DT
><DT
><A
HREF="x308.htm"
>SQL Communication Area</A
></DT
><DT
><A
HREF="x320.htm"
>Connection Handling</A
></DT
><DT
><A
HREF="x331.htm"
>Cursor Handling</A
></DT
><DT
><A
HREF="x342.htm"
>Mixing ODBC and embedded SQLcode</A
></DT
><DT
><A
HREF="x350.htm"
>Dynamic SQL</A
></DT
><DT
><A
HREF="x364.htm"
>GNADE Specific Datatypes</A
></DT
></DL
></DD
><DT
>12. <A
HREF="esqltrans.html"
>The ESQL Translator</A
></DT
><DD
><DL
><DT
><A
HREF="esqltrans.html#AEN376"
>Compilation Process</A
></DT
><DT
><A
HREF="x385.htm"
>Invocation of the GNU ESQL Translator (gesql)</A
></DT
></DL
></DD
></DL
></DD
><DT
>III. <A
HREF="odbc.html"
>ODBC bindings for Ada 95</A
></DT
><DD
><DL
><DT
>13. <A
HREF="odbintro.html"
>Introduction to ODBC</A
></DT
><DT
>14. <A
HREF="odbcuse.html"
>Using the Ada 95 ODBC Bindings</A
></DT
><DD
><DL
><DT
><A
HREF="odbcuse.html#AEN452"
>General remarks</A
></DT
><DT
><A
HREF="x456.htm"
>A minimal odbc example</A
></DT
><DT
><A
HREF="x487.htm"
>Implemented ODBC methods</A
></DT
></DL
></DD
><DT
>15. <A
HREF="odbc_ch02.html"
>Building ODBC based programs</A
></DT
><DT
>16. <A
HREF="adaodbc.html"
>Ada95 aspects of the ODBC binding</A
></DT
></DL
></DD
><DT
>IV. <A
HREF="bindings.html"
>Native Bindings</A
></DT
><DD
><DL
><DT
>17. <A
HREF="bindingsintro.html"
>Introduction to native bindings</A
></DT
><DT
>18. <A
HREF="mysql.html"
>MySQL bindings</A
></DT
><DD
><DL
><DT
><A
HREF="mysql.html#AEN530"
>The MYSQL API</A
></DT
><DT
><A
HREF="x555.htm"
>Building programs with MySQL</A
></DT
></DL
></DD
><DT
>19. <A
HREF="postgres.html"
>Postgres bindings</A
></DT
></DL
></DD
><DT
>A. <A
HREF="a562.htm"
>Frequently asked questions</A
></DT
><DD
><DL
><DT
><A
HREF="a562.htm#AEN565"
>Q: How to handle strings in where clauses</A
></DT
><DT
><A
HREF="x573.htm"
>Q: How to handle connection failures</A
></DT
></DL
></DD
><DT
>B. <A
HREF="a580.htm"
>The GNU.DB Packages</A
></DT
><DD
><DL
><DT
><A
HREF="a580.htm#AEN582"
>GNU.DB.ESQL_Support</A
></DT
><DD
><DL
><DT
><A
HREF="a580.htm#AEN585"
>String related type conversion</A
></DT
><DT
><A
HREF="a580.htm#AEN589"
>SQL Communication Area</A
></DT
><DT
><A
HREF="a580.htm#AEN596"
>Exceptions</A
></DT
></DL
></DD
><DT
><A
HREF="x602.htm"
>ODBC related packages</A
></DT
></DL
></DD
><DT
>C. <A
HREF="a606.htm"
>Porting legacy code</A
></DT
><DD
><DL
><DT
><A
HREF="a606.htm#AEN609"
>Migrating from Oracle to GNADE</A
></DT
><DD
><DL
><DT
><A
HREF="a606.htm#AEN612"
>Host variables</A
></DT
><DT
><A
HREF="a606.htm#AEN615"
>Query Results</A
></DT
><DT
><A
HREF="a606.htm#AEN618"
>Others</A
></DT
></DL
></DD
></DL
></DD
><DT
>D. <A
HREF="a622.htm"
>GNU Free Documentation License</A
></DT
><DD
><DL
><DT
>0. <A
HREF="a622.htm#AEN627"
>PREAMBLE</A
></DT
><DT
>1. <A
HREF="x632.htm"
>APPLICABILITY AND DEFINITIONS</A
></DT
><DT
>2. <A
HREF="x642.htm"
>VERBATIM COPYING</A
></DT
><DT
>3. <A
HREF="x646.htm"
>COPYING IN QUANTITY</A
></DT
><DT
>4. <A
HREF="x652.htm"
>MODIFICATIONS</A
></DT
><DT
>5. <A
HREF="x688.htm"
>COMBINING DOCUMENTS</A
></DT
><DT
>6. <A
HREF="x693.htm"
>COLLECTIONS OF DOCUMENTS</A
></DT
><DT
>7. <A
HREF="x697.htm"
>AGGREGATION WITH INDEPENDENT WORKS</A
></DT
><DT
>8. <A
HREF="x701.htm"
>TRANSLATION</A
></DT
><DT
>9. <A
HREF="x704.htm"
>TERMINATION</A
></DT
><DT
>10. <A
HREF="x707.htm"
>FUTURE REVISIONS OF THIS LICENSE</A
></DT
></DL
></DD
><DT
>E. <A
HREF="a712.htm"
>GNU Public License (GPL) Version 2</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Tables</B
></DT
><DT
>4-1. <A
HREF="platfforms.html#AEN70"
>Supported Platforms</A
></DT
><DT
>7-1. <A
HREF="gnadeparts.html#AEN205"
>Production results of the GNADE Project</A
></DT
><DT
>11-1. <A
HREF="x281.htm#AEN287"
>Exception Actions</A
></DT
><DT
>12-1. <A
HREF="x385.htm#AEN402"
>Options</A
></DT
></DL
></DIV
><DIV
CLASS="LOT"
><DL
CLASS="LOT"
><DT
><B
>List of Examples</B
></DT
><DT
>6-1. <A
HREF="x173.htm#AEN177"
>/etc/odbc.ini entry for the test data base</A
></DT
><DT
>10-1. <A
HREF="esqlintro.html#AEN245"
>Example for Embedded SQL</A
></DT
><DT
>11-1. <A
HREF="x255.htm#AEN259"
>Embedded SQL Statements</A
></DT
><DT
>11-2. <A
HREF="x308.htm#AEN312"
>Local SQLCA in procedures</A
></DT
><DT
>11-3. <A
HREF="x320.htm#AEN324"
>Using DB connections as procedure arguments</A
></DT
><DT
>11-4. <A
HREF="x331.htm#AEN336"
>Local Cursors</A
></DT
><DT
>11-5. <A
HREF="x342.htm#AEN347"
>Accessing ODBC handles</A
></DT
><DT
>11-6. <A
HREF="x350.htm#AEN361"
>Using dynamic SQL</A
></DT
><DT
>11-7. <A
HREF="x364.htm#AEN371"
>Using VARCHAR</A
></DT
><DT
>14-1. <A
HREF="x456.htm#AEN459"
>Preparing data of the ODBC driver</A
></DT
><DT
>14-2. <A
HREF="x456.htm#AEN463"
>Connecting to the data base via ODBC</A
></DT
><DT
>14-3. <A
HREF="x456.htm#AEN469"
>Preparing the Query via ODBC</A
></DT
><DT
>14-4. <A
HREF="x456.htm#AEN472"
>Using host variable with ODBC</A
></DT
><DT
>14-5. <A
HREF="x456.htm#AEN477"
>Creating the result set for a query</A
></DT
><DT
>14-6. <A
HREF="x456.htm#AEN481"
>Fetching data of the result set via ODBC</A
></DT
><DT
>18-1. <A
HREF="mysql.html#AEN536"
>MySQL native binding - Connecting to the database.</A
></DT
><DT
>18-2. <A
HREF="mysql.html#AEN541"
>MySQL native binding - Executing a query</A
></DT
><DT
>18-3. <A
HREF="mysql.html#AEN546"
>MySQL native binding - Accessing the result set</A
></DT
><DT
>18-4. <A
HREF="mysql.html#AEN552"
>MySQL native binding - Dropping the query</A
></DT
><DT
>A-1. <A
HREF="a562.htm#AEN569"
>Using a string in the WHERE clause</A
></DT
><DT
>A-2. <A
HREF="x573.htm#AEN576"
>Intercpetion connection errors</A
></DT
></DL
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="ch00.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Preface</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>