Sample SQL Server Client Configuration File

You can view the configuration file for SQL Server by using the Export command. See Export or Import a Configuration File.

To use a parameter that is commented out, delete the semi-colon ( ; ) and after the equals sign (=), enter a value that is appropriate for your site. Boolean parameters can be represented by True or False.

In the example below, some of the commented-out parameters have a value of -1. These parameters include the DBEngine control file parameters that can be overridden by the client (commit frequency parameters and engine workers). This value indicates that the corresponding parameter in the DATABridge Engine (or Server) control file will not be overridden by the Client. Do not uncomment these lines, unless you want to supply an actual value. Otherwise, the Client will issue an error.

;

; DATABridge Client version 6.2 SQL Server configuration file -- generated programmatically

;

[Signon]

;user = USERID

;password = PASSWORD

;datasource = DATASOURCE

use_nt_authen = false

;hostpasswd = HOSTPASSWD

[Log_File]

file_name_prefix = "db"

;max_file_size = 0

logsw_on_size = false

logsw_on_newday = false

newfile_on_newday = true

single_line_log_msgs = false

[Trace_File]

file_name_prefix = "trace"

;max_file_size = 0

[Bulk_Loader]

bcp_batch_size = 100000

;bcp_code_page = <code_page>

;bcp_copied_msg = "rows copied."

bcp_packet_size = 0

max_errors = 10

max_temp_storage = 40M

verify_bulk_load = 1

[Params]

;

; (1) define/redefine command parameters

;

allow_nulls = true

check_key_changes = false

clr_dup_extr_recs = true

default_user_columns = 0x00000000

dflt_history_columns = 0x00000000

enable_dynamic_hist = false

enable_dms_links = false

;external_column[n] = ["name"][,[sql_type][,[sql_length][,"default"]]]

extract_embedded = false

flatten_all_occurs = false

force_aa_value_only = 0

history_tables = 0

;maximum_columns = 0

min_varchar = 0

miser_database = false

optimize_col_updates = false

optimize_updates = false

read_null_records = true

sec_tab_column_mask = 0x00000000

split_varfmt_dataset = false

suppress_new_columns = false

suppress_new_datasets = true

use_bigint = false

use_binary_aa = false

use_clustered_index = false

use_column_prefixes = false

use_date = false

use_datetime2 = false

use_decimal_aa = false

use_nullable_dates = false

use_primary_key = false

use_time = false

use_varchar = false

;

; (2) process/clone command parameters

;

alpha_error_cutoff = 10

auto_reclone = false

automate_virtuals = false

aux_stmts = 25

century_break = 50

;commit_absn_inc = -1

;commit_longtrans = -1

;commit_time_inc = -1

;commit_txn_inc = -1

;commit_update_inc = -1

controlled_execution = false

convert_ctrl_char = false

correct_bad_days = false

dbe_dflt_origin = direct

defer_fixup_phase = false

discard_data_errors = false

display_bad_data = false

enable_doc_records = false

enable_optimized_col = false

enable_optimized_sql = true

;engine_workers = -1

error_display_limits = 10,100

inhibit_8_bit_data = false

inhibit_console = false

inhibit_ctrl_chars = false

inhibit_drop_history = false

linc_century_base = 1957

max_clone_count = 500

max_retry_secs = 600

max_wait_secs = 3600

min_check_time = 600

n_dmsii_buffers = 0

n_update_threads = 0

null_digit_value = 9

numeric_date_format = 23

preserve_deletes = false

show_perf_stats = true

show_statistics = true

show_table_stats = false

statistics_increment = 100000,10000

stop_after_fixups = false

stop_after_gc_reorg = false

stop_after_given_afn = false

suppress_dup_warnings = false

track_vfds_nolinks = true

use_ctrl_tab_sp = true

use_dbwait = false

use_latest_si = false

;

; (3) Server options

;

;shutdown {until | for} hh:mm after stop

;stop {before | after} task "name"

;stop {before | after} time hh:mm[:ss]

;

; (4) generate command parameters

;

;global_table_suffix = "str"

;create_table_suffix[n] = "str"

;global_index_suffix = "str"

;create_index_suffix[n] = "str"

;

; (5) miscellaneous command parameters

;

display_active_only = true

;

; (6) user scripts

;

user_script_bu_dir = ""

user_script_dir = "scripts"

[Scheduling]

;

; dbutility process command only

;

;daily = 08:00, 12:00, 17:00, 24:00

;exit_on_error = false

;sched_delay_secs = 600

;sched_minwait_secs = 3600

;sched_retry_secs = 3600

[EbcdicToAscii]

; e1 = a1

; e2 = a2

; ...

; en = an

;

[DBConfig]

default_date_fmt = 21