db_fetchnice

After having executed the db_executenice command with an SQL statement, use this command to display the next individual data record of the result set.

Prerequisites

You have the server permission 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>]

[...]

Values for the Reply Fields
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 Database Manager CLI in session mode as the operator OLEG with the password MONDAY, and connect to the DEMODB database:

>dbmcli -u OLEG,MONDAY -d DEMODB

dbmcli on DEMODB>

Open a database session:

dbmcli on DEMODB>db_connect

OK

Display the columns of the USERS table with comments record by record:

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

...