DQPARSERESLIMIT Function

Sets a limit on resources consumed during parsing.

Valid in: DATA step, PROC SQL, and SCL

Syntax

DQPARSERESLIMIT('resource-limit')

Required Argument

resource limit

specifies the resource limit a parsing operation is allowed to consume.

Details

The DQPARSERESLIMIT function sets the level of resource consumption in force during parsing operations. If REMOVE is specified, the override value is removed and the resource limit is set to the default value. Valid values are as follows:
  • VERYLOW
  • LOW
  • MEDIUM
  • HIGH
  • VERYHIGH
  • INTENSIVE
  • REMOVE
The DQPARSERESLIMIT function returns a value that indicates the previous value of the resource limit. If the value NOTSET is returned, the override value is not set. Possible return values are as follows:
  • VERYLOW
  • LOW
  • MEDIUM
  • HIGH
  • VERYHIGH
  • INTENSIVE
  • NOTSET

Example: DQPARSERESLIMIT Function

The following example sets the default resource limit to INTENSIVE. The value of oldDEFAULT is the previous value of the resource limit.
oldDefault=DQPARSERESLIMIT('intensive');