Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Description

Parameter Position

Position of this parameter within a list of parameters.

Anchor
Parameter Mode
Parameter Mode
Parameter Mode

Mode of this parameter.
 
Options:

  • Input
  • Output
  • Input/Output

Parameter Type

Type of parameter.
 
Options:

  • NUMERIC
  • DECIMAL
  • INTEGER
  • SMALLINT
  • FLOAT
  • REAL
  • DOUBLE
  • VARCHAR
  • BOOLEAN
  • DATE
Note

The Input for date expects a real value entered in the format below.  

  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm
  • yyyy-MM-dd HH:mm:ss
  • yyyy-MM-dd HH:mm Z
  • yyyy-MM-dd HH:mm:ss Z
  • yyyy-MM-dd HH:mm:ss.SSS
  • yyyy-MM-dd HH:mm:ss.SSS Z

Variables are supported as well.


  • TIME
  • TIMESTAMP
  • BIGINT
  • VARBINARY

Value is Null

If Parameter Mode = Input or Input/Output; Value for the parameter is a database NULL value; applies to the input part of a stored procedure parameter. That is, if a value in a database is undefined, it is NULL, which means it has no set value. An input value can be NULL and is represented by selecting Value is Null.

Input Value

If Parameter Mode = Input or Input/Output; Input value of the parameter (up to a maximum of 4000 characters), if any.

Description

Description of this parameter.

Variable Scope

If Parameter Mode = Output or Input/Output; applies to parameters associated with a task in a workflow. Scope of the variable to assign the Output value.
 
Options:

  • Self
  • Parent
  • Top Level Parent
  • Global

Variable Name

If Parameter Mode = Output or Input/Output; name of variable to assign the Output value.

...