This program demonstrates calling OpenAPI asynchronously, using callback functions for notification of OpenAPI call completion and the processing of database events using OpenAPI. The program consist of four modules: a main control module (apiademo.c), a server module (apiasvr.c), a client module (apiaclnt.c) and a utility module (apiautil.c).

The server module establishes a connection to the target database, creates a database event and registers to receive event notification. The server then waits for database events to be received. The client module establishes it's own database connection, raises a series of database events and terminates. The server terminates when a database event is received indicating that termination has been requested.

The main control module processes the command line arguments and initializes, runs and terminates the client and server modules. The utility module provides common synchronous OpenAPI calls used during initialization and termination.

The program can be run as a client, a server or both. Multiple clients and multiple servers may be run concurrently.

The server demo establishes a connection with the target database, creates and registers a database event and waits to receive event notifications. Server execution is implemented in a single processing function with a set of actions. Each action represents a state in a finite state machine.

The client demo establishes a connection with the target database and raises database events at (somewhat) random intervals. Client execution is implemented as a series of callback functions. Each asynchronous OpenAPI request specifies the next sequential function as its callback. Each function represents a state in a simple finite state machine as follows:

• PAUSE Pause some number of seconds.
• RAISE Call IIapi_query() to raise a database event.
• INFO Call IIapi_getQueryInfo() to check raise event status.
• CLOSE Call IIapi_close() to close request statement handle.
• DONE Check if all events raised (done) or continue with PAUSE.

This module provides routine to perform common API calls synchronously.

The following functions are provided:

• IIdemo_conn() Call IIapi_connect().
• IIdemo_disconn() Call IIapi_disconnect().
• IIdemo_abort() Call IIapi_abort().
• IIdemo_autocommit() Call IIapi_autocommit().
• IIdemo_query() Call IIapi_{query, getQueryInfo, close}().
• IIdemo_checkError() Print API call status and error information.

First part of the two phase commit demo. Begin a distributed transaction and exit without disconnecting. Run apis2ph2 to finish processing of distributed transaction.

Following actions are demonstrated in the main()

• Register distributed transaction ID.
• Prepare distributed transaction to be committed.

Second part of two phase commit demo. Run apis2ph1 to begin distributed transaction. Reconnects to distribute transaction and rolls back the transaction.

Following actions are demonstrated in the main()

• Register distributed transaction ID.
• Establish connection with distributed transaction.
• Rollback distributed transaction.
• Release distributed transaction ID.

Following actions are demonstrate in the main()

• • Enable autocommit
  • Disable autocommit

SELECT row with blob data.

Following actions are demonstrated in the main()

• Set EnvParam for segment length
• Issue query
• Get query result descriptors
• Get query results
• Close query processing
• Free query resources.

Following actions are demonstrated in the main()

• Open cursor
• Position cursor on row
• Issue cursor delete statement
• Describe parameters
• Send parameter values
• Get delete statement results
• Free delete statement resources
• Get cursor results
• Free cursor resources

Following actions are demonstrated in the main()

• Commit transaction

Following actions are demonstrate in the main()

• Connect (no conn parms)
• Disconnect
• Set Connection Parameters
• Connect (with conn parms)
• Abort Connection

Following actions are demonstrated in the main()

• Copy data from program into table.
• Copy data into program from table.

Following actions are demonstrated in the main()

• Open cursor
• Position cursor on row
• Issue cursor update statement
• Describe parameters
• Send parameter values
• Get update statement results
• Free update statement resources
• Get cursor results
• Free cursor resources

Following actions are demonstrated in the main()

• Set environment parameter
• Convert string to DATE using environment date format.
• Convert DATE to string using installation date format.

handler function for handling OpenAPI errors returned to the application. Additionally please refer to the OpenAPI documentation, section "Generic Parameters" to understand the meaning of each of IIAPI_ST_* error codes returned in "gp_status" o/p parameter of IIAPI_GENPARM structure.

Demonstrates using IIapi_getQueryInfo() and IIapi_getErrorInfo().

Following actions are demonstrated in the main()

• Check status of statement with no rows.
• Check status of insert statement.
• Check status of invalid statement.

Following actions are demonstrate in the main()

• Initialize at level 1
• Terminate API
• Initialize at level 2
• Set environment parameter
• Release environmment resources
• Terminate API

Following actions are demonstrate in the main()

• Connect to local Name Server
• Enable Autocommit
• Query connection info
• Disable autocommit

Following actions are demonstrated in the main()

• Create procedure
• Execute procedure
• Retrieve BYREF parameter results
• Get procedure results

Following actions are demonstrated in the main()

• Create procedure
• Execute procedure

Following actions are demonstrated in the main()

• Create procedure
• Execute procedure

Following actions are demonstrated in the main()

• Create procedure
• Execute procedure
• Retrieve result rows
• Get procedure results

Following actions are demonstrated in the main()

• Define repeated insert.
• Execute repeated insert.

Following actions are demonstrated in the main()

• Create savepoint
• Rollback to savepoint
• Rollback transaction.

Scroll and position in a result set.

Following actions are demonstrated in the main()

• Issue query
• Get query result descriptors
• Scroll/position cursor
• Get query results
• Free query resources

SELECT data using a cursor.

Following actions are demonstrated in the main()

• Issue query
• Get query result descriptors
• Get query results
• Cancel query processing
• Free query resources.

SELECT data using a select loop.

Following actions are demonstrated in the main()

• Issue query
• Get query result descriptors
• Get query results
• Cancel query processing
• Free query resources.