Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Embedded SQL

Building NetWare Loadable Modules Next Page

Sample embedded SQL programs

Sample embedded SQL programs are included with the SQL Anywhere installation. They are placed in the samples-dir\SQLAnywhere\C directory. For Windows CE, an additional example is located in the samples-dir\SQLAnywhere\CE\esql_sample directory.

To reduce the amount of code that is duplicated by the sample programs, the mainlines and the data printing functions have been placed into a separate file. This is mainch.c for character mode systems and mainwin.c for windowing environments.

The sample programs each supply the following three routines, which are called from the mainlines:

The function of the mainline is to:

  1. Call the WSQLEX_Init routine

  2. Loop, getting commands from the user and calling WSQL_Process_Command until the user quits

  3. Call the WSQLEX_Finish routine

Connecting to the database is accomplished with the embedded SQL CONNECT command supplying the appropriate user ID and password.

In addition to these samples, you may find other programs and source files as part of SQL Anywhere that demonstrate features available for particular platforms.

Building the sample programs
Running the sample programs
Static cursor sample
Dynamic cursor sample