Equivalence des Application Programm Interfaces propriétaires pour les bases de données relationnelles

Initialiser l'environnement

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLAllocHandle SQLGetEnvAttr SQLSetEnvAttr	SQLDBC::Environment SQLDBC::GetClientRunTime	mysql_library_init mysql_thread_safe	SQLAllocHandle SQLGetEnvAttr SQLSetEnvAttr	OCIEnvNlsCreate	-	SQLAllocHandle SQLGetEnvAttr SQLSetEnvAttr

Terminer l'environnement

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLFreeHandle	-	mysql_library_end	SQLFreeHandle	OCIHandleFree	-	SQLFreeHandle

Se connecter à la base de données

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLAllocHandle SQLConnect SQLGetConnectAttr SQLSetConnectAttr	SQLDBC::Connection::connect SQLDBC::Environment::createConnection SQLDBC::Connection::setAutoCommit SQLDBC::Connection::setSQLMode	mysql_autocommit mysql_init mysql_options mysql_real_connect mysql_set_character_set	SQLAllocHandle SQLConnect SQLGetConnectAttr SQLSetConnectAttr	OCILogon2	PQsetClientEncoding PQsetdbLogin	SQLAllocHandle SQLConnect SQLGetConnectAttr SQLSetConnectAttr

Se déconnecter de la base de données

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLDisconnect SQLFreeHandle	SQLDBC::Environment::releaseConnection	mysql_close	SQLDisconnect SQLFreeHandle	OCILogoff	PQfinish	SQLDisconnect SQLFreeHandle

Attacher une tâche

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
-	-	mysql_thread_init	OCITransStart	-	-	-

Détacher une tâche

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
-	-	mysql_thread_end	OCITransDetach	-	-	-

Préparer un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLAllocHandle SQLGetStmtAttr SQLPrepare SQLSetStmtAttr	SQLDBC::Connection::createPreparedStatement SQLDBC::Connection::createStatement SQLDBC::PreparedStatement::prepare SQLDBC::PreparedStatement::setBatchSize SQLDBC::PreparedStatement::setResultSetType SQLDBC::PreparedStatement::setResultSetConcurrencyType SQLDBC::Statement::setBatchSize SQLDBC::Statement::setResultSetType SQLDBC::Statement::setResultSetConcurrencyType	mysql_stmt_attr_get mysql_stmt_attr_set mysql_stmt_init mysql_stmt_prepare	SQLAllocHandle SQLGetStmtAttr SQLPrepare SQLSetStmtAttr	OCIAttGet OCIAttSet OCIStmtPrepare	PQprepare	SQLAllocHandle SQLGetStmtAttr SQLPrepare SQLSetStmtAttr

Lier les paramètres d'un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLBindParameter	SQLDBC::PreparedStatement::BindParameter SQLDBC::Statement::BindParameter	mysql_stmt_bind_param	SQLBindParameter	OCIAttGet OCIAttSet OCIBindByPos	PQexecPrepared PQprepare	SQLBindParameter

Lier les résultats d'un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLBindCol	SQLDBC::PreparedStatement::BindColumn SQLDBC::Statement::BindColumn	mysql_stmt_bind_result	SQLBindCol	OCIAttGet OCIAttSet OCIDefineByPos	-	SQLBindCol

Exécuter un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLExecDirect SQLExecute SQLRowCount	SQLDBC::PreparedStatement::execute SQLDBC::PreparedStatement::getRowsAffected SQLDBC::Statement::execute SQLDBC::Statement::getRowsAffected	mysql_stmt_affected_rows mysql_query mysql_stmt_execute	SQLExecDirect SQLExecute SQLRowCount	OCIAttGet OCIAttSet OCIStmtExecute	PQexec PQexecPrepared PQntuples	SQLExecDirect SQLExecute SQLRowCount

Lire le résultat d'un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLFetch	SQLDBC::PreparedStatement::getResultCount SQLDBC::PreparedStatement::next SQLDBC::Statement::getResultCount SQLDBC::Statement::next	mysql_stmt_fetch	SQLFetch	OCIAttGet OCIAttSet OCIStmtFetch2	PQgetisnull PQgetlength PQgetvalue	SQLFetch

Gérer les types de données longues

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLGetData SQLParamData SQLPutData	SQLDBC::ResultSet::getObject SQLDBC::SQLDBC_LOB::close SQLDBC::SQLDBC_LOB::getData SQLDBC::SQLDBC_LOB::putData	mysql_stmt_fetch_column mysql_stmt_send_long_data	SQLGetData SQLParamData SQLPutData	OCILobClose OCILobOpen OCILobRead2 OCILobWrite2	lo_create lo_close lo_lseek lo_open lo_read lo_unlink lo_write	SQLGetData SQLParamData SQLPutData

Réinitialiser un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLCloseCursor	-	mysql_stmt_free_result mysql_stmt_reset	SQLCloseCursor	-	-	SQLCloseCursor

Libérer un ordre Sql

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLFreeHandle SQLFreeStmt	SQLDBC::Connection::releaseStatement	mysql_stmt_close	SQLFreeHandle SQLFreeStmt	OCIHandleFree	PQclear	SQLFreeHandle SQLFreeStmt

Valider ou invalider une transaction

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLEndTran	SQLDBC::Connection::commit SQLDBC::Connection::rollback	mysql_commit mysql_rollback	SQLEndTran	OCITransCommit OCITransForger OCITransPrepare OCITransRollback	PQexec	SQLEndTran

Lire un code retour ou un message d'erreur

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
SQLGetDiagRec SQLMoreResults	SQLDBC::Connection::clearError SQLDBC::Connection::error SQLDBC::ErrorHndl::getErrorCode SQLDBC::ErrorHndl::getErrorText SQLDBC::PreparedStatement::clearError SQLDBC::PreparedStatement::error SQLDBC::Statement::clearError SQLDBC::Statement::error	mysql_errno mysql_error mysql_stmt_errno mysql_stmt_error	SQLGetDiagRec SQLMoreResults	OCIErrorGet	PQerrorMessage PQresultErrorMessage PQstatus	SQLGetDiagRec SQLMoreResults

Dictionnaire

Db2	Max DB	My Sql	Odbc	Oracle	PostgreSQL	Sql Server
COLUMNS INDEXES INDEXCOLUSE KEYCOLUSE REFERENCES ROUTINES ROUTINEPARMS SCHEMATA TABLES	DBPROCEDURES DBPROCPARAMS COLUMNS CONSTRAINTCOLUMNS FOREIGNKEYCOLUMNS FUNCTIONS INDEXCOLUMNS SCHEMAS TABLES	COLUMNS KEY_COLUMN_USAGE ROUTINES SCHEMATA STATISTICS TABLE_CONSTRAINTS TABLES	SQLColumns SQLForeignKeys SQLPrimaryKeys SQLProcedureColumns SQLProcedures SQLStatistics SQLTables	ALL_ARGUMENTS ALL_CONSTRAINTS ALL_CONS_COLUMNS ALL_INDEXES ALL_IND_COLUMNS ALL_PROCEDURES ALL_SYNONYMS ALL_TABLES ALL_TAB_COLUMNS ALL_TAB_COMMENTS ALL_VIEWS USER_TABLESPACES	pg_attribute pg_class pg_constraint pg_description pg_index pg_namespace pg_proc pg_type pg_user	all_objects columns foreign_key_columns foreign_keys index_columns indexes parameters synonyms tables views