you need a "with" before the fetch.
Good Luck!
Christi Fortier,MSAS,Certified DB2 DBA, Sybase DBA
DB Specialist(Admin/Architect/Performance/N-Tier/Web)
PO Box 6012, Lawrenceville, NJ 08648-0012
Phone: 609-912-0620
e: [EMAIL PROTECTED]
Fax: pending
URL: http://www.precise2spec.com/CRDB
---------- Original Message ----------------------------------
From: "Amir Sadeghi" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 06 Apr 2001 23:20:40
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
