module Sequel::JDBC::DB2::DatabaseMethods

Private Instance Methods

convert_clob(r, i) click to toggle source
   # File lib/sequel/adapters/jdbc/db2.rb
73 def convert_clob(r, i)
74   if v = r.getClob(i)
75     v = v.getSubString(1, v.length)
76     v = Sequel::SQL::Blob.new(v) if use_clob_as_blob
77     v
78   end
79 end
last_insert_id(conn, opts=OPTS) click to toggle source
   # File lib/sequel/adapters/jdbc/db2.rb
52 def last_insert_id(conn, opts=OPTS)
53   statement(conn) do |stmt|
54     sql = "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1"
55     rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
56     rs.next
57     rs.getLong(1)
58   end
59 end
primary_key_index_re() click to toggle source

Primary key indexes appear to be named sqlNNNN on DB2

   # File lib/sequel/adapters/jdbc/db2.rb
62 def primary_key_index_re
63   /\Asql\d+\z/i
64 end
set_ps_arg(cps, arg, i) click to toggle source
Calls superclass method
   # File lib/sequel/adapters/jdbc/db2.rb
39 def set_ps_arg(cps, arg, i)
40   case arg
41   when Sequel::SQL::Blob
42     if use_clob_as_blob
43       cps.setString(i, arg)
44     else
45       super
46     end
47   else
48     super
49   end
50 end
setup_type_convertor_map() click to toggle source
Calls superclass method
   # File lib/sequel/adapters/jdbc/db2.rb
66 def setup_type_convertor_map
67   super
68   map = @type_convertor_map
69   types = Java::JavaSQL::Types
70   map[types::NCLOB] = map[types::CLOB] = method(:convert_clob)
71 end