f90SQL - List of Procedures

ODBC API Functions Supported by f90SQL

Connecting to data source

Function	Confor- mance	Purpose
f90SQLAllocHandle	ISO 92	Obtains environment, connection, statement, or descriptor handles
f90SQLConnect	ISO 92	Connects to a specific driver by data source name, user ID, and password.
f90SQLDriverConnect	ODBC	Connects to a specific driver using a connection string, or requests that the Driver Manager and driver display connection dialog boxes for the user.
f90SQLBrowseConnect	ODBC	Returns successive levels of connection attributes and valid attribute values, and connects to the data source when all connection attributes have been specified.

Obtaining information about a drivers and data sources

Function	Confor- mance	Purpose
f90SQLDataSources	ISO 92	Returns a list of available data sources.
f90SQLDrivers	ODBC	Returns a list of installed drivers and their attributes.
f90SQLGetInfo	ISO 92	Returns information about a specific driver and data source.
f90SQLGetFunctions	ISO 92	Returns supported driver functions.
f90SQLGetTypeInfo	ISO 92	Returns information about supported data types.

Setting and retrieving driver attributes

Function	Confor- mance	Purpose
f90SQLSetConnectAttr f90SQLGetConnectAttr	ISO 92	Sets and retrieves connection attributes.
f90SQLSetEnvAttr f90SQLGetEnvAttr	ISO 92	Sets and retrieves environment attributes.
f90SQLSetStmtAttr f90SQLGetStmtAttr	ISO 92	Sets and retrieves statement attributes.

Setting and retrieving descriptor fields

Function	Confor- mance	Purpose
f90SQLGetDescField f90SQLSetDescField	ISO 92	Returns and sets the value of a single descriptor field.
f90SQLGetDescRec f90SQLSetDescRec	ISO 92	Returns and sets the values of multiple descriptor fields.

Preparing SQL requests

Function	Confor- mance	Purpose
f90SQLPrepare	ISO 92	Prepares a SQL statement for later execution.
f90SQLBindParameter	ODBC	Assigns storage for parameters in a SQL statement.
f90SQLGetCursorName	ISO 92	Returns the cursor name associated with a statement handle.
f90SQLSetCursorName	ISO 92	Specifies a cursor name.

Terminating statements and closing connections

Function	Confor- mance	Purpose
f90SQLFreeStmt	ISO 92	Ends a statement and frees resources associated with the statement.
f90SQLCloseCursor	ISO 92	Closes a cursor.
f90SQLCancel	ISO 92	Cancels an SQL statement.
f90SQLEndTran	ISO 92	Commits or rolls back a transaction.
f90SQLDisconnect	ISO 92	Closes the connection.
f90SQLFreeHandle	ISO 92	Releases environment, connection, statement, or descriptor handles

Retrieving results and information about results

Function	Confor- mance	Purpose
f90SQLRowCount	ISO 92	Returns the number of rows affected by a SQL statement.
f90SQLNumResultCols	ISO 92	Returns the number of columns in the result set.
f90SQLDescribeCol	ISO 92	Describes the columns in the result set.
f90SQLColAttribute	ISO 92	Describes attributes of columns in a result set.
f90SQLBindCol	ISO 92	Assigns storage and specifies the data type of a result column.
f90SQLFetch	ISO 92	Returns multiple result rows.
f90SQLFetchScroll	ISO 92	Returns scrollable result rows.
f90SQLGetData	ISO 92	Returns part or all of one column of one row of a result set (useful for long data values).
f90SQLSetPos	ODBC	Positions a cursor within a fetched block of data, and allows an application to refresh data in the rowset, or update or delete data in the result set.
f90SQLBulkOperations	ODBC	Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.
f90SQLMoreResults	ODBC	Determines whether there are more result sets available and, if so, initializes processing for the next result set.
f90SQLGetDiagField f90SQLGetDiagRec	ISO 92	Returns additional diagnostic information (single and multiple fields of the diagnostic data structure).

Catalog functions

Function	Confor- mance	Purpose
f90SQLColumnPrivileges	ODBC	Returns a list of columns and associated privileges for one or more tables.
f90SQLColumns	X/Open	Returns a list of column names in specified tables.
f90SQLForeignKeys	ODBC	Returns a list of column names that make up foreign keys.
f90SQLPrimaryKeys	ODBC	Returns the list of column names that make up a table's primary key.
f90SQLProcedureColumns	ODBC	Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures.
f90SQLProcedures	ODBC	Returns the list of procedure names stored in a data source.
f90SQLSpecialColumns	X/Open	Returns information about the optimal set of columns that uniquely identifies a row in a specified table, or the columns that are automatically updated when any value in the row is updated by a transaction.
f90SQLStatistics	ISO 92	Returns statistics about a single table and the list of indexes associated with the table.
f90SQLTablePrivileges	ODBC	Returns a list of tables and the privileges associated with each table.
f90SQLTables	X/Open	Returns a list of table names stored in a data source.

In addition to the previous functions, f90SQL provides utility functions, constant definitions, and Fortran data structures that facilitate the use of ODBC from your Fortran applications. All f90SQL functions receive and return arguments according to the common Fortran convention.

More Information

f90SQL Online Manual

List of ODBC Drivers