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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere embedded SQL


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 Mobile, an additional example is located in the samples-dir\SQLAnywhere\CE\esql_sample directory.

  • The static cursor embedded SQL example, cur.sqc, demonstrates the use of static SQL statements.
  • The dynamic cursor embedded SQL example, dcur.sqc, demonstrates the use of dynamic SQL statements.

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:

  • WSQLEX_Init   Connects to the database and opens the cursor.

  • WSQLEX_Process_Command   Processes commands from the user, manipulating the cursor as necessary.

  • WSQLEX_Finish   Closes the cursor and disconnects from the database.

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 statement 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