sql_fetchnice 
You use this DBM command after executing sql_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: sql_executenice). The keyword CONTINUE in the reply shows that the data has not yet been completely retrieved.
Structure
sql_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> | Column name |
<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, display the columns of the USERS table one-by-one with comments:
>dbmcli -u OLEG,MONDAY -d DEMODB
dbmcli on DEMODB>sql_executenice SELECT columnname, comment FROM domain.columns WHERE tablename = 'USERS'
OK
CONTINUE
COLUMNNAME = 'OWNER'
COMMENT = (LOB)
---
dbmcli on demodb>sql_fetchnice
OK
CONTINUE
COLUMNNAME = 'GROUPNAME'
COMMENT = (LOB)
---
dbmcli on demodb>sql_fetchnice
...
...
More Information
Database Manager CLI Tutorial, Executing a Succession of Database Statements