Method: ActiveRecord::ConnectionAdapters::IBM_DB2_I5#drop_database

Defined in:
lib/active_record/connection_adapters/ibm_db_adapter.rb

#drop_database(dbName) ⇒ Object 



3384
3385
3386
3387
3388
3389
3390
3391
3392
3393
3394
 
# File 'lib/active_record/connection_adapters/ibm_db_adapter.rb', line 3384

def drop_database(dbName)
  qcmdexc2 "QSYS/CHGJOB INQMSGRPY(*SYSRPYL)"
  qcmdexc2 "ADDRPYLE SEQNBR(4321) MSGID(CPA7025) RPY(''I'')"
  isolation = IBM_DB.getoption(@adapter.connection,IBM_DB::SQL_ATTR_TXN_ISOLATION,1)
  IBM_DB.setoption(@adapter.connection,{IBM_DB::SQL_ATTR_TXN_ISOLATION=>IBM_DB::SQL_TXN_NO_COMMIT},1)
  execute "DROP COLLECTION #{dbName}"
  qcmdexc2 "QSYS/CHGJOB INQMSGRPY(*DFT)"
  qcmdexc2 "RMVRPYLE SEQNBR(4321)"
  IBM_DB.setoption(@adapter.connection,{IBM_DB::SQL_ATTR_TXN_ISOLATION=>isolation},1)
  true
end