Class: ActiveRecord::ConnectionAdapters::IBM_DB2_ZOS

Inherits:
IBM_DB2 show all
Defined in:
lib/active_record/connection_adapters/ibm_db_adapter.rb

Overview

module HostedDataServer

Direct Known Subclasses

IBM_DB2_ZOS_8

Instance Method Summary collapse

Methods inherited from IBM_DB2

#change_column, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #initialize, #last_generated_id, #primary_key_definition, #query_offset_limit, #query_offset_limit!, #set_binary_value, #set_case, #set_text_default

Methods inherited from IBM_DataServer

#check_reserved_words, #columns, #create_database, #drop_database, #execute, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #indexes, #initialize, #last_generated_id, #limit_not_supported_types, #prepare, #query_offset_limit, #query_offset_limit!, #reorg_table, #select, #select_rows, #set_binary_value, #set_case, #set_schema, #set_text_default, #setup_for_lob_table, #task_charset, #task_collation, #task_create, #task_drop, #task_purge, #task_structure_dump, #task_structure_load

Constructor Details

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

Instance Method Details

#change_column_default(table_name, column_name, default) ⇒ Object 



3139
3140
3141
3142
3143
3144
3145
3146
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3139

def change_column_default(table_name, column_name, default)
  unless default
    raise NotImplementedError,
    "DB2 for zOS data server version 9 does not support changing the column default to NULL"
  else
    super
  end
end

#change_column_null(table_name, column_name, null, default) ⇒ Object

Raises:

  • (NotImplementedError) 


3148
3149
3150
3151
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3148

def change_column_null(table_name, column_name, null, default)
  raise NotImplementedError,
  "DB2 for zOS data server does not support changing the column's nullability"
end

#create_index_after_table(table_name, column_name) ⇒ Object

since v9 doesn’t need, suggest putting it in HostedDataServer?



3089
3090
3091
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3089

def create_index_after_table(table_name,column_name)
  @adapter.add_index(table_name, column_name, :unique => true) 
end

#remove_column(table_name, column_name) ⇒ Object

Raises:

  • (NotImplementedError) 


3093
3094
3095
3096
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3093

def remove_column(table_name, column_name)
  raise NotImplementedError,
  "remove_column is not supported by the DB2 for zOS data server"
end

#rename_column(table_name, column_name, new_column_name) ⇒ Object

Alter table column for renaming a column



3099
3100
3101
3102
3103
3104
3105
3106
3107
3108
3109
3110
3111
3112
3113
3114
3115
3116
3117
3118
3119
3120
3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3099

def rename_column(table_name, column_name, new_column_name)
  _table_name      = table_name.to_s
  _column_name     = column_name.to_s
  _new_column_name = new_column_name.to_s

  nil_condition    = _table_name.nil? || _column_name.nil? || _new_column_name.nil?
  empty_condition  = _table_name.empty? || 
                       _column_name.empty? || 
                         _new_column_name.empty? unless nil_condition

  if nil_condition || empty_condition
    raise ArgumentError,"One of the arguments passed to rename_column is empty or nil"
  end

  begin
    rename_column_sql = "ALTER TABLE #{_table_name} RENAME COLUMN #{_column_name} \
             TO #{_new_column_name}"

    unless stmt = execute(rename_column_sql)
      error_msg = IBM_DB.getErrormsg(@adapter.connection, IBM_DB::DB_CONN )
      if error_msg && !error_msg.empty?
        raise "Rename column failed : #{error_msg}"
      else
        raise StandardError.new('An unexpected error occurred during renaming the column')
      end
    end

    reorg_table(_table_name)

  ensure
    IBM_DB.free_stmt(stmt) if stmt
  end #End of begin
end

#set_binary_default(value) ⇒ Object

DB2 z/OS only allows NULL or “” (empty) string as DEFAULT value for a BLOB column. For non-empty string and non-NULL values, the server returns error



3135
3136
3137
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3135

def set_binary_default(value)
  "#{value}"
end