Show TOC

db_fetchniceLocate this document in the navigation structure

Use

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

...

...