The limit clause enables the system administrator to impose an upper limit on the number of database operations performed by a single SQL query. The limit can be designated by usercode and by program name. The limit applies to any of the following databases:
-
SQL databases
-
Enterprise Database Server databases mapped to SQL
The limit applies to the specified programs or users. If no explicit limit clause is specified, the default value of UNLIMITED applies.
