DB2_FETCH_ROW(3)							 1							  DB2_FETCH_ROW(3)

db2_fetch_row - Sets the result set pointer to the next row or requested row

SYNOPSIS

       bool db2_fetch_row (resource  $stmt, [int  $row_number])

DESCRIPTION

	Use db2_fetch_row(3) to iterate through a result set, or to point to a specific row in a result set if you requested a scrollable cursor.

	To retrieve individual fields from the result set, call the db2_result(3) function.

	Rather	than  calling  db2_fetch_row(3)  and  db2_result(3),  most applications will call one of db2_fetch_assoc(3), db2_fetch_both(3), or
       db2_fetch_array(3) to advance the result set pointer and return a complete row as an array.

PARAMETERS

	      o $stmt
		- A valid stmt resource.

	      o $row_number
		- With scrollable cursors, you can request a specific row number in the result set. Row numbering is 1-indexed.

RETURN VALUES

	Returns TRUE if the requested row exists in the result set. Returns FALSE if the requested row does not exist in the result set.

EXAMPLES

       Example #1

	      Iterating through a result set

	       The following example demonstrates how to iterate through a result set with db2_fetch_row(3) and retrieve columns from  the  result
	      set with db2_result(3).

	      <?php
	      $sql = 'SELECT name, breed FROM animals WHERE weight < ?';
	      $stmt = db2_prepare($conn, $sql);
	      db2_execute($stmt, array(10));
	      while (db2_fetch_row($stmt)) {
		  $name = db2_result($stmt, 0);
		  $breed = db2_result($stmt, 1);
		  print "$name $breed";
	      }
	      ?>

	      The above example will output:

	      cat Pook
	      gold fish Bubbles
	      budgerigar Gizmo
	      goat Rickety Ride

       Example #2

	      i5/OS recommended alternatives to db2_fetch_row/db2_result

	       On    i5/OS   it   is   recommended   that   you   use	db2_fetch_both(3),   db2_fetch_array(3),   or	db2_fetch_object(3)   over
	      db2_fetch_row(3)/db2_result(3). In general db2_fetch_row(3)/db2_result(3) have more issues with various column types in  EBCIDIC	to
	      ASCII  translation,  including  possible	truncation  in	DBCS applications. You may also find the performance of db2_fetch_both(3),
	      db2_fetch_array(3), and db2_fetch_object(3) to be superior to db2_fetch_row(3)/db2_result(3).

	      <?php
		$conn = db2_connect("","","");
		$sql = 'SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE, ROUTINE_CREATED, ROUTINE_BODY, IN_PARMS, OUT_PARMS, INOUT_PARMS, PARAMETER_STYLE, EXTERNAL_NAME, EXTERNAL_LANGUAGE FROM QSYS2.SYSROUTINES FETCH FIRST 2 ROWS ONLY';
		$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
		while ($row = db2_fetch_both($stmt)){
		  echo "<br>db2_fetch_both {$row['SPECIFIC_NAME']} {$row['ROUTINE_CREATED']} {$row[5]}";
		}
		$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
		while ($row = db2_fetch_array($stmt)){
		  echo "<br>db2_fetch_array {$row[1]}  {$row[5]}";
		}
		$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
		while ($row = db2_fetch_object($stmt)){
		  echo "<br>db2_fetch_object {$row->SPECIFIC_NAME} {$row->ROUTINE_CREATED}";
		}
		db2_close($conn);
	      ?>

	      The above example will output:

	      db2_fetch_both MATCH_ANIMAL 2006-08-25-17.10.23.775000 2006-08-25-17.10.23.775000
	      db2_fetch_both MULTIRESULTS 2006-10-17-10.11.05.308000 2006-10-17-10.11.05.308000
	      db2_fetch_array MATCH_ANIMAL 2006-08-25-17.10.23.775000
	      db2_fetch_array MULTIRESULTS 2006-10-17-10.11.05.308000
	      db2_fetch_object MATCH_ANIMAL 2006-08-25-17.10.23.775000
	      db2_fetch_object MULTIRESULTS 2006-10-17-10.11.05.308000

SEE ALSO

       db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_result(3).

PHP Documentation Group 													  DB2_FETCH_ROW(3)