require 'rubygems'
gem 'activerecord-jdbc-adapter'
require 'jdbc_adapter'
require 'active_record'
require 'db2jcc-9.1.jar'  # => I had them under '/Users/Greg/.m2/repository/com/ibm/db2jcc/9.1/db2jcc-9.1.jar'
require 'db2jcc_license_cisuz-1.0.0.jar'

db_config = {
      :adapter => 'jdbc',
      :driver => "com.ibm.db2.jcc.DB2Driver",
      :url => "jdbc:db2://bigibmmainframe:2545/DBNAME",
      :username => "user",
      :password => "secret"
    }

ActiveRecord::Base.logger = Logger.new(File.open('database.log', 'a'))
ActiveRecord::Base.establish_connection db_config
SQL = "SELECT current date FROM sysibm.sysdummy1;"

puts ActiveRecord::Base.connection.execute(SQL)