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, #execute, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #last_generated_id, #prepare, #primary_key_definition, #query_offset_limit, #query_offset_limit!, #select, #select_rows, #set_binary_value, #set_case, #set_text_default

Methods inherited from IBM_DataServer

#check_reserved_words, #execute, #get_datetime_mapping, #get_double_mapping, #get_time_mapping, #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

Constructor Details

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

Instance Method Details

#change_column_default(table_name, column_name, default) ⇒ Object 



2313
2314
2315
2316
2317
2318
2319
2320
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2313

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) 


2322
2323
2324
2325
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2322

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?



2263
2264
2265
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2263

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) 


2267
2268
2269
2270
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2267

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



2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2273

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



2309
2310
2311
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 2309

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