FairCom Direct SQL for C and C++

Tutorial 4: Transaction Processing

<faircomInstallFolder>\drivers\c.sql.direct\tutorials\DSQL_tutorial4.c

This tutorial code performs the following:

1. Logon onto a session
2. Create 4 tables each with an index
3. Add records in multiple tables under transaction processing control
4. Display the contents of the tables

Transaction processing provides a method by which multiple related database operations that are spread across separate tables/files are guaranteed to succeed or none of the operations succeed. This ensures the integrity of the data in related tables/files.

To keep this tutorial simple, we use four procedures: Initialize(), Define(), Manage(), and You’re Done()!

• Initialize() - Connects to the FairCom Database Engine.
• Define() - Defines and creates our four tables/files.
• Manage() - Adds rows/records to multiple tables/files under transaction control.
• Done() - Disconnects from FairCom Database Engine.

Note our simple Main() function:

/*

* main()

*

* The main() function implements the concept of "init, define, manage

* and you're done..."

*/

int main(int argc, char* argv[])

{

Initialize();

Define();

Manage();

Done();

printf("\nPress <ENTER> key to exit . . .\n");

getchar();

return(0);

}

We suggest opening the source code with your own editor.

Continue now to review these four steps.

In This Section Init Define Manage Done