Re: SQL Statements embedded in RPG

On Thu, 17 Feb 2000, David Morris wrote:

> start fetching records.  The implementation of SQL is hidden.

Does anyone know if something like the following is possible (using
subprocedures or even linking to a C program, I'm using C syntax here -
the goal is to make the SQL API on the 400 similar to the API of other
database engines):

int err;
char database[] = "my_db";
char query_string[100] = "select field1,field2 from table";
char *result;

err = sql_open(sql_handle);
if (err)
        /* handle the error */

err = sql_select_database (sql_handle, database_name);
if (err)
        /* you know what to do */

err = sql_query (sql_handle, query_string);
if (err)
        /* this is an error */

err = sql_fetch_rows (sql_handle, result);


Now at this point all the rows that match the select statement are stored
in the result array.  What I see as the advantage here is that the query
string is not hard coded anywhere (well, in my example it is but it could
be passed as a parameter).  Could the AS/400 SQL API be wrapped in
functions that would allow this?  Does the AS/400 have an SQL API that can
be used in C programs?  I have looked on the AS/400 documentation site and
I haven't found anything.  Pointers to the relevant info would be much
appreciated.

James Rich
james@dansfoods.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---