Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

SYSTEM-LIMITS

This statement specifies limit values.

Definition

Higher-level DBH option

Function

SYSTEM-LIMITS is the higher-level option of all DBH options with which you can specify limit values for the DBH session.

SYSTEM-LIMITS

= *STD / *PARAMETERS


*PARAMETERS(...)



|

COLUMNS = 256



|

,SQL-SUPPORT = *YES(...)



|

,SUBORDERS = *STD



|

,SYSTEM-THREADS = *STD



|

,THREADS = 1



|

,USERS = *STD



|

,SQL-DATABASE-CATALOG = 1



|

,OLD-TABLE-CATALOG = 0



|

,SPACES = *STD

Operands

SYSTEM-LIMITS = *STD

Default values apply to all the operands of SYSTEM-LIMITS. They are described under the relevant lower-level DBH options.

SYSTEM-LIMITS = *PARAMETERS(...)
The various operands of SYSTEM-LIMITS are DBH options. Their operands are described under the relevant DBH options.