Module: Sequel::DB2::DatasetMethods

Includes:
Sequel::Dataset::ColumnsLimit1, EmulateOffsetWithRowNumber
Included in:
IBMDB::Dataset
Defined in:
lib/sequel/adapters/shared/db2.rb

Constant Summary collapse

BITWISE_METHOD_MAP = 
{:& =>:BITAND, :| => :BITOR, :^ => :BITXOR, :'B~'=>:BITNOT}.freeze

Constants included from Sequel::Dataset::ColumnsLimit1

Sequel::Dataset::ColumnsLimit1::COLUMNS_CLONE_OPTIONS

Instance Method Summary collapse

Methods included from Sequel::Dataset::ColumnsLimit1

#columns!

Methods included from EmulateOffsetWithRowNumber

#empty?, #select_sql, #supports_offsets_in_correlated_subqueries?

Instance Method Details

#cast_sql_append(sql, expr, type) ⇒ Object

DB2 casts strings using RTRIM and CHAR instead of VARCHAR.



282
283
284
285
286
287
288
289
290
 
# File 'lib/sequel/adapters/shared/db2.rb', line 282

def cast_sql_append(sql, expr, type)
  if(type == String)
    sql << "RTRIM(CHAR("
    literal_append(sql, expr)
    sql << "))"
  else
    super
  end
end

#complex_expression_sql_append(sql, op, args) ⇒ Object 



292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
 
# File 'lib/sequel/adapters/shared/db2.rb', line 292

def complex_expression_sql_append(sql, op, args)
  case op
  when :&, :|, :^, :%, :<<, :>>
    complex_expression_emulate_append(sql, op, args)
  when :'B~'
    literal_append(sql, SQL::Function.new(:BITNOT, *args))
  when :extract
    sql << args[0].to_s
    sql << '('
    literal_append(sql, args[1])
    sql << ')'
  else
    super
  end
end

#quote_identifiers? ⇒ Boolean

Returns:

  • (Boolean) 


308
309
310
 
# File 'lib/sequel/adapters/shared/db2.rb', line 308

def quote_identifiers?
  @opts.fetch(:quote_identifiers, false)
end

#supports_cte?(type = :select) ⇒ Boolean

Returns:

  • (Boolean) 


312
313
314
 
# File 'lib/sequel/adapters/shared/db2.rb', line 312

def supports_cte?(type=:select)
  type == :select
end

#supports_group_cube? ⇒ Boolean

DB2 supports GROUP BY CUBE

Returns:

  • (Boolean) 


317
318
319
 
# File 'lib/sequel/adapters/shared/db2.rb', line 317

def supports_group_cube?
  true
end

#supports_group_rollup? ⇒ Boolean

DB2 supports GROUP BY ROLLUP

Returns:

  • (Boolean) 


322
323
324
 
# File 'lib/sequel/adapters/shared/db2.rb', line 322

def supports_group_rollup?
  true
end

#supports_grouping_sets? ⇒ Boolean

DB2 supports GROUPING SETS

Returns:

  • (Boolean) 


327
328
329
 
# File 'lib/sequel/adapters/shared/db2.rb', line 327

def supports_grouping_sets?
  true
end

#supports_is_true? ⇒ Boolean

DB2 does not support IS TRUE.

Returns:

  • (Boolean) 


332
333
334
 
# File 'lib/sequel/adapters/shared/db2.rb', line 332

def supports_is_true?
  false
end

#supports_lateral_subqueries? ⇒ Boolean

DB2 supports lateral subqueries

Returns:

  • (Boolean) 


337
338
339
 
# File 'lib/sequel/adapters/shared/db2.rb', line 337

def supports_lateral_subqueries?
  true
end

#supports_merge? ⇒ Boolean

DB2 supports MERGE

Returns:

  • (Boolean) 


342
343
344
 
# File 'lib/sequel/adapters/shared/db2.rb', line 342

def supports_merge?
  true
end

#supports_multiple_column_in? ⇒ Boolean

DB2 does not support multiple columns in IN.

Returns:

  • (Boolean) 


347
348
349
 
# File 'lib/sequel/adapters/shared/db2.rb', line 347

def supports_multiple_column_in?
  false
end

#supports_select_all_and_column? ⇒ Boolean

DB2 only allows * in SELECT if it is the only thing being selected.

Returns:

  • (Boolean) 


352
353
354
 
# File 'lib/sequel/adapters/shared/db2.rb', line 352

def supports_select_all_and_column?
  false
end

#supports_where_true? ⇒ Boolean

DB2 does not support WHERE 1.

Returns:

  • (Boolean) 


362
363
364
 
# File 'lib/sequel/adapters/shared/db2.rb', line 362

def supports_where_true?
  false
end

#supports_window_functions? ⇒ Boolean

DB2 supports window functions

Returns:

  • (Boolean) 


357
358
359
 
# File 'lib/sequel/adapters/shared/db2.rb', line 357

def supports_window_functions?
  true
end