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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » Embedded SQL


Sample embedded SQL programs

Sample embedded SQL programs are included with the SQL Anywhere installation. They are placed in the %SQLANYSAMP16%\SQLAnywhere\C directory. For Windows Mobile, an additional example is located in the \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 done 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.

Static cursor sample
Running the static cursor sample program
Dynamic cursor sample
Running the dynamic cursor sample program