GET DIAGNOSTICS to get the row count should be after the FETCH and not after the DECLARE CURSOR should it not?
And also, have you checked the sqlstate immediately following the FETCH? An sqlstate other than '00000' may indicate an error in your cursor declaration.
Rob
Search found 1 match
- Thu Oct 28, 2021 12:02 pm
- Forum: RPG IV
- Topic: Product Srch Locs table using RPGSQL loading Array
- Replies: 4
- Views: 24165