rs__helpconfig
@configname, -- input is wrapped in a pair of wildcard characters (%)
-- optional
-- default = '%'
@identifier, -- input is wrapped in pair of wildcard characters (%)
-- optional
-- default = '%'
@orderby -- one of { 'identifier' | 'configname' }
-- 'identifier' => 'order by Identifier, Config_Name'
-- 'configname' => 'order by Config_Name, Identifier'
-- optional
-- default = 'identifier'
rs__helpconfig
go
Identifier Config_Name Config_Value
--------------------------- -------------------------------- --------------------------
ASE200.aoh_rdb_alt dsi_command_convert none
ASE200.tgt1 dsi_command_convert none
ASE200.tgt1..da_test_tab1 dsi_command_convert none
HXE.HXE batch off
HXE.HXE db_packet_size 16384
HXE.HXE dsi_bulk_copy on
HXE.HXE dsi_connector_type odbc
HXE.HXE dsi_dataserver_make hdb
HXE.HXE dsi_proc_as_rpc on
HXE.HXE dsi_quoted_identifier on
HXE.HXE dsi_serialization_method wait_after_commit
HXE.HXE dynamic_sql on
RS200 CONFIG_OPTION_RS1571SP202_S 1
RS200 RS1571SP200_REPDEF_UPDATED 1
RS200 RS1571SP202_FUNCSTR_UPDATED 1
RS200 RS1571SP204_DDLDTMAP_UPDATED 1
... snip ...
RS200 unused_login_expiration 0
RS200 use_security_services off
RS200 use_ssl off
RS200 varchar_truncation off
RS200 ws_sqldml_replication off
rs__helpconfig @orderby='configname'
go
Identifier Config_Name Config_Value
--------------------------- -------------------------------- --------------------------
RS200 CONFIG_OPTION_RS1571SP202_S 1
RS200 RS1571SP200_REPDEF_UPDATED 1
RS200 RS1571SP202_FUNCSTR_UPDATED 1
RS200 RS1571SP204_DDLDTMAP_UPDATED 1
RS200 RS1571SP204_HIVE_UPDATED 1
RS200 RSEBF1571302_VERIFYDDL_RSSD_UP 1
RS200 audit_dest log
RS200 audit_enable off
HXE.HXE batch off
RS200 batch on
RS200 block_size 16
RS200 block_sub_for_repdef_in_pub off
RS200 byte_order 65536
RS200 cap_prs_num_threads 2
... snip ...
RS200 sts_full_cache_rs_whereclauses off
RS200 sub_daemon_sleep_time 120
RS200 sub_sqm_write_request_limit 1048576
RS200 trace
RS200 truncation_mode capture
RS200 unicode_format string
RS200 unified_login not_required
RS200 unused_login_expiration 0
RS200 use_security_services off
RS200 use_ssl off
RS200 varchar_truncation off
RS200 ws_sqldml_replication off
rs__helpconfig 'command'
go
Identifier Config_Name Config_Value
--------------------------- --------------------- ------------
ASE200.aoh_rdb_alt dsi_command_convert none
ASE200.tgt1 dsi_command_convert none
ASE200.tgt1..da_test_tab1 dsi_command_convert none
RS200 command_retry 3
RS200 dsi_command_convert none
rs__helpconfig 'command',null,'configname'
go
Identifier Config_Name Config_Value
--------------------------- --------------------- ------------
RS200 command_retry 3
ASE200.aoh_rdb_alt dsi_command_convert none
ASE200.tgt1 dsi_command_convert none
ASE200.tgt1..da_test_tab1 dsi_command_convert none
RS200 dsi_command_convert none
rs__helpconfig null,'ASE200'
go
Identifier Config_Name Config_Value
--------------------------- -------------------------------- --------------------------
ASE200.aoh_rdb_alt dsi_command_convert none
ASE200.tgt1 dsi_command_convert none
ASE200.tgt1..da_test_tab1 dsi_command_convert none
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 |