Returns a row or a set of rows from a cursor result set.


fetch cursor_name [ into fetch_target_list ]



Server Class ASEnterprise

If the cursor is read only, Component Integration Services sends a language request to the remote server when the first fetch is received after the cursor is opened. Otherwise, Component Integration Services declares a cursor to the remote server by means of Client-Library.

Server Class ASAnywhere

Server Class ASIQ

Server Class sql_server

Server Class direct_connect

Server Class db2

See also

See Also

close, deallocate cursor, declare cursor, open in this chapter.

fetch in the Adaptive Server Reference Manual.