Steps
|
SA Function(s)
|
Comment
|
---|---|---|
1. Create a cursor
|
SaCursorCreate
|
|
2. Bind variables to cursor
|
SaCursorColInt, SACursorColStr and others for other data types
|
|
3. Open the cursor
|
SaCursorOpen
|
|
4. Set the search constraint for the row to be queried
|
SaCursorEqual, SaCursorAtleast, SaCursorAtmost
|
|
5. Start a search for the row to be queried
|
SaCursorSearch
|
|
6. Fetch the row(s) that match the given criteria
|
SaCursorNext
|
Perform this in a loop if necessary
|
7. Free the cursor
|
SaCursorFree
|
|