This keyword controls the amount of information the
CLI driver
requests on a prepare or describe request. By default, when the server
receives a describe request, it returns the information that is contained
in level 2 of
Table 1 for the result
set columns. An application, however, might not need all of this
information or might need additional information. Setting the
DescribeOutputLevel keyword
to a level that suits the needs of the client application might improve
performance because the describe data that are transferred between
the client and server is limited to the minimum amount that the application
requires. If the
DescribeOutputLevel setting
is set too low, it can affect the functionality of the application
(depending on the application's requirements). The
CLI functions
to retrieve the describe information might not fail in this case,
but the information that returned might be incomplete. Supported settings
for
DescribeOutputLevel includes following values:
- 0 - no describe information is returned to the
client application
- 1 - describe information that is categorized
in level 1 (see Table 1) is returned
to the client application
- 2 - (default) describe information that is categorized
in level 2 (see Table 1) is returned
to the client application
- 3 - describe information that is categorized
in level 3 (see Table 1) is returned
to the client application
The following table lists the fields that form the describe
information that the server returns when it receives a prepare or
describe request. These fields are grouped into levels, and the DescribeOutputLevel db2cli.ini configuration
keyword controls which levels of describe information the CLI driver
requests.