Christi,
I am not sure if 'WITH' before 'FETCH' is a valid syntax. I had never seen
it before and I just tried it. It gave me a syntax error.
Any ideas?
>From: "Christi Fortier " <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: DB2EUG: INSERT with SELECT FIRST n ROWS ONLY
>Date: Sat, 7 Apr 2001 09:29:29 -0400
>
>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
>
_________________________________________________________________________
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
