Description

LOCAL
Defines the scope of the name of the descriptor to be local to the program invocation. The descriptor will not be known outside this scope. For example, a program called from another separately compiled program cannot use a descriptor that was allocated by the calling program. The scope of the descriptor is also limited to the thread in which the program that contains the descriptor is running. For example, if the same program is running in two separate threads in the same job, the second thread cannot use a descriptor that was allocated by the first thread.
GLOBAL
Defines the scope of the name of the descriptor to be global to the SQL session. The descriptor will be known to any program that executes using the same database connection.
SQL-descriptor-name
Names the descriptor to allocate. The name must not be the same as a descriptor that already exists with the specified scope.
WITH MAX
The descriptor is allocated to support the specified maximum number of items. If this clause is not specified, the descriptor is allocated with a maximum of 20 items.
integer
Specifies the number of items to allocate. The value of integer must be greater than zero and not greater than 8000.
integer-variable
Specifies an integer variable (or decimal or numeric variable with zero scale) that contains the number of items to allocate. The value of integer-variable must be greater than zero and not greater than 8000.