Show SQL running total in RPG -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Subject: Show SQL running total in RPG
From: "T. Adair" <tadair@xxxxxxxxxxxxxxxx>
Date: Fri, 1 Feb 2019 09:51:28 -0600
Arc-authentication-results: i=1; mx.google.com; spf=neutral (google.com: 195.159.176.226 is neither permitted nor denied by best guess record for domain of rpg400@xxxxxxxxxxx) smtp.mailfrom=rpg400@xxxxxxxxxxx
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=content-language:user-agent:content-transfer-encoding:mime-version :message-id:date:subject:from:to; bh=vpRG5cfIutA56l6dAbSX+v9pYnjtId6vQwgAf3oHDy8=; b=xVwybnY9gUaKZFqgG1qB0HLXD+ugFQO5xfhlnI0QPuz7mwkwgmjHeRUgH9KL6xqVWA JA6hpxjFiAvGXg4DbHWTE00f1MlLBB1/hgUmuieo6wX8rsAE/L2dcUOQnYmgNwbr6mNI 2+O+SVBUajAjyF19xMViOkUjWqE097+8ByJke1d68HDbDHjFP32z1gbtSjqavn6XjMGy fHg4bDxs/wV4ZKjB7ZSdJihlTxyT70z97TFQpMCHdG/DwDlXkqFNK0onO7yy8S+ozB78 I30yhCmXKd5/PmS/Cb8WoVR+Erj2Eieo+ypoAmSxO6Pj+kJs+KBmzu/aYk1DpSfollZa rl6g==
Arc-seal: i=1; a=rsa-sha256; t=1549036305; cv=none; d=google.com; s=arc-20160816; b=ojCBs0Sk9U9F6FSF/o5pWoh5IHofJP9RvvX4pH+VJdwOtYHgx1va00R4H8OTy3SUMX 5hZJ88YmG+qqB5c8yFOBKZj0IPF4a2XZDDKKstsre2pR5Ei1dFM87PuAc0Kh82OlUsSW f/VFVHua7KjSv2d3IeyQngPz40RF4nPhjZOldc0vevRmFjSJjKlbo/pHEcpcXrvJIAjf DkJIF39h+mvHo42DHNFEF+ezW7eeWnn0FplFFxp5f+7Q5SlBkPorIuj8n8iOuokLoCqg 34mhrIwZw6NA9yEw9N39iNjeViBiLG7cua6N1KpR+T2CEzE8R+8kypbIYOQl3H1AkBw4 jpyA==
List-archive: <https://archive.midrange.com/rpg400-l/>
List-help: <mailto:rpg400-l-request@lists.midrange.com?subject=help>
List-id: "RPG programming on the IBM i \(AS/400 and iSeries\)" <rpg400-l.lists.midrange.com>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

When I run an interactive SQL (using STRSQL), I see the running record totals on the status line, like this...

"Query running. 1507345 records selected, 9436780 processed."

This is constantly updated until it finishes.

I have an SQLRPGLE program where I want this information to show on the status line, while the program is running the query. Is this possible, or am I dreaming?

We're currently on 7.2.

Thanks.

~TA~

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Show SQL running total in RPG , Pieter Henrico

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