Background documentationsql_fetch Locate this document in the navigation structure

 

You use this DBM command after executing sql_execute to display more result data in the same database session.

Prerequisites

  • You have the server authorization AccessSQL.

  • You have executed an SQL statement (see: sql_execute). The keyword CONTINUE in the reply indicates that the results data has not yet been displayed completely.

Structure

sql_fetch

Result

OK

[END|CONTINUE]

[<record>

<record>

...]

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.

<record>

Result data of the SQL statements

The fields in a data record are separated by semicolons. Character strings are output in single quotation marks.

More Information

Database Manager CLI Tutorial, Executing a Succession of Database Statements