OWB - Constant Operator

Card Puncher Data Processing


The Constant operator enables you to define constant values in any:

  • PL/SQL
  • or ABAP mapping.
  • but for SQL*Loader mappings, to introduce constants or sequences, use a data generator operator instead.

Properties of a field

  • Expression. Full in the value of the constant.
  • Is predefined constant. If this check box is checked, the constant is inserted direct in the SQL statement and not handle by a function.

It's really useful with sysdate, strings, numbers and fixed dates. It's for performance improvement in large row counts.

sysdate nasty side effects : sysdate comes from a plsql constant it will have the same sysdate for all rows, whereas you use it directly in the insert statement but it can differ, especially when inserting loads of rows

Constant Operator

Documentation / Reference

Discover More
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...

Share this page:
Follow us:
Task Runner