Re: SQL Statement

["Paul Morgan" <pmorgan@xxxxxxxxxxxxxx>]

Paul,

Check the SQL reference manual for the SELECT statement.  A SELECT statement
can only be run interactively.  A SELECT INTO statement can only be run
embedded in an application program.  Because the SELECT statement is being
placed into a stored procedure it's not running interactively.  You need to
modify the SELECT to either place it's results into variables (using the
SELECT INTO format the error message refers to) or convert it to an INSERT
statement so that it's results get placed in another table.

Not a guru,
Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333

Paul Nelson wrote

> Any SQL gurus out there? The statement below generates the following
> message when the user tries to compile it as a stored procedure. I'm at a
> loss
>
> MSG ID  SEV  RECORD  TEXT
> SQL0029  30      65  Position 10 INTO clause missing from embedded
> statement.
>
> TIA
>
> Paul Nelson
> Arbor Solutions, Inc.
> 708-670-6978  Cell