sql_fetchnice

Use

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 permission 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>]

[...]

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

...