ASA Programming Guide
Embedded SQL Programming
Sample embedded SQL programs are included with the Adaptive Server Anywhere installation. They are placed in the Samples\ASA\C subdirectory of your SQL Anywhere directory.
The static cursor embedded SQL example, Samples\ASA\C\cur.sqc, demonstrates the use of static SQL statements.
The dynamic cursor embedded SQL example, Samples\ASA\C\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 disconnect from the database.
The function of the mainline is to:
Call the WSQLEX_Init routine
Loop, getting commands from the user and calling WSQL_Process_Command until the user quits
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 Studio which demonstrate features available for particular platforms.
Building the sample programs
Running the sample programs
Static cursor sample
Dynamic cursor sample
Service examples