Re: SQL Statement

Thanks, but he's not trying to create a new table, just retrieve data from 
the 400.


Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





"Paul Morgan" <pmorgan@xxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/22/2005 10:09 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     midrange-l@xxxxxxxxxxxx
        cc: 
        Subject:        Re: SQL Statement


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



-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.