Sample SQL Server Client Configuration File

All parameters in the sample MS SQL Server client configuration file (dbridge.smp) are commented out by default. To use a parameter, delete the comment marker ( ; ) and enter a value that is appropriate for your site. Default values are provided for most parameters. Values in the [signon] and [EbcdictoAscii] sections are dummy values, so make sure you include your own values.

Note: All configuration file parameters that are Boolean can be represented by True/False.

;

; DATABridge Client version 6.1 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_date_format = mdy

bcp_packet_size = 0

max_errors = 10

max_temp_storage = 80M

verify_bulk_load = 1

[Params]

;

; (1) define/redefine command parameters

;

allow_nulls = true

check_key_changes = false

default_user_columns = 0x00000000

dflt_history_columns = 0x00000000

enable_dynamic_hist = false

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

flatten_all_occurs = false

force_aa_value_only = false

history_tables = 0

;maximum_columns = 0

min_varchar = 0

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

clr_dup_extr_recs = true

;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_dms_links = false

enable_doc_records = false

enable_optimized_sql = true

engine_workers = 0

error_display_limits = 10,100

extract_embedded = false

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

redef_all_active_ds = 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

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