require "dbi"

dbh = DBI.connect("DBI:ODBC:DBTEST")

begin
  sql = "CREATE TABLE EMPLOYEE(ID INTEGER, FIRST_NAME VARCHAR(20), "
  sql += "LAST_NAME VARCHAR(20), AGE INTEGER, GENDER VARCHAR(1), INCOME MONEY);"
  dbh.do(sql)
  puts "EMPLOYEE table created"
rescue
  dbh.execute("DELETE FROM EMPLOYEE")
  puts "EMPLOYEE table emptied"
end