Re: Simple report pgm using embedded SQL

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

Hi Michael,

What do you want the program to do?  I mean, why not just write a QM 
query or an OS400 query?

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

MKirkpatrick@xxxxxxxxxxxxxxxxx wrote:
> My apologies, perhaps I should have been more specific.  I want to PRINT a 
> report just listing data in a file.  Thanks.
>
> Michael Kirkpatrick
> Western Dental Services, Inc.
> Information Systems / System i Development
> (
> Phone:
>  (714) 571.3582
> (
> Toll free:
>  (800) 471.4444
> 7
> Fax:
>  (714) 480.3001
> *
> Email:
>  mkirkpatrick@xxxxxxxxxxxxxxxxx
> 8
> Web:
>  http://www.westerndental.com/
>
>  
>
>
>
> GUY_HENZA@xxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 11/05/2007 09:28 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
>
> Subject
> Re: Simple report pgm using embedded SQL
>
>
>
>
>
>
>
> Another example;
>
> C/EXEC SQL
>  + Update FILE
>  +  Set TYPE = :NewTYPE
>  +  Where TYPE = :OldTYPE
> C/END-EXEC
>
> Regards,
>
> Guy
>
>
>
>   
>                       MKirkpatrick@western   
>                       dental.com                  To:       Midrange 
> Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> 
>                       Sent by:                    cc:     
>                       midrange-l-bounces@m        Subject:  Simple report 
> pgm using embedded SQL 
>                       idrange.com   
>   
>   
>                       11/05/2007 12:16 PM   
>                       Please respond to   
>                       Midrange Systems   
>                       Technical Discussion   
>   
>   
>
>
>
>
> Can you write a simple report pgm using embedded SQL and no cursors?  If
> so, could someone give me the basics?  I have been using embedded SQL for
> several of my pgms but have always used cursors.  Just wondering.  Thanks.
>
>
>
>