×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




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.




This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.