sql "LIMIT"  
Post Reply   Forum
Posted by: Hugo Hernandez
Thu, Jan 10, 2002, 07:21:54

I am implementing following query SQL in as400 V4R4:

"SELECT names, registry, character FROM libreria.tabla WHERE sigla='$siglá AND seccion=$seccion LIMIT 10 ORDER BY names"

which throw an error to me with respect to which predicate "LIMIT" does not exist.

I have looked for much, but I haven't had luck.

any idea?


ps: I am working with on linux machine and DB2 CONNECT to access AS/400 DB.

Post Reply | Email Friend | Alert View All   Current page