note 72501 added to function.db2-fetch-row

if the second parameter (the row number) is specified, your connection needs to have the CURSOR option set to DB2_SCROLLABLE. Otherwise all calls to this function will fail. Internal to the ibm_db2 extension module the db2cli api function SQLFetchScroll() generates the error "CLI0145E Fetch type out of range" since it requires a scrollable resultset to work, instead of the default forward only resultset. hope this saves someone the time it took me to track this down in the db2cli traces. Regards, Kris Dover ---- Server IP: 216.194.113.175 Probable Submitter: 65.199.207.229 ---- Manual Page -- http://www.php.net/manual/en/function.db2-fetch-row.php Edit -- https://master.php.net/note/edit/72501 Del: integrated -- https://master.php.net/note/delete/72501/integrated Del: useless -- https://master.php.net/note/delete/72501/useless Del: bad code -- https://master.php.net/note/delete/72501/bad+code Del: spam -- https://master.php.net/note/delete/72501/spam Del: non-english -- https://master.php.net/note/delete/72501/non-english Del: in docs -- https://master.php.net/note/delete/72501/in+docs Del: other reasons-- https://master.php.net/note/delete/72501 Reject -- https://master.php.net/note/reject/72501 Search -- https://master.php.net/manage/user-notes.php