Hi Team,

I would like to perform the following statement to insert some rows into a 
test table. DB2 is giving me a syntax error complaining about 'SQL0104N  An 
unexpected token "fetch" was found following "from"


"insert into test select empl_num from incschem.employee fetch first 10 rows 
only"


Does anyone know why this syntax is not allowed?
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod

Reply via email to