select question

This is a multi-part message in MIME format. ------=_NextPart_000_0018_01BF1F16.E74D2F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to select "x" number of rows according to specified = parameters in dbaccess? Thanks in advance, Michele ------=_NextPart_000_0018_01BF1F16.E74D2F00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>Is it possible to select = &quot;x&quot; number of=20 rows according to specified parameters</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>in dbaccess?</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Thanks in advance,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Michele</FONT></DIV></BODY></HTML> ------=_NextPart_000_0018_01BF1F16.E74D2F00--

Yes, if you mean something like this dbaccess testdb << eo_db set isolation to dirty read; select first $1 * from test;eo_db > > Is it possible to select "x" number of rows according to specified = > parameters > in dbaccess? > Thanks in advance, > Michele >

1: Please do not post HTML, adjust your browser's mailer to send text only. 2: You did not specify what version of Informix you are using. IFF you have 7.3x you can use the FIRST <N> clause to limit the query to N rows: SELECT FIRST 12 col1, col2, ........ Art S. Kagel Michele Orcutt wrote: > Is it possible to select "x" number of rows according to specified = > parameters > in dbaccess? > Thanks in advance, > Michele