View source for Remote Data Connectivity

==Remote Data Connectivity==
===Overview of Remote Data Connectivity Functions===
* [[SQLCANCEL()|sqlcancel()]] - request that an executing SQL statement be cancelled 
* [[SQLCOLUMNS()|sqlcolumns()]] - store column information to a cursor 
* [[SQLCOMMIT()|sqlcommit()]] - commit a transaction 
* [[SQLCONNECT()|sqlconnect()]] - connect to a data source
* [[SQLDISCONNECT()|sqldisconnect()]] - disconnect from a data source 
* [[SQLEXEC()|sqlexec()]] - send an SQL statement to a data source
* [[SQLGETPROP()|sqlgetprop()]] - query property settings for a connection or the environment 
* [[SQLMORERESULTS()|sqlmoreresult()]] - check if more results sets are available and if so, copy next results set to a cursor
* [[SQLPREPARE()|sqlprepare()]] - prepare an SQL statement that will be executed by the SQLEXEC() function 
* [[SQLROLLBACK()|sqlrollback()]] - rollback a transaction
* [[SQLSETPROP()|sqlsetprop()]] - set property settings for a connection 
* [[SQLSTRINGCONNECT()|sqlstringconnect()]] - connect to a data source using a gateway connection string
* [[SQLTABLES()|sqltables()]] - store data source table names to a table

===Overview of Recital Data Objects (RDO) ===
* [[RDO_AFFECTED_ROWS()|rdo_affected_rows()]] - return the number of rows affected by the last operation
* [[RDO_CLOSE()|rdo_close()]] - 
* [[RDO_CONNECT()|rdo_connect()]] - 
* [[RDO_DATA_SEEK()|rdo_data_seek()]] - 
* [[RDO_ERRNO()|rdo_errno()]] - 
* [[RDO_ERROR()|rdo_error()]] - 
* [[RDO_EXEC()|rdo_exec()]] - 
* [[RDO_FETCH_ARRAY()|rdo_fetch_array()]] - 
* [[RDO_FETCH_ASSOC()|rdo_fetch_assoc()]] - 
* [[RDO_FETCH_FIELD()|rdo_fetch_field()]] - 
* [[RDO_FETCH_LENGTHS()|rdo_fetch_lengths()]] - 
* [[RDO_FETCH_OBJECT()|rdo_fetch_object()]] - 
* [[RDO_FETCH_ROW()|rdo_fetch_row()]] - 
* [[RDO_FIELD_FLAGS()|rdo_field_flags()]] - 
* [[RDO_FIELD_LEN()|rdo_field_len()]] - 
* [[RDO_FIELD_NAME()|rdo_field_name()]] - 
* [[RDO_FIELD_SEEK()|rdo_field_seek()]] - 
* [[RDO_FIELD_TABLE()|rdo_field_table()]] - 
* [[RDO_FIELD_TYPE()|rdo_field_type()]] - 
* [[RDO_FREE_OBJECT()|rdo_free_object()]] - 
* [[RDO_FREE_RESULT()|rdo_free_result()]] - 
* [[RDO_GET_CLIENT_INFO()|rdo_get_client_info()]] - 
* [[RDO_GET_HOST_INFO()|rdo_get_host_info()]] - 
* [[RDO_INFO()|rdo_info()]] - 
* [[RDO_LIST_DBS()|rdo_list_dbs()]] - 
* [[RDO_NUM_FIELDS()|rdo_num_fields()]] - 
* [[RDO_NUM_ROWS()|rdo_num_rows()]] - 
* [[RDO_PING()|rdo_ping()]] - 
* [[RDO_QUERY()|rdo_query()]] - 
* [[RDO_REAL_ESCAPE_STRING()|rdo_real_escape_string()]] - 
* [[RDO_RESULT()|rdo_result()]] - 
* [[RDO_SELECT_DB()|rdo_select_db()]] - 
* [[RDO_STAT()|rdo_stat()]] - 
* [[RDO_THREAD_ID()|rdo_thread_id()]] - 
* [[RDO_UNBUFFERED_QUERY()|rdo_unbuffered_query()]] -

===Using Recital Client/Server ===
===Using Recital with MySQL===
===Using Recital with PostgreSQL===
===Using Recital with Oracle===
===Using Recital with DB2===