Create Function: Parameters panel
You use the Create Function: Parameters panel to define parameters for the function.
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.
Parent panels
Child panels
None.