Remote Data Connectivity

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()
• rdo_close()
• 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()