String
programType, in Class DB2Routine
Documentation
For OS/390 v6 and v7, both UDFs and SPs
<p>
From DB2 OS390 v7 SQL Reference:
<DL>
<DT>SUB
<DD>The stored procedure runs as a subroutine.
<DT>MAIN
<DD>The stored procedure runs as a main routine.
</DL>
<p>
The stored procedure runs as a main routine.
The default for PROGRAM TYPE depends on the value of special register
CURRENT RULES. The default is:
<ul>
<li>MAIN when the value is DB2
<li>SUB when the value is STD
</ul>
Export Control | PublicAccess | Containment | Unspecified |
Static | No | Derived | No |
Property Settings
Data Modeler
dmItem | False | DMName | |
Ordinal | 0 | IsIdentity | False |
IsUnique | False | NullsAllowed | False |
Length | 0 | Scale | 0 |
ColumnType | Native | ForBitData | False |
DefaultValueType | | DefaultValue | |
SourceId | | SourceType | |
OID | False | | |