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 alsoSELECT statements that return at most one row
Cursors in embedded SQL
Wide fetches or array fetches
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |