Access SQL: Access to SQL Session

Operators who have been assigned the AccessSQL server authorization can execute the following DBM commands:

DBM command

Description

auto_update_statistics

Updating the optimizer statistics automatically

db_connect

Opening a database session

db_execute

Executing an administration command or an SQL statement (displaying the complete result list)

db_executenice

Executing an administration command or an SQL statement (displaying the result record-by-record)

db_fetch

Scrolling through the results of an administration command or an a database statement (displaying the list of results)

db_fetchnice

Scrolling through the results of an administration command or a database instance (displaying the list of results)

db_release

Ending a database session

sql_connect

Opening an SQL session

sql_execute

Executing an SQL statement (displaying the complete result list)

sql_executenice

Executing an SQL statement (displaying the result record-by-record)

sql_fetch

Scrolling through the results of an SQL statement (displaying the complete result list)

sql_fetchnice

Scrolling through the results of an SQL statement (displaying the result record-by-record)

sql_info

Displaying the structure of a result set

sql_recreateindex

Restoring a damaged index

sql_release

Ending an SQL session

sql_updatestat

Updating the optimizer statistics

sql_updatestat_per_systemtable

Updating the optimizer statistics as per system table SYSUPDSTATWANTED