Difference between revisions of "Remote Data Connectivity"

Revision as of 10:24, 28 July 2010

Remote Data Connectivity

Overview of Remote Data Connectivity Functions

• sqlcancel() - request that an executing SQL statement be cancelled
• sqlcolumns() - store column information to a cursor
• sqlcommit() - commit a transaction
• sqlconnect() - connect to a data source
• sqldisconnect() - disconnect from a data source
• sqlexec() - send an SQL statement to a data source
• sqlgetprop() - query property settings for a connection or the environment
• sqlmoreresult() - check if more results sets are available and if so, copy next results set to a cursor
• sqlprepare() - prepare an SQL statement that will be executed by the SQLEXEC() function
• sqlrollback() - rollback a transaction
• sqlsetprop() - set property settings for a connection
• sqlstringconnect() - connect to a data source using a gateway connection string
• sqltables() - store data source table names to a table

Overview of Recital Data Objects (RDO)

• rdo_affected_rows() - return the number of rows affected by the last operation
• rdo_close() - close a data source opened with rdo_connect()
• rdo_connect() -
• rdo_data_seek() -
• rdo_errno() -
• rdo_error() -
• rdo_exec() -
• rdo_fetch_array() -
• rdo_fetch_assoc() -
• rdo_fetch_field() -
• rdo_fetch_lengths() -
• rdo_fetch_object() -
• rdo_fetch_row() -
• rdo_field_flags() -
• rdo_field_len() -
• rdo_field_name() -
• rdo_field_seek() -
• rdo_field_table() -
• rdo_field_type() -
• rdo_free_object() -
• rdo_free_result() -
• rdo_get_client_info() -
• rdo_get_host_info() -
• rdo_info() -
• rdo_list_dbs() -
• rdo_num_fields() -
• rdo_num_rows() -
• rdo_ping() -
• rdo_query() -
• rdo_real_escape_string() -
• rdo_result() -
• rdo_select_db() -
• rdo_stat() -
• rdo_thread_id() -
• rdo_unbuffered_query() -

Using Recital Client/Server

Using Recital with MySQL

Using Recital with PostgreSQL

Using Recital with Oracle

Using Recital with DB2