while ((row = mysql_fetch_row (res_set)) != NULL)

{

for (i = 0; i < mysql_num_fields (res_set); i++)

{

if (i > 0)fputc (`\t', stdout);

if( i == 0 || i== 1)printf ( %i , row[i]);

if( i == 2)printf ( %s , row[i]);

}

}

mysql_free_result (res_set);

}

}

On the other hand DB2 CLI provides a more comprehensive set of APIs for 

doing similar tasks. One of the essential parts of DB2 CLI is transaction 

processing, which is supported by all the tables in DB2 UDB. Figure 7 5 

shows the typical order of function calls of query processing.

 Chapter 7. Application porting 

205