Re: Simple report pgm using embedded SQL

Query/400 or QM would work just fine. In my simple example. I am just
wondering about embedded SQL being used to print the contents of a file.
Perhaps it would not be the correct tool to use. Thanks.



"Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/05/2007 09:40 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






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.