3.1.1 plain-odbc/plain-odbc.asd

Source

plain-odbc.asd.

Parent Component

plain-odbc (system).

ASDF Systems

plain-odbc.

---

3.1.2 plain-odbc/odbc-stuff/plain-odbc-package.lisp

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Packages

plain-odbc.

---

3.1.3 plain-odbc/odbc-stuff/odbc-constants.lisp

Dependency

plain-odbc-package.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• $odbcver (constant).
• $sql_access_mode (constant).
• $sql_accessible_procedures (constant).
• $sql_accessible_tables (constant).
• $sql_active_connections (constant).
• $sql_active_environments (constant).
• $sql_active_statements (constant).
• $sql_add (constant).
• $sql_all_except_like (constant).
• $sql_alter_table (constant).
• $sql_api_all_functions (constant).
• $sql_api_loadbyordinal (constant).
• $sql_api_sqlallocconnect (constant).
• $sql_api_sqlallocenv (constant).
• $sql_api_sqlallocstmt (constant).
• $sql_api_sqlbindcol (constant).
• $sql_api_sqlbindparameter (constant).
• $sql_api_sqlbrowseconnect (constant).
• $sql_api_sqlcancel (constant).
• $sql_api_sqlcolattributes (constant).
• $sql_api_sqlcolumnprivileges (constant).
• $sql_api_sqlcolumns (constant).
• $sql_api_sqlconnect (constant).
• $sql_api_sqldatasources (constant).
• $sql_api_sqldescribecol (constant).
• $sql_api_sqldescribeparam (constant).
• $sql_api_sqldisconnect (constant).
• $sql_api_sqldriverconnect (constant).
• $sql_api_sqldrivers (constant).
• $sql_api_sqlerror (constant).
• $sql_api_sqlexecdirect (constant).
• $sql_api_sqlexecute (constant).
• $sql_api_sqlextendedfetch (constant).
• $sql_api_sqlfetch (constant).
• $sql_api_sqlforeignkeys (constant).
• $sql_api_sqlfreeconnect (constant).
• $sql_api_sqlfreeenv (constant).
• $sql_api_sqlfreestmt (constant).
• $sql_api_sqlgetconnectoption (constant).
• $sql_api_sqlgetcursorname (constant).
• $sql_api_sqlgetdata (constant).
• $sql_api_sqlgetfunctions (constant).
• $sql_api_sqlgetinfo (constant).
• $sql_api_sqlgetstmtoption (constant).
• $sql_api_sqlgettypeinfo (constant).
• $sql_api_sqlmoreresults (constant).
• $sql_api_sqlnativesql (constant).
• $sql_api_sqlnumparams (constant).
• $sql_api_sqlnumresultcols (constant).
• $sql_api_sqlparamdata (constant).
• $sql_api_sqlparamoptions (constant).
• $sql_api_sqlprepare (constant).
• $sql_api_sqlprimarykeys (constant).
• $sql_api_sqlprocedurecolumns (constant).
• $sql_api_sqlprocedures (constant).
• $sql_api_sqlputdata (constant).
• $sql_api_sqlrowcount (constant).
• $sql_api_sqlsetconnectoption (constant).
• $sql_api_sqlsetcursorname (constant).
• $sql_api_sqlsetparam (constant).
• $sql_api_sqlsetpos (constant).
• $sql_api_sqlsetscrolloptions (constant).
• $sql_api_sqlsetstmtoption (constant).
• $sql_api_sqlspecialcolumns (constant).
• $sql_api_sqlstatistics (constant).
• $sql_api_sqltableprivileges (constant).
• $sql_api_sqltables (constant).
• $sql_api_sqltransact (constant).
• $sql_attr_access_mode (constant).
• $sql_attr_autocommit (constant).
• $sql_attr_connection_dead (constant).
• $sql_attr_connection_timeout (constant).
• $sql_attr_current_catalog (constant).
• $sql_attr_disconnect_behavior (constant).
• $sql_attr_enlist_in_dtc (constant).
• $sql_attr_enlist_in_xa (constant).
• $sql_attr_login_timeout (constant).
• $sql_attr_odbc_cursors (constant).
• $sql_attr_packet_size (constant).
• $sql_attr_quiet_mode (constant).
• $sql_attr_readonly (constant).
• $sql_attr_readwrite_unknown (constant).
• $sql_attr_trace (constant).
• $sql_attr_tracefile (constant).
• $sql_attr_translate_lib (constant).
• $sql_attr_translate_option (constant).
• $sql_attr_txn_isolation (constant).
• $sql_attr_write (constant).
• $sql_autocommit (constant).
• $sql_autocommit_default (constant).
• $sql_autocommit_off (constant).
• $sql_autocommit_on (constant).
• $sql_bigint (constant).
• $sql_binary (constant).
• $sql_bit (constant).
• $sql_bookmark_persistence (constant).
• $sql_c_binary (constant).
• $sql_c_bit (constant).
• $sql_c_bookmark (constant).
• $sql_c_char (constant).
• $sql_c_date (constant).
• $sql_c_default (constant).
• $sql_c_double (constant).
• $sql_c_float (constant).
• $sql_c_long (constant).
• $sql_c_short (constant).
• $sql_c_slong (constant).
• $sql_c_sshort (constant).
• $sql_c_stinyint (constant).
• $sql_c_time (constant).
• $sql_c_timestamp (constant).
• $sql_c_tinyint (constant).
• $sql_c_ulong (constant).
• $sql_c_ushort (constant).
• $sql_c_utinyint (constant).
• $sql_c_wchar (constant).
• $sql_cd_false (constant).
• $sql_cd_true (constant).
• $sql_char (constant).
• $sql_close (constant).
• $sql_colatt_opt_max (constant).
• $sql_colatt_opt_min (constant).
• $sql_column_alias (constant).
• $sql_column_auto_increment (constant).
• $sql_column_case_sensitive (constant).
• $sql_column_count (constant).
• $sql_column_display_size (constant).
• $sql_column_driver_start (constant).
• $sql_column_label (constant).
• $sql_column_length (constant).
• $sql_column_money (constant).
• $sql_column_name (constant).
• $sql_column_nullable (constant).
• $sql_column_owner_name (constant).
• $sql_column_precision (constant).
• $sql_column_qualifier_name (constant).
• $sql_column_scale (constant).
• $sql_column_searchable (constant).
• $sql_column_table_name (constant).
• $sql_column_type (constant).
• $sql_column_type_name (constant).
• $sql_column_unsigned (constant).
• $sql_column_updatable (constant).
• $sql_commit (constant).
• $sql_concat_null_behavior (constant).
• $sql_conn_opt_max (constant).
• $sql_connect_opt_drvr_start (constant).
• $sql_convert_bigint (constant).
• $sql_convert_binary (constant).
• $sql_convert_bit (constant).
• $sql_convert_char (constant).
• $sql_convert_date (constant).
• $sql_convert_decimal (constant).
• $sql_convert_double (constant).
• $sql_convert_float (constant).
• $sql_convert_functions (constant).
• $sql_convert_integer (constant).
• $sql_convert_longvarbinary (constant).
• $sql_convert_longvarchar (constant).
• $sql_convert_numeric (constant).
• $sql_convert_real (constant).
• $sql_convert_smallint (constant).
• $sql_convert_time (constant).
• $sql_convert_timestamp (constant).
• $sql_convert_tinyint (constant).
• $sql_convert_varbinary (constant).
• $sql_convert_varchar (constant).
• $sql_correlation_name (constant).
• $sql_cur_default (constant).
• $sql_cur_use_driver (constant).
• $sql_cur_use_if_needed (constant).
• $sql_cur_use_odbc (constant).
• $sql_current_qualifier (constant).
• $sql_cursor_commit_behavior (constant).
• $sql_cursor_rollback_behavior (constant).
• $sql_data_at_exec (constant).
• $sql_data_source_name (constant).
• $sql_data_source_read_only (constant).
• $sql_date (constant).
• $sql_dbms_name (constant).
• $sql_dbms_ver (constant).
• $sql_decimal (constant).
• $sql_default_param (constant).
• $sql_default_txn_isolation (constant).
• $sql_delete (constant).
• $sql_double (constant).
• $sql_driver_complete (constant).
• $sql_driver_complete_required (constant).
• $sql_driver_hdbc (constant).
• $sql_driver_henv (constant).
• $sql_driver_hlib (constant).
• $sql_driver_hstmt (constant).
• $sql_driver_name (constant).
• $sql_driver_noprompt (constant).
• $sql_driver_odbc_ver (constant).
• $sql_driver_prompt (constant).
• $sql_driver_ver (constant).
• $sql_drop (constant).
• $sql_error (constant).
• $sql_expressions_in_orderby (constant).
• $sql_ext_api_last (constant).
• $sql_ext_api_start (constant).
• $sql_fd_fetch_absolute (constant).
• $sql_fd_fetch_bookmark (constant).
• $sql_fd_fetch_first (constant).
• $sql_fd_fetch_last (constant).
• $sql_fd_fetch_next (constant).
• $sql_fd_fetch_prior (constant).
• $sql_fd_fetch_relative (constant).
• $sql_fd_fetch_resume (constant).
• $sql_fetch_absolute (constant).
• $sql_fetch_bookmark (constant).
• $sql_fetch_direction (constant).
• $sql_fetch_first (constant).
• $sql_fetch_last (constant).
• $sql_fetch_next (constant).
• $sql_fetch_prior (constant).
• $sql_fetch_relative (constant).
• $sql_file_usage (constant).
• $sql_float (constant).
• $sql_getdata_extensions (constant).
• $sql_group_by (constant).
• $sql_identifier_case (constant).
• $sql_identifier_quote_char (constant).
• $sql_ignore (constant).
• $sql_info_first (constant).
• $sql_integer (constant).
• $sql_interval_day (constant).
• $sql_interval_day_to_hour (constant).
• $sql_interval_day_to_minute (constant).
• $sql_interval_day_to_second (constant).
• $sql_interval_hour (constant).
• $sql_interval_hour_to_minute (constant).
• $sql_interval_hour_to_second (constant).
• $sql_interval_minute (constant).
• $sql_interval_minute_to_second (constant).
• $sql_interval_month (constant).
• $sql_interval_second (constant).
• $sql_interval_year (constant).
• $sql_interval_year_to_month (constant).
• $sql_invalid_handle (constant).
• $sql_keywords (constant).
• $sql_len_data_at_exec_offset (constant).
• $sql_like_escape_clause (constant).
• $sql_like_only (constant).
• $sql_lock_exclusive (constant).
• $sql_lock_no_change (constant).
• $sql_lock_types (constant).
• $sql_lock_unlock (constant).
• $sql_login_timeout (constant).
• $sql_login_timeout_default (constant).
• $sql_longvarbinary (constant).
• $sql_longvarchar (constant).
• $sql_max_binary_literal_len (constant).
• $sql_max_char_literal_len (constant).
• $sql_max_column_name_len (constant).
• $sql_max_columns_in_group_by (constant).
• $sql_max_columns_in_index (constant).
• $sql_max_columns_in_order_by (constant).
• $sql_max_columns_in_select (constant).
• $sql_max_columns_in_table (constant).
• $sql_max_cursor_name_len (constant).
• $sql_max_dsn_length (constant).
• $sql_max_index_size (constant).
• $sql_max_message_length (constant).
• $sql_max_option_string_length (constant).
• $sql_max_owner_name_len (constant).
• $sql_max_procedure_name_len (constant).
• $sql_max_qualifier_name_len (constant).
• $sql_max_row_size (constant).
• $sql_max_row_size_includes_long (constant).
• $sql_max_statement_len (constant).
• $sql_max_table_name_len (constant).
• $sql_max_tables_in_select (constant).
• $sql_max_user_name_len (constant).
• $sql_mode_default (constant).
• $sql_mode_read_only (constant).
• $sql_mode_read_write (constant).
• $sql_mult_result_sets (constant).
• $sql_multiple_active_txn (constant).
• $sql_need_data (constant).
• $sql_need_long_data_len (constant).
• $sql_no_data_found (constant).
• $sql_no_nulls (constant).
• $sql_no_total (constant).
• $sql_non_nullable_columns (constant).
• $sql_nts (constant).
• $sql_null_collation (constant).
• $sql_null_data (constant).
• $sql_null_hdbc (constant).
• $sql_null_henv (constant).
• $sql_null_hstmt (constant).
• $sql_nullable (constant).
• $sql_nullable_unknown (constant).
• $sql_num_extensions (constant).
• $sql_num_functions (constant).
• $sql_numeric (constant).
• $sql_numeric_functions (constant).
• $sql_odbc_api_conformance (constant).
• $sql_odbc_cursors (constant).
• $sql_odbc_sag_cli_conformance (constant).
• $sql_odbc_sql_conformance (constant).
• $sql_odbc_sql_opt_ief (constant).
• $sql_odbc_ver (constant).
• $sql_opt_trace (constant).
• $sql_opt_trace_default (constant).
• $sql_opt_trace_off (constant).
• $sql_opt_trace_on (constant).
• $sql_opt_tracefile (constant).
• $sql_order_by_columns_in_select (constant).
• $sql_outer_joins (constant).
• $sql_owner_term (constant).
• $sql_owner_usage (constant).
• $sql_packet_size (constant).
• $sql_param_input (constant).
• $sql_param_input_output (constant).
• $sql_param_output (constant).
• $sql_param_type_unknown (constant).
• $sql_pos_add (constant).
• $sql_pos_delete (constant).
• $sql_pos_operations (constant).
• $sql_pos_position (constant).
• $sql_pos_refresh (constant).
• $sql_pos_update (constant).
• $sql_position (constant).
• $sql_positioned_statements (constant).
• $sql_procedure_term (constant).
• $sql_procedures (constant).
• $sql_qualifier_location (constant).
• $sql_qualifier_name_separator (constant).
• $sql_qualifier_term (constant).
• $sql_qualifier_usage (constant).
• $sql_quiet_mode (constant).
• $sql_quoted_identifier_case (constant).
• $sql_real (constant).
• $sql_refresh (constant).
• $sql_reset_params (constant).
• $sql_result_col (constant).
• $sql_return_value (constant).
• $sql_rollback (constant).
• $sql_row_updates (constant).
• $sql_scco_lock (constant).
• $sql_scco_opt_rowver (constant).
• $sql_scco_opt_values (constant).
• $sql_scco_read_only (constant).
• $sql_scroll_concurrency (constant).
• $sql_scroll_options (constant).
• $sql_search_pattern_escape (constant).
• $sql_searchable (constant).
• $sql_server_name (constant).
• $sql_signed_offset (constant).
• $sql_smallint (constant).
• $sql_so_dynamic (constant).
• $sql_so_forward_only (constant).
• $sql_so_keyset_driven (constant).
• $sql_so_mixed (constant).
• $sql_so_static (constant).
• $sql_spec_major (constant).
• $sql_spec_minor (constant).
• $sql_spec_string (constant).
• $sql_special_characters (constant).
• $sql_sqlstate_size (constant).
• $sql_static_sensitivity (constant).
• $sql_still_executing (constant).
• $sql_string_functions (constant).
• $sql_subqueries (constant).
• $sql_success (constant).
• $sql_success_with_info (constant).
• $sql_system_functions (constant).
• $sql_table_term (constant).
• $sql_tc_all (constant).
• $sql_tc_ddl_commit (constant).
• $sql_tc_ddl_ignore (constant).
• $sql_tc_dml (constant).
• $sql_tc_none (constant).
• $sql_time (constant).
• $sql_timedate_add_intervals (constant).
• $sql_timedate_diff_intervals (constant).
• $sql_timedate_functions (constant).
• $sql_timestamp (constant).
• $sql_tinyint (constant).
• $sql_translate_dll (constant).
• $sql_translate_option (constant).
• $sql_txn_capable (constant).
• $sql_txn_isolation (constant).
• $sql_txn_isolation_option (constant).
• $sql_type_driver_end (constant).
• $sql_type_driver_start (constant).
• $sql_type_max (constant).
• $sql_type_min (constant).
• $sql_type_null (constant).
• $sql_unbind (constant).
• $sql_unicode (constant).
• $sql_union (constant).
• $sql_unsearchable (constant).
• $sql_unsigned_offset (constant).
• $sql_update (constant).
• $sql_user_name (constant).
• $sql_varbinary (constant).
• $sql_varchar (constant).
• $sql_wchar (constant).
• $sql_wlongvarchar (constant).
• $sql_wvarchar (constant).

---

3.1.4 plain-odbc/odbc-stuff/global.lisp

Dependency

odbc-constants.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Public Interface

• *client-encoding* (special variable).
• *date-datatype-to-universal-time* (special variable).
• *date-type-predicate* (special variable).
• *odbc-library-file* (special variable).
• *universal-time-to-date-datatype* (special variable).

Internals

• *default-binary-parameter-size* (special variable).
• *default-string-parameter-size* (special variable).
• *lob-fetch-buffer-size* (special variable).
• *max-column-buffer-size* (special variable).
• *max-precision* (special variable).

---

3.1.5 plain-odbc/odbc-stuff/ffi-support.lisp

Dependency

global.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• %get-unicode-string (function).
• %null-ptr (function).
• %put-unicode-string (function).
• alloc-chars (function).
• cffi-0.10-or-0.9 (macro).
• get-byte-vector (function).
• get-string (function).
• get-string-nts (function).
• put-byte-vector (function).
• put-string (function).
• string-to-wchar-bytes (function).
• wchar-bytes-to-string (function).
• with-foreign-string-alloc (macro).

---

3.1.6 plain-odbc/odbc-stuff/odbc-ff-interface.lisp

Dependency

ffi-support.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• %put-sql-c-date (function).
• %put-sql-c-timestamp (function).
• %sql-len-data-at-exec (function).
• date-to-universal-time (function).
• defsqlfun (macro).
• sql-c-date-tclass (class).
• sql-c-time-tclass (class).
• sql-c-timestamp-tclass (class).
• sqlallocconnect (function).
• sqlallocenv (function).
• sqlallocstmt (function).
• sqlbindcol (function).
• sqlbindparameter (function).
• sqlcolumns (function).
• sqldescribecol (function).
• sqldisconnect (function).
• sqldriverconnect (function).
• sqlerror (function).
• sqlexecdirect (function).
• sqlexecute (function).
• sqlfetch (function).
• sqlforeignkeys (function).
• sqlfreeconnect (function).
• sqlfreestmt (function).
• sqlgetdata (function).
• sqlgetinfo (function).
• sqlgetinfo-str (function).
• sqlmoreresults (function).
• sqlnumresultcols (function).
• sqlparamdata (function).
• sqlprepare (function).
• sqlprimarykeys (function).
• sqlputdata (function).
• sqlrowcount (function).
• sqlsetconnectattr_long (function).
• sqlsetconnectattr_string (function).
• sqlsetconnectoption (function).
• sqltables (function).
• sqltransact (function).
• timestamp-to-universal-time (function).

---

3.1.7 plain-odbc/odbc-stuff/odbc-functions.lisp

Dependency

odbc-ff-interface.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• %bind-column (function).
• %commit (function).
• %describe-column (function).
• %disconnect (function).
• %free-connection (function).
• %free-statement (function).
• %new-db-connection-handle (function).
• %new-environment-handle (function).
• %new-statement-handle (function).
• %rollback (function).
• %sql-bind-parameter (function).
• %sql-columns (function).
• %sql-driver-connect (function).
• %sql-exec-direct (function).
• %sql-execute (function).
• %sql-fetch (function).
• %sql-foreign-keys (function).
• %sql-get-data (function).
• %sql-get-data-raw (function).
• %sql-get-info (function).
• %sql-more-results (function).
• %sql-param-data (function).
• %sql-prepare (function).
• %sql-primary-keys (function).
• %sql-put-data (function).
• %sql-tables (function).
• %start-connection-trace (function).
• %stop-connection-trace (function).
• disable-autocommit (function).
• enable-autocommit (function).
• error-handling-fun (function).
• handle-error (function).
• result-columns-count (function).
• result-rows-count (function).
• set-connection-attr-integer (function).
• set-connection-attr-string (function).
• set-connection-option (function).
• sql-condition (condition).
• sql-error (condition).
• sql-state (function).
• sql-warning (condition).
• with-error-handling (macro).
• with-foreign-string-allocations (macro).
• with-statement-handle (macro).
• with-temporary-allocations (macro).

---

3.1.8 plain-odbc/odbc-stuff/parameter.lisp

Dependency

odbc-functions.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• binary-parameter (class).
• bind-parameter (function).
• blob-parameter (class).
• clob-parameter (class).
• create-parameter (function).
• date-parameter (class).
• direct-parameter (class).
• double-parameter (class).
• free-parameter (generic function).
• free-parameters (function).
• get-parameter-value (generic function).
• initialize-parameter (generic function).
• integer-parameter (class).
• lob-parameter (class).
• parameter (class).
• query (reader method).
• send-parameter-data (generic function).
• set-parameter-value (generic function).
• string-parameter (class).
• uclob-parameter (class).
• unicode-string-parameter (class).

---

3.1.9 plain-odbc/odbc-stuff/column.lisp

Dependency

parameter.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Internals

• bigint-column (class).
• binary-column (class).
• blob-column (class).
• bound-column (class).
• clob-column (class).
• column (class).
• column-info-to-class-and-args (function).
• column-info-to-class-and-args-prefer-lob (function).
• column-is-bound (function).
• create-column (function).
• date-column (class).
• decimal-column (class).
• double-column (class).
• exec-get-data (function).
• gd-bigint-column (class).
• gd-date-column (class).
• gd-double-column (class).
• gd-integer-column (class).
• get-binary-data (function).
• get-character-data (function).
• get-column-value (generic function).
• get-len (function).
• get-unicode-character-data (function).
• getdata-column (class).
• hstmt (reader method).
• (setf hstmt) (writer method).
• initialize-column (generic function).
• integer-column (class).
• string-column (class).
• uclob-column (class).
• unicode-string-column (class).

---

3.1.10 plain-odbc/odbc-stuff/odbc-main.lisp

Dependency

column.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Public Interface

• close-connection (function).
• commit (function).
• connect (function).
• connect-generic (function).
• exec-command (function).
• exec-command* (function).
• exec-prepared-command (method).
• exec-prepared-query (method).
• exec-prepared-update (method).
• exec-query (function).
• exec-query* (function).
• exec-sql (function).
• exec-sql* (function).
• exec-update (function).
• exec-update* (function).
• free-statement (function).
• get-columns (function).
• get-foreign-keys (function).
• get-primary-keys (function).
• get-tables (function).
• prepare-statement (method).
• print-object (method).
• rollback (function).
• trace-connection (function).
• untrace-connection (function).
• use-bind-column (reader method).
• (setf use-bind-column) (writer method).

Internals

• *open-connections* (special variable).
• bind-columns (function).
• build-connection-string (function).
• call-metadata-func (function).
• column-count (reader method).
• (setf column-count) (writer method).
• column-names (function).
• connected-p (reader method).
• connection (reader method).
• db-info (reader method).
• dbms-name (reader method).
• driver-connect (function).
• exec-sql-statement (function).
• fetch-query-results (method).
• free-query (method).
• free-query (method).
• get-odbc-info (function).
• get-parameters (method).
• hdbc (reader method).
• (setf hdbc) (writer method).
• henv (reader method).
• (setf henv) (writer method).
• hstmt (reader method).
• (setf hstmt) (writer method).
• make-prepared-statement (function).
• make-query (function).
• object-to-parameter-spec (function).
• odbc-connection (class).
• odbc-query (class).
• parameters (reader method).
• (setf parameters) (writer method).
• prepared-statement (class).
• server-name (reader method).
• set-parameters (method).
• set-params-and-exec (method).
• sql-param-data-position (function).
• unbind-columns (function).
• use-bind-p (function).
• user-name (reader method).

---

3.1.11 plain-odbc/odbc-stuff/odbc-utilities.lisp

Dependency

odbc-main.lisp (file).

Source

plain-odbc.asd.

Parent Component

odbc-stuff (module).

Public Interface

• *default-access-dsn* (special variable).
• *default-mysql-dsn* (special variable).
• *default-oracle-dsn* (special variable).
• *default-sql-server-dsn* (special variable).
• *default-sqlite-dsn* (special variable).
• connect-access (function).
• connect-mysql (function).
• connect-oracle (function).
• connect-sql-server (function).
• connect-sqlite (function).
• with-prepared-statement (macro).

Internals

with-prepared-statement-fun (function).

---

5.1.1 Special variables

Special Variable: *client-encoding* ¶

Package

plain-odbc.

Source

global.lisp.

Special Variable: *date-datatype-to-universal-time* ¶

Package

plain-odbc.

Source

global.lisp.

Special Variable: *date-type-predicate* ¶

Package

plain-odbc.

Source

global.lisp.

Special Variable: *default-access-dsn* ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Special Variable: *default-mysql-dsn* ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Special Variable: *default-oracle-dsn* ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Special Variable: *default-sql-server-dsn* ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Special Variable: *default-sqlite-dsn* ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Special Variable: *odbc-library-file* ¶

Package

plain-odbc.

Source

global.lisp.

Special Variable: *universal-time-to-date-datatype* ¶

Package

plain-odbc.

Source

global.lisp.

---

5.1.2 Macros

Macro: with-prepared-statement ((stm con string &rest params) &body body) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

---

5.1.3 Ordinary functions

Function: close-connection (con) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: commit (con) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: connect (dsn userid password) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: connect-access (filename) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Function: connect-generic (&rest attrs) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: connect-mysql (server database user password) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Function: connect-oracle (tns-name user pw) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Function: connect-sql-server (server database &optional user-id password) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Function: connect-sqlite (filename) ¶

Package

plain-odbc.

Source

odbc-utilities.lisp.

Function: exec-command (connection sql &rest parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-command* (connection sql parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-query (connection sql &rest parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-query* (connection sql parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-sql (connection sql &rest parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-sql* (connection sql parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-update (connection sql &rest parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: exec-update* (connection sql parameter-list) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: free-statement (x) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: get-columns (connection catalog-name schema-name table-name column-name) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: get-foreign-keys (connection catalog-name1 schema-name1 table-name1 catalog-name2 schema-name2 table-name2) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: get-primary-keys (connection catalog-name schema-name table-name) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: get-tables (connection catalog-name schema-name table-name table-type) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: rollback (con) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: trace-connection (con filename) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

Function: untrace-connection (con) ¶

Package

plain-odbc.

Source

odbc-main.lisp.

---

5.1.4 Generic functions

Generic Function: exec-prepared-command (query &rest parameters) ¶

Package

plain-odbc.

Methods

Method: exec-prepared-command ((query prepared-statement) &rest parameters) ¶

Source

odbc-main.lisp.

Generic Function: exec-prepared-query (query &rest parameters) ¶

Package

plain-odbc.

Methods

Method: exec-prepared-query ((query prepared-statement) &rest parameters) ¶

Source

odbc-main.lisp.

Generic Function: exec-prepared-update (query &rest parameters) ¶

Package

plain-odbc.

Methods

Method: exec-prepared-update ((query prepared-statement) &rest parameters) ¶

Source

odbc-main.lisp.

Generic Function: prepare-statement (connection sql &rest parameter-list) ¶

Package

plain-odbc.

Methods

Method: prepare-statement ((connection odbc-connection) sql &rest parameter-list) ¶

Source

odbc-main.lisp.

Generic Reader: use-bind-column (object) ¶

Package

plain-odbc.

Methods

Reader Method: use-bind-column ((odbc-connection odbc-connection)) ¶

automatically generated reader method

Source

odbc-main.lisp.

Target Slot

use-bind.

Generic Writer: (setf use-bind-column) (object) ¶

Package

plain-odbc.

Methods

Writer Method: (setf use-bind-column) ((odbc-connection odbc-connection)) ¶

automatically generated writer method

Source

odbc-main.lisp.

Target Slot

use-bind.

---

5.1.5 Standalone methods

Method: print-object ((connection odbc-connection) s) ¶

Source

odbc-main.lisp.

---

5.2.1 Constants

Constant: $odbcver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_access_mode ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_accessible_procedures ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_accessible_tables ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_active_connections ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_active_environments ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_active_statements ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_add ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_all_except_like ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_alter_table ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_all_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_loadbyordinal ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlallocconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlallocenv ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlallocstmt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlbindcol ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlbindparameter ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlbrowseconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlcancel ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlcolattributes ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlcolumnprivileges ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlcolumns ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldatasources ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldescribecol ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldescribeparam ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldisconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldriverconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqldrivers ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlerror ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlexecdirect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlexecute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlextendedfetch ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlfetch ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlforeignkeys ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlfreeconnect ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlfreeenv ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlfreestmt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetconnectoption ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetcursorname ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetdata ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetfunctions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetinfo ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgetstmtoption ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlgettypeinfo ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlmoreresults ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlnativesql ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlnumparams ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlnumresultcols ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlparamdata ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlparamoptions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlprepare ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlprimarykeys ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlprocedurecolumns ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlprocedures ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlputdata ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlrowcount ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetconnectoption ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetcursorname ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetparam ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetpos ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetscrolloptions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlsetstmtoption ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlspecialcolumns ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqlstatistics ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqltableprivileges ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqltables ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_api_sqltransact ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_access_mode ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_autocommit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_connection_dead ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_connection_timeout ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_current_catalog ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_disconnect_behavior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_enlist_in_dtc ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_enlist_in_xa ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_login_timeout ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_odbc_cursors ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_packet_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_quiet_mode ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_readonly ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_readwrite_unknown ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_trace ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_tracefile ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_translate_lib ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_translate_option ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_txn_isolation ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_attr_write ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_autocommit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_autocommit_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_autocommit_off ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_autocommit_on ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_bigint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_binary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_bit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_bookmark_persistence ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_binary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_bit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_bookmark ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_char ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_date ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_double ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_float ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_long ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_short ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_slong ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_sshort ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_stinyint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_time ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_timestamp ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_tinyint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_ulong ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_ushort ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_utinyint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_c_wchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cd_false ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cd_true ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_char ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_close ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_colatt_opt_max ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_colatt_opt_min ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_alias ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_auto_increment ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_case_sensitive ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_count ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_display_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_driver_start ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_label ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_length ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_money ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_nullable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_owner_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_precision ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_qualifier_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_scale ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_searchable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_table_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_type ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_type_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_unsigned ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_column_updatable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_commit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_concat_null_behavior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_conn_opt_max ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_connect_opt_drvr_start ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_bigint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_binary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_bit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_char ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_date ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_decimal ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_double ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_float ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_integer ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_longvarbinary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_longvarchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_numeric ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_real ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_smallint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_time ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_timestamp ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_tinyint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_varbinary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_convert_varchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_correlation_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cur_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cur_use_driver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cur_use_if_needed ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cur_use_odbc ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_current_qualifier ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cursor_commit_behavior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_cursor_rollback_behavior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_data_at_exec ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_data_source_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_data_source_read_only ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_date ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_dbms_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_dbms_ver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_decimal ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_default_param ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_default_txn_isolation ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_delete ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_double ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_complete ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_complete_required ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_hdbc ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_henv ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_hlib ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_hstmt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_noprompt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_odbc_ver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_prompt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_driver_ver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_drop ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_error ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_expressions_in_orderby ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_ext_api_last ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_ext_api_start ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_absolute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_bookmark ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_first ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_last ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_next ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_prior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_relative ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fd_fetch_resume ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_absolute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_bookmark ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_direction ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_first ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_last ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_next ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_prior ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_fetch_relative ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_file_usage ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_float ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_getdata_extensions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_group_by ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_identifier_case ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_identifier_quote_char ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_ignore ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_info_first ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_integer ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_day ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_day_to_hour ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_day_to_minute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_day_to_second ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_hour ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_hour_to_minute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_hour_to_second ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_minute ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_minute_to_second ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_month ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_second ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_year ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_interval_year_to_month ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_invalid_handle ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_keywords ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_len_data_at_exec_offset ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_like_escape_clause ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_like_only ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_lock_exclusive ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_lock_no_change ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_lock_types ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_lock_unlock ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_login_timeout ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_login_timeout_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_longvarbinary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_longvarchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_binary_literal_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_char_literal_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_column_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_columns_in_group_by ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_columns_in_index ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_columns_in_order_by ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_columns_in_select ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_columns_in_table ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_cursor_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_dsn_length ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_index_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_message_length ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_option_string_length ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_owner_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_procedure_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_qualifier_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_row_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_row_size_includes_long ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_statement_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_table_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_tables_in_select ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_max_user_name_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_mode_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_mode_read_only ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_mode_read_write ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_mult_result_sets ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_multiple_active_txn ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_need_data ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_need_long_data_len ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_no_data_found ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_no_nulls ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_no_total ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_non_nullable_columns ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_nts ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_null_collation ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_null_data ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_null_hdbc ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_null_henv ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_null_hstmt ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_nullable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_nullable_unknown ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_num_extensions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_num_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_numeric ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_numeric_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_api_conformance ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_cursors ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_sag_cli_conformance ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_sql_conformance ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_sql_opt_ief ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_odbc_ver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_opt_trace ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_opt_trace_default ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_opt_trace_off ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_opt_trace_on ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_opt_tracefile ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_order_by_columns_in_select ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_outer_joins ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_owner_term ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_owner_usage ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_packet_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_param_input ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_param_input_output ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_param_output ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_param_type_unknown ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_add ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_delete ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_operations ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_position ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_refresh ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_pos_update ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_position ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_positioned_statements ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_procedure_term ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_procedures ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_qualifier_location ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_qualifier_name_separator ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_qualifier_term ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_qualifier_usage ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_quiet_mode ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_quoted_identifier_case ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_real ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_refresh ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_reset_params ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_result_col ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_return_value ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_rollback ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_row_updates ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scco_lock ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scco_opt_rowver ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scco_opt_values ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scco_read_only ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scroll_concurrency ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_scroll_options ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_search_pattern_escape ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_searchable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_server_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_signed_offset ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_smallint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_so_dynamic ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_so_forward_only ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_so_keyset_driven ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_so_mixed ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_so_static ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_spec_major ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_spec_minor ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_spec_string ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_special_characters ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_sqlstate_size ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_static_sensitivity ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_still_executing ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_string_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_subqueries ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_success ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_success_with_info ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_system_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_table_term ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tc_all ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tc_ddl_commit ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tc_ddl_ignore ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tc_dml ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tc_none ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_time ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_timedate_add_intervals ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_timedate_diff_intervals ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_timedate_functions ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_timestamp ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_tinyint ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_translate_dll ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_translate_option ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_txn_capable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_txn_isolation ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_txn_isolation_option ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_type_driver_end ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_type_driver_start ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_type_max ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_type_min ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_type_null ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_unbind ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_unicode ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_union ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_unsearchable ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_unsigned_offset ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_update ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_user_name ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_varbinary ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_varchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_wchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_wlongvarchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

Constant: $sql_wvarchar ¶

Package

plain-odbc.

Source

odbc-constants.lisp.

---