[params] Parameter

Option

dbutility Command

Notes

allow_nulls

define and redefine

alpha_error_cutoff

clone and process

auto_reclone

clone and process

automate_virtuals

clone and process

aux_stmts

clone and process

This parameter applies to Oracle and SQL Server ODBC clients only.

century_break

clone and process

check_key_changes

define and redefine

check_user_scripts

clone and process

clr_dup_extr_recs

generate

commit_absn_inc

clone and process

commit_update_inc

clone and process

controlled_execution

‑o

clone and process

convert_ctrl_ char

clone and process

correct_bad_days

clone and process

create_index_suffix [n]

generate

create_table_suffix [n]

generate

default_user_columns

define and redefine

defer_fixup_phase

-c

clone

Toggle

dflt_history_columns

define and redefine

discard_data_errors

clone and process

display_active_only

-a

display

Override

display_bad_data

clone and process

eatran_dll_name

clone and process

This parameter applies to Windows.

enable_dms_links

clone and process

enable_doc_records

clone and process

enable_dynamic_hist

redefine

enable_optimized_updates

-N

clone and process

Toggle

engine_workers

clone and process

error_display_limits

clone and process

extended_exit_codes

clone and process

external_column [n]

define and redefine

extract_embedded

clone and process

flatten_all_occurs

define and redefine

global_index_suffix

generate

global_table_suffix

generate

inhibit_8_bit_data

clone and process

inhibit_console

-C

clone and process

Toggle

inhibit_ctrl_chars

clone and process

inhibit_drop_history

clone and process

keep_history_only

clone and process

Requires DSOPT_Save_
Updates

linc_century_base

clone and process

max_clone_count

-s

clone and process

DB2: You must use -s if you want to use the use_binary_aa parameter. See use_binary_AA.

max_retry_secs

process

Requires use_dbwait and works with max_wait_secs

max_wait_secs

process

Requires use_dbwait and works with max_retry_secs

maximum_columns

define and redefine

min_check_time

clone and process

min_varchar

define and redefine

months

clone and process

null_digit_value

clone and process

numeric_date_format

clone and process

n_dmsii_buffers

clone and process

n_update_threads

clone and process

optimize_updates

define and redefine

preserve_deletes

clone and process

read_null_records

define and redefine

rollback_segment

all

Oracle only

sec_tab_column_mask

define and redefine

Requires default_user_
columns

show_perf_stats

clone and process

show_statistics

-v

clone and process

Works with statistics_increment

show_table_stats

clone and process

shutdown

‑o

Override

single_line_log_msgs

clone and process

statistics_increment

-v

clone and process

Works with show_statistics

stop

stop_after_fixups

clone and process

stop_after_gc_reorg

clone and process

stop_after_given_afn

clone and process

suppress_dup_warnings

clone and process

suppress_new_columns

redefine

suppress_new_datasets

redefine

use_binary_AA

define and redefine

This parameter applies to all clients except DB2 and INFORMIX. See use_bigint (in this table).

use_bigint

define and redefine

SQL Server only

use_clob

define and redefine

Oracle only

use_clustered_index

define and redefine

This parameter applies to SQL Server. See use_decimal_aa.

use_column_prefixes

define and redefine

The tab_name_prefix column of the DATASOURCES client control table must contain an entry.

use_dbwait

-w

process

Toggle

Works with max_wait_secs and max_retry_secs

use_decimal_aa

define

use_ext_translation

clone and process

This parameter applies to Windows.

use_latest_si

clone and process

use_primary_key

define

use_varchar

define and redefine

user_script_dir

-n

define, redefine, clone and process

Override

verify_bulk_load

clone and process