Sample Embedded SQL Programs

Sample embedded SQL programs are included with the SAP Sybase IQ installation. They are placed in the %ALLUSERSPROFILE%\SybaseIQ\samples\SQLAnywhere\C 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 SAP Sybase IQ that demonstrate features available for particular platforms.

• Static Cursor Sample
  This example demonstrates the use of cursors. The particular cursor used here retrieves certain information from the Employees table in the sample database. The cursor is declared statically, meaning that the actual SQL statement to retrieve the information is hard coded into the source program. This is a good starting point for learning how cursors work. The Dynamic Cursor sample takes this first example and converts it to use dynamic SQL statements.
• Running the Static Cursor Sample Program
  Run the static cursor sample program.
• Dynamic Cursor Sample
  This sample demonstrates the use of cursors for a dynamic SQL SELECT statement.
• Running the Dynamic Cursor Sample Program
  Run the dynamic cursor sample program.