Other Commands Accessing the Database Instance Using SQL

Commands for Experts

DBM Command

Description

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 SQL statement (displaying the complete result list)

db_fetchnice

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

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_release

Ending an SQL session