There are several levels of settings to deal with in Sybase IQ:
1) Server command line parameters (e.g. memory settings, threads, monitoring, log file)
2) Server level settings (e.g. compression, date formatting, quotas/limits, parallelism )
3) DBISQL options (show multiple result sets, display options, error handling)
4) Connection level settings ( integer overflow, ansi settings )
# List global settings
set
# List a single DB property
select db_property ( 'PageSize' ) ;
# List all DB properties
sa_db_properties ;
# Connection property / detail
select connection_property ( 'allow_nulls_by_default' ) ;
sa_conn_properties ;
|
|