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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.