Re: Simple report pgm using embedded SQL

[MKirkpatrick@xxxxxxxxxxxxxxxxx]

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.