Difference between revisions of "Remote Data Connectivity"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Overview of Recital Data Objects (RDO)) |
Yvonnemilne (Talk | contribs) (→Overview of Remote Data Connectivity Functions) |
||
| Line 1: | Line 1: | ||
==Remote Data Connectivity== | ==Remote Data Connectivity== | ||
===Overview of Remote Data Connectivity Functions=== | ===Overview of Remote Data Connectivity Functions=== | ||
| − | * [[SQLCANCEL()|sqlcancel()]] | + | * [[SQLCANCEL()|sqlcancel()]] - request that an executing SQL statement be cancelled |
| − | * [[SQLCOLUMNS()|sqlcolumns()]] | + | * [[SQLCOLUMNS()|sqlcolumns()]] - store column information to a cursor |
| − | * [[SQLCOMMIT()|sqlcommit()]] | + | * [[SQLCOMMIT()|sqlcommit()]] - commit a transaction |
| − | * [[SQLCONNECT()|sqlconnect()]] | + | * [[SQLCONNECT()|sqlconnect()]] - connect to a data source |
| − | * [[SQLDISCONNECT()|sqldisconnect()]] | + | * [[SQLDISCONNECT()|sqldisconnect()]] - disconnect from a data source |
| − | * [[SQLEXEC()|sqlexec()]] | + | * [[SQLEXEC()|sqlexec()]] - send an SQL statement to a data source |
| − | * [[SQLGETPROP()|sqlgetprop()]] | + | * [[SQLGETPROP()|sqlgetprop()]] - query property settings for a connection or the environment |
| − | * [[SQLMORERESULTS()|sqlmoreresult()]] | + | * [[SQLMORERESULTS()|sqlmoreresult()]] - check if more results sets are available and if so, copy next results set to a cursor |
| − | * [[SQLPREPARE()|sqlprepare()]] | + | * [[SQLPREPARE()|sqlprepare()]] - prepare an SQL statement that will be executed by the SQLEXEC() function |
| − | * [[SQLROLLBACK()|sqlrollback()]] | + | * [[SQLROLLBACK()|sqlrollback()]] - rollback a transaction |
| − | * [[SQLSETPROP()|sqlsetprop()]] | + | * [[SQLSETPROP()|sqlsetprop()]] - set property settings for a connection |
| − | * [[SQLSTRINGCONNECT()|sqlstringconnect()]] | + | * [[SQLSTRINGCONNECT()|sqlstringconnect()]] - connect to a data source using a gateway connection string |
| − | * [[SQLTABLES()|sqltables()]] | + | * [[SQLTABLES()|sqltables()]] - store data source table names to a table |
===Overview of Recital Data Objects (RDO) === | ===Overview of Recital Data Objects (RDO) === | ||
Revision as of 09:51, 28 July 2010
Contents
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()
