Sample Oracle Client Configuration File

;

; DATABridge Client version 6.2 Oracle configuration file -- generated programmatically

;

[Signon]

;user = USERID

;password = PASSWORD

;database = DATABASE

;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_code_page = <code_page>

bcp_decimal_char = "."

bcp_delim = ","

enable_parallel_mode = false

inhibit_direct_mode = false

max_errors = 10

max_temp_storage = 40M

sqlld_bindsize = 65536

sqlld_rows = 100

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

enable_dynamic_hist = 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_binary_aa = false

use_clob = false

use_column_prefixes = false

use_decimal_aa = false

use_nullable_dates = false

use_primary_key = false

use_varchar = true

;

; (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_sql = true

enable_optimized_col = false

;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_discards = 0,100

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

;rollback_segment_name = ""

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