Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » Embedded SQL


How to fetch data using embedded SQL

Fetching data in embedded SQL is done using the SELECT statement. There are two cases:

  • The SELECT statement returns at most one row   Use an INTO clause to assign the returned values directly to host variables.

  • The SELECT statement may return multiple rows   Use cursors to manage the rows of the result set.

 See also

SELECT statements that return at most one row
Cursors in embedded SQL
Wide fetches or array fetches