Re: Simple report pgm using embedded SQL -- MIDRANGE-L

Subject: Re: Simple report pgm using embedded SQL
From: GUY_HENZA@xxxxxxxxxxxxxx
Date: Mon, 5 Nov 2007 12:23:11 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Yes, there is lots of ways to do it.

C/Exec SQL
C+ SELECT COUNT(*) INTO :RECS FROM OUTDTA WHERE
C+ OQDDTA LIKE :PRTSCN
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.

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2024 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.