38.5 adbsql subcommands

This section explains the functions and input formats of the adbsql subcommands.

Organization of this section

• 38.5.1 #CHUNKS (displays chunk information)

• 38.5.2 #COLUMNS (displays column information)

• 38.5.3 #COMMENT (specifies a comment line)

• 38.5.4 #CONNECT (connects to the HADB server)

• 38.5.5 #DISCONNECT (disconnects from the HADB server)

• 38.5.6 #EXIT (terminates the adbsql command)

• 38.5.7 #GETCOUNT (gets the number of data items stored in a chunk)

• 38.5.8 #GETDATA (gets data stored in a chunk)

• 38.5.9 #GETUSER (displays the authorization identifier)

• 38.5.10 #INDEXES (displays index information)

• 38.5.11 #SET BINARY_DISP_MODE (specifies the binary data output format)

• 38.5.12 #SET DISPLAY (outputs the retrieval results)

• 38.5.13 #SET DUMPMODE (displays the search results in hexadecimal)

• 38.5.14 #SET EXECTIME REPORT (outputs SQL statement execution time)

• 38.5.15 #SET NULL (specifies a null value display format)

• 38.5.16 #SET OPT REPORT (displays index, work table, and access path information)

• 38.5.17 #SET TRAN_ISOLV (specifies the transaction isolation level)

• 38.5.18 #TABLES (displays table information)

To Page Top