Method: Sequel::DB2::DatabaseMethods#views

Defined in:
lib/sequel/adapters/shared/db2.rb

#views ⇒ Object

Use SYSCAT.TABLES to get the views for the database



64
65
66
67
68
 
# File 'lib/sequel/adapters/shared/db2.rb', line 64

def views
  metadata_dataset.
    with_sql("SELECT TABNAME FROM SYSCAT.TABLES WHERE TYPE='V' AND OWNER = #{literal(input_identifier_meth.call(opts[:user]))}").
    all.map{|h| output_identifier_meth.call(h[:tabname]) }
end