Re: C library for dynamic SQL

Partha Dutta wrote: > Rune Nilsen <rune@yes.no> wrote in article <32941965.7B69@yes.no>... > > I am porting some code from Illustra to Informix. > > Is there a C library out there which allows me to > > process random SQL queries and process the result, > > more like how the Illustra API works? > > In Informix ESQL/C, there are library calls to process these SQL queries. > Use the PREPARE and DESCRIBE calls to get more information about the query. Well, I'd hoped not to have to dig into structures to find out what kind of data was passed both ways. What i'd like is an API more like this: result = exec_sql( connection, "any type of sql query;" ); if( num_rows( result ) ) { while( (row = get_row( result )) != NULL ) { printf( "Col 1: %s\\n", row[0] ); printf( "Col 2: %s\\n", row[1] ); } } Does anyone know of something like this freely available? If not, I'll just have to make it, I guess...