db_fetchnice 
You use this DBM command after executing db_executenice to display the next data record of the result in the same database session.
Prerequisites
You have the server authorization AccessSQL.
You have executed an SQL statement (see: db_executenice). The keyword CONTINUE in the reply shows that the data has not yet been completely retrieved.
Structure
db_fetchnice
Result
OK
[END | CONTINUE]
[<column>=<value>]
[<column>=<value>]
[...]
Value | Description |
|---|---|
END | The reply was transferred in full. |
CONTINUE | More data records are available but were not transferred due to the limited size of the reply package. |
<column> | Name of column |
<value> | Column value |
Example
Log on to the Database Manager CLI in session mode as operator OLEG with password MONDAY, connect to the database instance DEMODB
>dbmcli -u OLEG,MONDAY -d DEMODB
dbmcli on DEMODB>
Opening a database session
dbmcli on DEMODB>db_connect
OK
Record-by-record display of the columns of the USERS table with comments:
dbmcli on DEMODB>db_executenice SELECT columnname, comment FROM domain.columns WHERE tablename = 'USERS'
OK
CONTINUE
COLUMNNAME = 'OWNER'
COMMENT = (LOB)
---
dbmcli on demodb>db_fetchnice
OK
CONTINUE
COLUMNNAME = 'GROUPNAME'
COMMENT = (LOB)
---
dbmcli on demodb>db_fetchnice
...
...
More Information
Database Manager CLI Tutorial, Executing a Succession of Database Statements