Understanding Database Communication Steps

Several APIs called in succession can perform these steps for database communication:

• Initialize communication with the database.

• Establish a connection to the specific data to access.

• Execute statements on the database.

• Release the connection to the database.

• Terminate communication with the database.

This table lists some of the API levels and the communication handles and API names that are associated with them:

API Level	Communication Handles	API Name
Control level (application or test driver)	Environment handle	JDB_InitEnv
Control level (application or test driver)	User handle (created)	JDB_InitUser
Request level (business function)	User handle (retrieved)	JDB_InitBhvr
Request level (business function)	Request handle	JDB_OpenTable
Request level (business function)	Request handle	JDB_FetchKeyed()
Request level (business function)	Request handle	JDB_CloseTable
Request level (business function)	User handle	JDB_FreeBhvr
Control level (application or test driver)	User handle	JDB_FreeUser
Control level (application or test driver)	Environment handle	JDB_FreeEnv