Re: SQL Statement

[Donald Whittaker <donald_whittaker@xxxxxxxxx>]

   Did they want this to return a result set?  If so,
you might want to look at SG24-6503-01 (the Redbook
"Stored Procedures, Trigger, and User Defined
Functions").  There is a section on returning result
sets from SQL stored procedures.

Also not a guru,
Don 

--- pnelson@xxxxxxxxxx wrote:
> 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.
> 
> 
> -- 
> 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.
> 
> 


                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/