Class: ActiveRecord::ConnectionAdapters::IBM_DB2_ZOS_8
- Inherits:
-
IBM_DB2_ZOS
- Object
- IBM_DataServer
- IBM_DB2
- IBM_DB2_ZOS
- ActiveRecord::ConnectionAdapters::IBM_DB2_ZOS_8
- Includes:
- HostedDataServer
- Defined in:
- lib/active_record/connection_adapters/ibm_db_adapter.rb
Overview
class IBM_DB2_ZOS
Constant Summary
Constants included from HostedDataServer
HostedDataServer::RESERVED_WORDS
Instance Method Summary collapse
- #change_column_default(table_name, column_name, default) ⇒ Object
- #get_limit_offset_clauses(limit, offset) ⇒ Object
- #query_offset_limit(sql, offset, limit) ⇒ Object
- #query_offset_limit!(sql, offset, limit, options) ⇒ Object
- #rename_column(table_name, column_name, new_column_name) ⇒ Object
-
#setup_for_lob_table ⇒ Object
This call is needed on DB2 z/OS v8 for the creation of tables with LOBs.
Methods included from HostedDataServer
Methods inherited from IBM_DB2_ZOS
#change_column_null, #create_index_after_table, #remove_column, #set_binary_default
Methods inherited from IBM_DB2
#change_column, #change_column_null, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #initialize, #last_generated_id, #primary_key_definition, #set_binary_default, #set_binary_value, #set_case, #set_text_default
Methods inherited from IBM_DataServer
#change_column_null, #check_reserved_words, #create_index_after_table, #execute, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #initialize, #last_generated_id, #limit_not_supported_types, #prepare, #remove_column, #reorg_table, #select, #select_rows, #set_binary_default, #set_binary_value, #set_case, #set_schema, #set_text_default
Constructor Details
This class inherits a constructor from ActiveRecord::ConnectionAdapters::IBM_DB2
Instance Method Details
#change_column_default(table_name, column_name, default) ⇒ Object
3068 3069 3070 3071 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3068 def change_column_default(table_name, column_name, default) raise NotImplementedError, "DB2 for zOS data server version 8 does not support changing the column default" end |
#get_limit_offset_clauses(limit, offset) ⇒ Object
3034 3035 3036 3037 3038 3039 3040 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3034 def get_limit_offset_clauses(limit, offset) retHash = {"startSegment" => "", "endSegment" => ""} if (!limit.nil?) retHash["endSegment"] = " FETCH FIRST #{limit} ROWS ONLY" end return retHash end |
#query_offset_limit(sql, offset, limit) ⇒ Object
3042 3043 3044 3045 3046 3047 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3042 def query_offset_limit(sql, offset, limit) if (!limit.nil?) sql << " FETCH FIRST #{limit} ROWS ONLY" end return sql end |
#query_offset_limit!(sql, offset, limit, options) ⇒ Object
3049 3050 3051 3052 3053 3054 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3049 def query_offset_limit!(sql, offset, limit, ) if (!limit.nil?) sql << " FETCH FIRST #{limit} ROWS ONLY" end [:paramArray] = [] end |
#rename_column(table_name, column_name, new_column_name) ⇒ Object
3064 3065 3066 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3064 def rename_column(table_name, column_name, new_column_name) raise NotImplementedError, "rename_column is not implemented for DB2 on zOS 8" end |
#setup_for_lob_table ⇒ Object
This call is needed on DB2 z/OS v8 for the creation of tables with LOBs. When issued, this call does the following:
DB2 creates LOB table spaces, auxiliary tables, and indexes on auxiliary
tables for LOB columns.
3060 3061 3062 |
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3060 def setup_for_lob_table() execute "SET CURRENT RULES = 'STD'" end |