×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/02/2018
11:51:25 AM:
Does anybody know how to display real values used by the system and
retrieved from file QAQQINI? I also need to know all valid values for
this file.
This is one way. Just have to convert hex to decimal as needed.
DSPPFM
F10
F11
Some may have been added, but the following is the list I have.
ALLOW_ADAPTIVE_QUERY_PROCESSING
ALLOW_ARRAY_VALUE_CHANGES
ALLOW_TEMPORARY_INDEXES
APPLY_REMOTE
ASYNC_JOB_USAGE
CACHE_RESULTS
COLLATE_ERRORS
COMMITMENT_CONTROL_LOCK_LIMIT
FIELDPROC_ENCODED_COMPARISON
FORCE_JOIN_ORDER
IGNORE_LIKE_REDUNDANT_SHIFTS
LIMIT_PREDICATE_OPTIMIZATION
LOB_LOCATOR_THRESHOLD
MATERIALIZED_QUERY_TABLE_REFRESH_AGE
MATERIALIZED_QUERY_TABLE_USAGE
MEMORY_POOL_PREFERENCE
MESSAGES_DEBUG
MESSAGES_DESTINATION
MESSAGES_FINAL_PLAN
MESSAGES_INFORMATIONAL
NORMALIZE_DATA
OPEN_CURSOR_CLOSE_COUNT
OPEN_CURSOR_THRESHOLD
OPTIMIZATION_GOAL
OPTIMIZE_STATISTIC_LIMITATION
PARALLEL_DEGREE
PARAMETER_MARKER_CONVERSION
QUERY_INSTRUMENTATION
QUERY_TIME_LIMIT
QUERY_TREE_DUMP
QUERY_TREE_DUMP_AT
REOPTIMIZE_ACCESS_PLAN
SQL_CONCURRENT_ACCESS_RESOLUTION
SQL_DECFLOAT_WARNINGS
SQL_FAST_DELETE_ROW_COUNT
SQL_MODIFIES_SQL_DATA
SQL_PSEUDO_CLOSE
SQL_STMT_COMPRESS_MAX
SQL_STMT_REUSE
SQL_SUPPRESS_WARNINGS
SQL_TRANSLATE_ASCII_TO_JOB
SQL_XML_DATA_CCSID
SQLSTANDARDS_MIXED_CONSTANT
STAR_JOIN
STORAGE_LIMIT
SYSTEM_SQL_STATEMENT_CACHE
TEXT_SEARCH_DEFAULT_TIMEZONE
UDF_TIME_OUT
VARIABLE_LENGTH_OPTIMIZATION
Sincerely,
Dave Clark
midrange.com
