<div>
<div class="content wysiwyg-content">
i was trying to see first 10 rows <br />
<br />
select &nbsp;* &nbsp;from vw_employee fetch first 10 rows<br />
<br />
plz advice<br />
<br />
DBA2191E SQL execution error.<br />
<br />
com.ibm.db.DataException: A <br />
database manager error occurred. : [IBM][CLI Driver][DB2/NT] <br />
SQL0104N &nbsp;An unexpected token &quot;END-OF-STATEMENT&quot; was found <br />
following &quot;e fetch first 0 rows&quot;. &nbsp;Expected tokens may include: <br />
&nbsp;&quot;ONLY&quot;. &nbsp;SQLSTATE=42601<br />
<br />
<br />

</div>
</div>


i was trying to see first 10 rows 

select  *  from vw_employee fetch first 10 rows

plz advice

DBA2191E SQL execution error.

com.ibm.db.DataException: A 
database manager error occurred. : [IBM][CLI Driver][DB2/NT] 
SQL0104N  An unexpected token "END-OF-STATEMENT" was found 
following "e fetch first 0 rows".  Expected tokens may include: 
 "ONLY".  SQLSTATE=42601




rownum error

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.