Create Function: Parameters panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                 
 FM/Db2 (DFG2)             Create Function Parameters           Row 1 to 1 of 1
                       <---(For Built in Data Types)----->
 C                                             <DEC>
 M                                            <FL>   For   User Defined
 D  Parameter Name   + Data Type       + Len   Pr Sc Data  Data Type          +
    NAME               CHAR              20       
                        
 ******************************* Bottom of data ************************










 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Cmd

This field is used for entering commands.

Parameter Name

As defined using option 1.

Data Type

This field is used for entering the data type for the column being defined.

Len

This field is (optionally) used for entering the length, and optionally the scale of the column. The numeric fields such as INTEGER, REAL, no length specification is required. For character fields, only a single length specification is required. For decimal fields, you can specify a length and a scale.

DEC

For a decimal number. The first integer is the precision number. That is, the total number of digits which can range from 1 to 31. The second integer is the scale of the number. That is the number of digits to the right of the decimal point, which can range from 0 to the precision of the number.

FL

For a floating-point number. If integer is between 1 and 21 inclusive, the format is single precision floating-point. If the integer is between 22 and 53 inclusive, the format is double precision floating-point.

Pr Sc

The scale is the total number of digits in the fractional part of the number and the precision is the total number of digits in the number.

For Data

The definitions for character and character large object (CLOB) allow the specification of an optional 'FOR DATA' clause. This field is used to specify the appropriate value.

User Defined Data Type

Specifies the data type of the column is a distinct type (a user defined-data type). The length, precision and scale of the column are respectively the length, precision and scale of the source type of the distinct type. The privilege set must implicitly or explicitly include the USAGE privilege on the distinct type.