%ISOPEN - To check whether cursor is open or not

% ROWCOUNT - Number of rows fetched/updated/deleted.

% FOUND - To check whether cursor has fetched any row. True if rows are fetched.

% NOT FOUND - To check whether cursor has fetched any row. True if no rows are featched.

These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.