class Sequel::JDBC::AS400::Dataset

  1. lib/sequel/adapters/jdbc/as400.rb
Parent: AS400

Dataset class for AS400 datasets accessed via JDBC.

Included modules

  1. EmulateOffsetWithRowNumber

Constants

FETCH_FIRST = " FETCH FIRST ".freeze  
FETCH_FIRST_ROW_ONLY = " FETCH FIRST ROW ONLY".freeze  
ROWS_ONLY = " ROWS ONLY".freeze  
WILDCARD = Sequel::LiteralString.new('*').freeze  

Public Instance methods

select_limit_sql (sql)

Modify the sql to limit the number of rows returned

[show source]
# File lib/sequel/adapters/jdbc/as400.rb, line 55
def select_limit_sql(sql)
  if l = @opts[:limit]
    if l == 1
      sql << FETCH_FIRST_ROW_ONLY
    elsif l > 1
      sql << FETCH_FIRST
      literal_append(sql, l)
      sql << ROWS_ONLY
    end
  end
end
supports_window_functions? ()
[show source]
# File lib/sequel/adapters/jdbc/as400.rb, line 67
def supports_window_functions?
  true
end