# File lib/sequel/adapters/jdbc/db2.rb, line 62 def primary_key_index_re /\Asql\d+\z/ end
# File lib/sequel/adapters/jdbc/db2.rb, line 73 def convert_clob(r, i) if v = r.getClob(i) v = v.getSubString(1, v.length) v = Sequel::SQL::Blob.new(v) if use_clob_as_blob v end end
# File lib/sequel/adapters/jdbc/db2.rb, line 52 def last_insert_id(conn, opts=OPTS) statement(conn) do |stmt| sql = "SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1" rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)} rs.next rs.getLong(1) end end
Primary key indexes appear to be named sqlNNNN on DB2
# File lib/sequel/adapters/jdbc/db2.rb, line 62 def primary_key_index_re /\Asql\d+\z/ end
# File lib/sequel/adapters/jdbc/db2.rb, line 39 def set_ps_arg(cps, arg, i) case arg when Sequel::SQL::Blob if use_clob_as_blob cps.setString(i, arg) else super end else super end end
# File lib/sequel/adapters/jdbc/db2.rb, line 66 def setup_type_convertor_map super map = @type_convertor_map types = Java::JavaSQL::Types map[types::NCLOB] = map[types::CLOB] = method(:convert_clob) end