db_fetchnice

Use

You use this DBM command after executing db_executeniceto display the next data record of the result in the same database session.

See also:

Database Administration Tutorial, Executing a Succession of Database Statements

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

Syntax

db_fetchnice

Reply

OK

[END | CONTINUE]

[<column>=<value>]

[<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 the Database Manager CLI in session mode as operator OLEG with the password MONDAY, connect to the DEMODB database instance, open a database session, display the columns of the USERS table with the relevant comments one by one:

>dbmcli -u OLEG,MONDAY -d DEMODB

>dbmcli on DEMODB>db_connect

OK

dbmcli on DEMODB>db_executenice SELECT columnname, comment FROM domain.columns WHERE tablename = 'USERS'

OK

CONTINUE

COLUMNNAME                     = 'OWNER'

COMMENT                        = (long)

---

dbmcli on demodb>db_fetchnice

OK

CONTINUE

COLUMNNAME                     = 'GROUPNAME'

COMMENT                        = (long)

---

dbmcli on demodb>db_fetchnice

...

...