SQL.CLI

Documentation

type SQLCHAR = CUChar

type SQLINTEGER = CLong

type SQLSMALLINT = CShort

type SQLDOUBLE = CDouble

type SQLFLOAT = CDouble

type SQLREAL = CFloat

type SQLPOINTER = Ptr ()

type SQLDATE = CUChar

type SQLTIME = CUChar

type SQLTIMESTAMP = CUChar

type SQLVARCHAR = CUChar

type SQLDECIMAL = CUChar

type SQLNUMERIC = CUChar

type SQLRETURN = SQLSMALLINT

type SQLHANDLE = SQLINTEGER

type SQLHENV = SQLHANDLE

type SQLHDBC = SQLHANDLE

type SQLHSTMT = SQLHANDLE

type SQLHDESC = SQLHANDLE

type SQLLEN = CLong

type SQLULEN = CULong

sql_null_data :: Num a => a

sql_data_at_exec :: Num a => a

sql_success :: SQLRETURN

sql_success_with_info :: SQLRETURN

sql_no_data :: SQLRETURN

sql_error :: SQLRETURN

sql_invalid_handle :: SQLRETURN

sql_need_data :: SQLRETURN

sql_succeeded :: SQLRETURN -> Bool

Test for sql_success or sql_success_with_info

sql_nts :: Num a => a

sql_ntsl :: Num a => a

sql_max_message_length :: Num a => a

maximum message lenth Vendors may increase this constant but its value must be at lieast 512

sql_max_id_length :: Num a => a

maximum identifier length

sql_date_len :: Num a => a

sql_time_len :: Num a => a

sql_timestamp_len :: Num a => a

sql_handle_env :: Num a => a

sql_handle_dbc :: Num a => a

sql_handle_stmt :: Num a => a

sql_handle_desc :: Num a => a

sql_attr_output_nts :: Num a => a

environment attribute

sql_attr_auto_ipd :: Num a => a

connection attribute

sql_attr_metadata_id :: Num a => a

connection and schema attributes

sql_attr_app_row_desc :: Num a => a

sql_attr_app_param_desc :: Num a => a

sql_attr_imp_row_desc :: Num a => a

sql_attr_imp_param_desc :: Num a => a

sql_attr_cursor_scrollable :: Num a => a

sql_attr_cursor_sensitivity :: Num a => a

sql_desc_count :: Num a => a

sql_desc_type :: Num a => a

sql_desc_length :: Num a => a

sql_desc_octet_length_ptr :: Num a => a

sql_desc_precision :: Num a => a

sql_desc_scale :: Num a => a

sql_desc_datetime_interval_code :: Num a => a

sql_desc_nullable :: Num a => a

sql_desc_indicator_ptr :: Num a => a

sql_desc_data_ptr :: Num a => a

sql_desc_name :: Num a => a

sql_desc_unnamed :: Num a => a

sql_desc_octet_length :: Num a => a

sql_desc_alloc_type :: Num a => a

sql_diag_returncode :: Num a => a

sql_diag_number :: Num a => a

sql_diag_row_count :: Num a => a

sql_diag_sqlstate :: Num a => a

sql_diag_native :: Num a => a

sql_diag_message_text :: Num a => a

sql_diag_dynamic_function :: Num a => a

sql_diag_class_origin :: Num a => a

sql_diag_subclass_origin :: Num a => a

sql_diag_connection_name :: Num a => a

sql_diag_server_name :: Num a => a

sql_diag_dynamic_function_code :: Num a => a

sql_diag_alter_table :: Num a => a

sql_diag_create_index :: Num a => a

sql_diag_create_table :: Num a => a

sql_diag_create_view :: Num a => a

sql_diag_delete_where :: Num a => a

sql_diag_drop_index :: Num a => a

sql_diag_drop_table :: Num a => a

sql_diag_drop_view :: Num a => a

sql_diag_dynamic_delete_cursor :: Num a => a

sql_diag_dynamic_update_cursor :: Num a => a

sql_diag_grant :: Num a => a

sql_diag_insert :: Num a => a

sql_diag_revoke :: Num a => a

sql_diag_select_cursor :: Num a => a

sql_diag_unknown_statement :: Num a => a

sql_diag_update_where :: Num a => a

sql_char :: Num a => a

sql_numeric :: Num a => a

sql_decimal :: Num a => a

sql_integer :: Num a => a

sql_smallint :: Num a => a

sql_float :: Num a => a

sql_real :: Num a => a

sql_double :: Num a => a

sql_datetime :: Num a => a

sql_varchar :: Num a => a

sql_type_date :: Num a => a

sql_type_time :: Num a => a

sql_type_timestamp :: Num a => a

sql_unspecified :: Num a => a

sql_insensitive :: Num a => a

sql_sensitive :: Num a => a

sql_all_types :: Num a => a

sql_default :: Num a => a

sql_ard_type :: Num a => a

sql_code_date :: Num a => a

sql_code_time :: Num a => a

sql_code_timestamp :: Num a => a

sql_false :: Num a => a

sql_true :: Num a => a

sql_no_nulls :: Num a => a

sql_nullable :: Num a => a

sql_nullable_unknown :: Num a => a

sql_pred_none :: Num a => a

sql_pred_char :: Num a => a

sql_pred_basic :: Num a => a

sql_named :: Num a => a

sql_unnamed :: Num a => a

sql_desc_alloc_auto :: Num a => a

sql_desc_alloc_user :: Num a => a

sql_close :: Num a => a

sql_drop :: Num a => a

sql_unbind :: Num a => a

sql_reset_params :: Num a => a

sql_fetch_next :: Num a => a

sql_fetch_first :: Num a => a

sql_fetch_last :: Num a => a

sql_fetch_prior :: Num a => a

sql_fetch_absolute :: Num a => a

sql_fetch_relative :: Num a => a

sql_commit :: Num a => a

sql_rollback :: Num a => a

sql_null_henv :: SQLHANDLE

sql_null_hdbc :: SQLHANDLE

sql_null_hstmt :: SQLHANDLE

sql_null_hdesc :: SQLHANDLE

sql_null_handle :: SQLHANDLE

sql_scope_currow :: Num a => a

sql_scope_transaction :: Num a => a

sql_scope_session :: Num a => a

sql_pc_unknown :: Num a => a

sql_pc_non_pseudo :: Num a => a

sql_pc_pseudo :: Num a => a

sql_row_identifier :: Num a => a

sql_index_unique :: Num a => a

sql_index_all :: Num a => a

sql_index_clustered :: Num a => a

sql_index_hashed :: Num a => a

sql_index_other :: Num a => a

sql_api_sqlallocconnect :: Num a => a

sql_api_sqlallocenv :: Num a => a

sql_api_sqlallochandle :: Num a => a

sql_api_sqlallocstmt :: Num a => a

sql_api_sqlbindcol :: Num a => a

sql_api_sqlbindparam :: Num a => a

sql_api_sqlcancel :: Num a => a

sql_api_sqlclosecursor :: Num a => a

sql_api_sqlcolattribute :: Num a => a

sql_api_sqlcolumns :: Num a => a

sql_api_sqlconnect :: Num a => a

sql_api_sqlcopydesc :: Num a => a

sql_api_sqldatasources :: Num a => a

sql_api_sqldescribecol :: Num a => a

sql_api_sqldisconnect :: Num a => a

sql_api_sqlendtran :: Num a => a

sql_api_sqlerror :: Num a => a

sql_api_sqlexecdirect :: Num a => a

sql_api_sqlexecute :: Num a => a

sql_api_sqlfetch :: Num a => a

sql_api_sqlfetchscroll :: Num a => a

sql_api_sqlfreeconnect :: Num a => a

sql_api_sqlfreeenv :: Num a => a

sql_api_sqlfreehandle :: Num a => a

sql_api_sqlfreestmt :: Num a => a

sql_api_sqlgetconnectattr :: Num a => a

sql_api_sqlgetconnectoption :: Num a => a

sql_api_sqlgetcursorname :: Num a => a

sql_api_sqlgetdata :: Num a => a

sql_api_sqlgetdescfield :: Num a => a

sql_api_sqlgetdescrec :: Num a => a

sql_api_sqlgetdiagfield :: Num a => a

sql_api_sqlgetdiagrec :: Num a => a

sql_api_sqlgetenvattr :: Num a => a

sql_api_sqlgetfunctions :: Num a => a

sql_api_sqlgetinfo :: Num a => a

sql_api_sqlgetstmtattr :: Num a => a

sql_api_sqlgetstmtoption :: Num a => a

sql_api_sqlgettypeinfo :: Num a => a

sql_api_sqllanguages :: Num a => a

sql_api_sqlnumresultcols :: Num a => a

sql_api_sqlparamdata :: Num a => a

sql_api_sqlprepare :: Num a => a

sql_api_sqlputdata :: Num a => a

sql_api_sqlreleaseenv :: Num a => a

sql_api_sqlrowcount :: Num a => a

sql_api_sqlserverinfo :: Num a => a

sql_api_sqlsetconnectattr :: Num a => a

sql_api_sqlsetconnectoption :: Num a => a

sql_api_sqlsetcursorname :: Num a => a

sql_api_sqlsetdescfield :: Num a => a

sql_api_sqlsetdescrec :: Num a => a

sql_api_sqlsetenvattr :: Num a => a

sql_api_sqlsetparam :: Num a => a

sql_api_sqlsetstmtattr :: Num a => a

sql_api_sqlsetstmtoption :: Num a => a

sql_api_sqlspecialcolumns :: Num a => a

sql_api_sqlstatistics :: Num a => a

sql_api_sqltables :: Num a => a

sql_api_sqltransact :: Num a => a

sql_max_driver_connections :: Num a => a

sql_max_concurrent_activities :: Num a => a

sql_data_source_name :: Num a => a

sql_fetch_direction :: Num a => a

sql_server_name :: Num a => a

sql_search_pattern_escape :: Num a => a

sql_dbms_name :: Num a => a

sql_dbms_ver :: Num a => a

sql_accessible_tables :: Num a => a

sql_cursor_commit_behavior :: Num a => a

sql_data_source_read_only :: Num a => a

sql_default_txn_isolation :: Num a => a

sql_identifier_case :: Num a => a

sql_identifier_quote_char :: Num a => a

sql_max_column_name_len :: Num a => a

sql_max_cursor_name_len :: Num a => a

sql_max_schema_name_len :: Num a => a

sql_max_catalog_name_len :: Num a => a

sql_max_table_name_len :: Num a => a

sql_scroll_concurrency :: Num a => a

sql_txn_capable :: Num a => a

sql_user_name :: Num a => a

sql_txn_isolation_option :: Num a => a

sql_integrity :: Num a => a

sql_getdata_extensions :: Num a => a

sql_null_collation :: Num a => a

sql_alter_table :: Num a => a

sql_order_by_columns_in_select :: Num a => a

sql_special_characters :: Num a => a

sql_max_columns_in_group_by :: Num a => a

sql_max_columns_in_index :: Num a => a

sql_max_columns_in_order_by :: Num a => a

sql_max_columns_in_select :: Num a => a

sql_max_columns_in_table :: Num a => a

sql_max_index_size :: Num a => a

sql_max_row_size :: Num a => a

sql_max_statement_len :: Num a => a

sql_max_tables_in_select :: Num a => a

sql_max_user_name_len :: Num a => a

sql_oj_capabilities :: Num a => a

sql_xopen_cli_year :: Num a => a

sql_cursor_sensitivity :: Num a => a

sql_describe_parameter :: Num a => a

sql_catalog_name :: Num a => a

sql_collation_seq :: Num a => a

sql_max_identifier_len :: Num a => a

sql_at_add_column :: CLong

sql_at_drop_column :: CLong

sql_at_alter_column :: CLong

sql_at_add_constraint :: CLong

sql_at_drop_constraint :: CLong

sql_cb_delete :: Num a => a

sql_cb_close :: Num a => a

sql_cb_preserve :: Num a => a

sql_fd_fetch_next :: CLong

sql_fd_fetch_first :: CLong

sql_fd_fetch_last :: CLong

sql_fd_fetch_prior :: CLong

sql_fd_fetch_absolute :: CLong

sql_fd_fetch_relative :: CLong

sql_gd_any_column :: CLong

sql_gd_any_order :: CLong

sql_ic_upper :: Num a => a

sql_ic_lower :: Num a => a

sql_ic_sensitive :: Num a => a

sql_ic_mixed :: Num a => a

sql_oj_left :: CLong

sql_oj_right :: CLong

sql_oj_full :: CLong

sql_oj_nested :: CLong

sql_oj_not_ordered :: CLong

sql_oj_inner :: CLong

sql_oj_all_comparison_ops :: CLong

sql_scco_read_only :: CLong

sql_scco_lock :: CLong

sql_scco_opt_rowver :: CLong

sql_scco_opt_values :: CLong

sql_tc_none :: Num a => a

sql_tc_dml :: Num a => a

sql_tc_all :: Num a => a

sql_tc_ddl_commit :: Num a => a

sql_tc_ddl_ignore :: Num a => a

sql_txn_read_uncommitted :: CLong

sql_txn_read_committed :: CLong

sql_txn_repeatable_read :: CLong

sql_txn_serializable :: CLong

sqlallocconnect :: SQLHENV -> Ptr SQLHDBC -> IO SQLRETURN

sqlallocenv :: Ptr SQLHENV -> IO SQLRETURN

sqlallochandle :: SQLSMALLINT -> SQLHANDLE -> Ptr SQLHANDLE -> IO SQLRETURN

sqlallocstmt :: SQLHDBC -> Ptr SQLHSTMT -> IO SQLRETURN

sqlbindcol :: SQLHSTMT -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLLEN -> Ptr SQLLEN -> IO SQLRETURN

sqlbindparam :: SQLHSTMT -> SQLSMALLINT -> SQLSMALLINT -> SQLSMALLINT -> SQLULEN -> SQLSMALLINT -> SQLPOINTER -> Ptr SQLLEN -> IO SQLRETURN

sqlcancel :: SQLHSTMT -> IO SQLRETURN

sqlclosecursor :: SQLHSTMT -> IO SQLRETURN

sqlcolattribute :: SQLHSTMT -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLLEN -> IO SQLRETURN

sqlcolumns :: SQLHSTMT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> IO SQLRETURN

sqlconnect :: SQLHDBC -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> IO SQLRETURN

sqlopydesc :: SQLHDESC -> SQLHDESC -> IO SQLRETURN

sqldatasources :: SQLHENV -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqldescribecol :: SQLHSTMT -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLULEN -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqldisconnect :: SQLHDBC -> IO SQLRETURN

sqlendtran :: SQLSMALLINT -> SQLHANDLE -> SQLSMALLINT -> IO SQLRETURN

sqlerror :: SQLHENV -> SQLHDBC -> SQLHSTMT -> Ptr SQLCHAR -> Ptr SQLINTEGER -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlexecdirect :: SQLHSTMT -> Ptr SQLCHAR -> SQLINTEGER -> IO SQLRETURN

sqlexecute :: SQLHSTMT -> IO SQLRETURN

sqlfetch :: SQLHSTMT -> IO SQLRETURN

sqlfetchscroll :: SQLHSTMT -> SQLSMALLINT -> SQLLEN -> IO SQLRETURN

sqlfreeconnect :: SQLHDBC -> IO SQLRETURN

sqlfreeenv :: SQLHENV -> IO SQLRETURN

sqlfreehandle :: SQLSMALLINT -> SQLHANDLE -> IO SQLRETURN

sqlfreestmt :: SQLHSTMT -> SQLSMALLINT -> IO SQLRETURN

sqlgetconnectattr :: SQLHDBC -> SQLINTEGER -> SQLPOINTER -> SQLINTEGER -> Ptr SQLINTEGER -> IO SQLRETURN

sqlgetconnectoption :: SQLHDBC -> SQLSMALLINT -> SQLPOINTER -> IO SQLRETURN

sqlgetcursorname :: SQLHSTMT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetdata :: SQLHSTMT -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLLEN -> Ptr SQLLEN -> IO SQLRETURN

sqlgetdescfield :: SQLHDESC -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLINTEGER -> Ptr SQLINTEGER -> IO SQLRETURN

sqlgetdescrec :: SQLHDESC -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLLEN -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetdiagfield :: SQLSMALLINT -> SQLHANDLE -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetdiagrec :: SQLSMALLINT -> SQLHANDLE -> SQLSMALLINT -> Ptr SQLCHAR -> Ptr SQLINTEGER -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetenvattr :: SQLHENV -> SQLINTEGER -> SQLPOINTER -> SQLINTEGER -> Ptr SQLINTEGER -> IO SQLRETURN

sqlgetfunctions :: SQLHDBC -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetinfo :: SQLHDBC -> SQLSMALLINT -> SQLPOINTER -> SQLSMALLINT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlgetstmtattr :: SQLHSTMT -> SQLINTEGER -> SQLPOINTER -> SQLINTEGER -> Ptr SQLINTEGER -> IO SQLRETURN

sqlgetstmtoption :: SQLHSTMT -> SQLSMALLINT -> SQLPOINTER -> IO SQLRETURN

sqlgettypeinfo :: SQLHSTMT -> SQLSMALLINT -> IO SQLRETURN

sqlnumresultcols :: SQLHSTMT -> Ptr SQLSMALLINT -> IO SQLRETURN

sqlparamdata :: SQLHSTMT -> Ptr SQLPOINTER -> IO SQLRETURN

sqlprepare :: SQLHSTMT -> Ptr SQLCHAR -> SQLINTEGER -> IO SQLRETURN

sqlputdata :: SQLHSTMT -> SQLPOINTER -> SQLLEN -> IO SQLRETURN

sqlrowcount :: SQLHSTMT -> Ptr SQLLEN -> IO SQLRETURN

sqlsetconnectattr :: SQLHDBC -> SQLINTEGER -> SQLPOINTER -> SQLINTEGER -> IO SQLRETURN

sqlsetconnectoption :: SQLHDBC -> SQLSMALLINT -> SQLPOINTER -> IO SQLRETURN

sqlsetcursorname :: SQLHSTMT -> Ptr SQLCHAR -> SQLSMALLINT -> IO SQLRETURN

sqlsetdescfield :: SQLHDESC -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> SQLINTEGER -> IO SQLRETURN

sqlsetdescrec :: SQLHDESC -> SQLSMALLINT -> SQLSMALLINT -> SQLSMALLINT -> SQLINTEGER -> SQLSMALLINT -> SQLSMALLINT -> SQLPOINTER -> Ptr SQLLEN -> Ptr SQLLEN -> IO SQLRETURN

sqlsetenvattr :: SQLHENV -> SQLINTEGER -> SQLPOINTER -> SQLINTEGER -> IO SQLRETURN

sqlsetparam :: SQLHSTMT -> SQLSMALLINT -> SQLSMALLINT -> SQLSMALLINT -> SQLULEN -> SQLSMALLINT -> SQLPOINTER -> Ptr SQLLEN -> IO SQLRETURN

sqlsetstmtattr :: SQLHSTMT -> SQLINTEGER -> SQLPOINTER -> SQLULEN -> IO SQLRETURN

sqlsetstmtoption :: SQLHSTMT -> SQLSMALLINT -> SQLPOINTER -> IO SQLRETURN

sqlspecialcolumns :: SQLHSTMT -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> SQLSMALLINT -> SQLSMALLINT -> IO SQLRETURN

sqlstatistics :: SQLHSTMT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> SQLSMALLINT -> SQLSMALLINT -> IO SQLRETURN

sqltables :: SQLHSTMT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> Ptr SQLCHAR -> SQLSMALLINT -> IO SQLRETURN

sqltransact :: SQLHENV -> SQLHDBC -> SQLSMALLINT -> IO SQLRETURN