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

• #change_column_default(table_name, column_name, default) ⇒ Object
• #set_schema(schema) ⇒ Object

  Setting the SQLID on z/OS will also update the CURRENT SCHEMA special register, but not vice versa.

• #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

#check_reserved_words

Methods inherited from IBM_DB2_ZOS

#create_index_after_table, #remove_column, #set_binary_default

Methods inherited from IBM_DB2

#change_column, #execute, #get_datetime_mapping, #get_time_mapping, #last_generated_id, #primary_key, #query_offset_limit, #rename_column, #select_all, #set_binary_default, #set_binary_value, #set_case, #set_text_default

Methods inherited from IBM_DataServer

#check_reserved_words, #create_index_after_table, #execute, #get_datetime_mapping, #get_time_mapping, #initialize, #last_generated_id, #query_offset_limit, #remove_column, #reorg_table, #select_all, #set_binary_default, #set_binary_value, #set_case, #set_text_default

Constructor Details

This class inherits a constructor from ActiveRecord::ConnectionAdapters::IBM_DataServer

Instance Method Details

#change_column_default(table_name, column_name, default) ⇒ Object

Raises:

• (NotImplementedError)

# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 1347

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

#set_schema(schema) ⇒ Object

Setting the SQLID on z/OS will also update the CURRENT SCHEMA special register, but not vice versa

# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 1335

def set_schema(schema)
  execute("SET CURRENT SQLID ='#{schema.upcase}'")
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.

# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 1343

def setup_for_lob_table()
  execute "SET CURRENT RULES = 'STD'"
end