Friday, June 19, 2009

(Tutorial : SQL) Selecting & Processing Multiple Rows

Steps to access multiple rows:

1. Declare cursor
2. Open cursor
3. Fetch a row (record)
4. Process row (UPDATE, INSERT, etc)
5. IF last row: go to Step 6,
ELSE go to Step 3
6. Close cursor

You Might Also Want To Visit The Following Tutorial Posts:
AS/400 For Dummies
AS/400 Tutorial
SQL/400 Tutorial
Query/400 Tutorial

No comments:

Post a Comment