Skip to content

[params]

See Appendix C: Client Configuration of the Databridge Client Administrator's Guide for a description of these parameters. Note that several of the relational database Client parameters do not apply to the Databridge Client for Kafka. We list these parameter below and only provide details if they are different than what is in Appendix C of the Databridge Client Adminstrator's Guide.

Define and Redefine Command Parameters

default_user_columns

Default: 0

Range: 0 -- 16383 (Some bit combinations are not allowed)

Configurator: Customizing > User Columns

The default_user_columns parameter adds non-DMSII columns (user columns) to all data sets in the client database. The Flat File Client supports more non-DMSII columns than the relational database Clients, see external_columns below for a complete list of these columns.

external_column[n]

Default: N/A

Range: N/A

Configurator: Customizing > User Columns

This parameter allows you to globally change the column name, sql_type, or sql_length of the non-DMSII columns described in Numeric Date and Time in Non-Contiguous Columns. The syntax is as follows:

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

Where Is
n The corresponding bit number (dms_subtype value) for the non-DMSII column.

NOTE:The brackets and value are require syntax.
name Custom column name
sql_type An integer value that represents the internal code for the SQL type that you want to use. The program only accepts data types that make sense or a particular column. For instance, you cannot set the AFN to a bit or a char, but you can set it to an int or a dec(10).
sql_length A value that represents the length of the data type. Specify this value only if the data type requires it. If the data type does not have a length specification, specifying a value may cause an error.

For example, the entry below causes the audit_filenum column to be renamed AFN (the double quotation marks are optional since no special characters are involved); the sql_type and sql_length remain unchanged.

external_column[5]    = "AFN"
default_user_columns  = 0x0010

In the example below, the data type of the audit_block column changed to dec(12).

external_column[6]    = ,11,12

Define and Redefine Command Unchanged Parameters

  • allow_nulls

  • automate_virtuals

  • convert_ctrl_char

  • default_user_columns

  • enable_dms_links

  • extract_embedded

  • flatten_all_occurs

  • force_aa_value_only

  • miser_database

  • read_null_records

  • sec_tab_column_mask

  • split_varfmt_dataset

  • strip_ds_prefixes

  • suppress_new_columns

  • suppress_new_datasets

  • use_binary_aa

  • use_column_prefixes

  • use_date

  • use_decimal_aa

Process and Clone Command Parameters

Process and Clone Command Unchanged Parameters

See Process and Clone Command Parameters in Appendix C: Client Configuration of the Databridge Client Administrator's Guide for details.

  • alpha_error_cutoff

  • aux_stmts

  • batch_job_period

  • century_break

  • commit_absn_inc

  • commit_idle_database

  • commit_longtrans

  • commit_time_inc

  • commit_txn_inc

  • commit_update_inc

  • convert_reversals

  • correct_bad_days

  • dbe_dflt_origin

  • defer_fixup_phase

  • discard_data_errors

  • display_bad_data

  • enable_af_stats

  • enable_doc_records

  • engine_workers

  • error_display_limits

  • inhibit_8_bit_data

  • inhibit_console

  • inhibit_ctrl_chars

  • linc_century_base

  • keep_undigits

  • max_discards

  • max_retry_secs

  • max_srv_idle_time

  • max_wait_secs

  • months

  • null_digit_value

  • numeric_data_format

  • set_blanks_to_null

  • set_lincday0_to_null

  • show_perf_stats

  • show_statistics

  • show_table_stats

  • sql_exec_timeout

  • statistics_increment

  • stop_after_fixups

  • stop_after_gc_reorg

  • stop_on_dbe_mode_chg

  • track_vfds_no links

  • use_dbwait

  • use_latest_si

Server Option Parameters

See Appendix C of the Databridge Client Administrator's Guide.

Display Command Parameters

See Appendix C of the Databridge Client Administrator's Guide.

User Scripts Parameters

See Appendix C of the Databridge Client Administrator's Guide.