Access SQL: Access to SQL Session (SAP Library

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