• Subject: Re: Count records in SQL
  • From: Bruno VARON <bvaron@xxxxxxxxxxx>
  • Date: Thu, 12 Feb 2026 23:56:16 +0100
  • List-archive: <https://archive.midrange.com/rpg400-l/>
  • 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>
  • Ui-outboundreport: notjunk:1;M01:P0:k4P3h4QXRrk=;WH882DWLvbhr+GVuAlOgSultc6g QiW3s3EDMAVWvP3iIghDl5+OO9m8WRFnkjop3Ldas1y6MzeLZHwxQF4x4Y/O5oDN02rfQAnq1 dr9tq572pXp7AXuBZAqi8xMq2OCg7WYluvrHRSclWw4dcya7esh8GcgZH/4bQBMmUnsTQpNN5 5EL6SAIY+quzPq+00wnQ5ubKXPXCwZjYUgO+pcHowJTL/YLC4UcT+Qd7MaSzRji+8MYIzKFBr VuBiMjluF2ojYWePzlMo0fueSslf3KEByGW1vdYg0w6WUBHqiWvmVv7sVDuVHGf+e9J6DXWgL blJyCwG+PmdbqIfMVFxyXXm4IZot845Auj6W6igwPd1MENNxv9q1ZOHVsYfBD9+u7lWiEuaGC osJ0D6nN0UJaE815cKsT2guBVigVAK4GjCAOZ0rTaessAaqpT5lrKASgvgh5PRFdpjorr93+1 Lftqr8JaN4MKEuCpaOmrfBEBtb8fUy27ZTfvpp31nc0SSxAKl/t5pGRJTx1v5UPhH6PWQJvco I0S0QpuVag3NEfzuec5hdSf8v0Y2Psybhn2upejtPU1pkt5FdkCbhez4rbArHajJzrvn9aaPx P8aiXkpIr4uyHeh6iQ5qKUX0UIC8KZwFk6sKVDp3jZ+FpbdOb47w2GDa49DXnDGPGL/cKQMSs FZOUlsnnFFl+ax9YO8C/DJviz16yiM/FNZE1+SNkcUhnZgYytU5+8b1WLoYzX4OEqiXuFyAL1 dfhdqQQN65rN64b7JVAeFu3YaPk86jtKiksgC/cgr+K/vxwagyQyDwlPafBKj2FwLrGxYUZES u78Rx6Dgj5B8GS95BF4ub07GzJqkVCzRZS99VYgWrXrdbE6YyFoMKfOYm40Ky+H6Yk/CVcDA2 m7s/fyZhMDxbJPuwGnzMCs6UG16Tm/TXwC8SayLA9fre+RxlzpS+R3q+qYqKijQZfL6ddRpve AByZrv+6AlNlYmOl6PNJrh59HkdJsI43rf41EaTgViJBtSA5Yija8rq4Fy7mS00L6WbK5IQxm JrEaNBesq3JWh1i6ZpniUdib8o/b9DF7hYxfcpdnzS+hcbUGZYA9WiDo9fTBNboINSikFRSNB 4K89z+SY8jMMPwWVMmHE4/ZyIZy/sAQ0Qm8x2oi2GtPDRurk+1Xe3MPTyBqPWv/je8wPAzbfL CpGUQGHjdRSeHsmfZWxY+AoxlnjEOmS+ERHWjqoqnPj+EnjTFqFEeobj7NRNQhTgAc3yO5SFR R7w+873XV5bXtlcnJWYykepLtjaDvdX4LMlDeERpu2sEJdvU2q9fsGa5j7R91lSIEcjaudhIk SVrSGeCWfN3VIpspWz6w/aMTblJJVHdvPMaz0KXbyQHw2GUOaxYXAsyDMqjFYTHFZJXpL6YOI uitE9qsXn2/YlTu8dhfZAEOtSfeYyMgGGDg86RWWLpHyFedjrbzyb58h4wwtAd0YYoTMLvuRP +JlBV88DYPADizHLR8aRVva8HOO5H496wO6GZS6J++qk4i9jNIazdwPoJtrDz1MZURL+XjNaN 9qfufI5fYoeQpOOtyLn+cc1otJ/0OMtwbu2qVIF7m61Pn48k9x7Zz6Qm7YHDOJ0/JNfiuD49N B75ULE3vKWrqToX/VjKTidrJtaeo52GmmnfI2r7XQlHB3iohScMt4G7DqrPLAUWdk2WVXZVwQ AQwACmQ0RFAqI9O3tJzgn5aRRiIZxnoTC+QzeXE+JIBBpHvyYHUGOclbd/r3pwM2BAP3wu7FA nc2VBzjX4x+0g

Hi Jimmy,

First

D count    s   10i 0

Select Count(*) into :count From
(your SQLrequest)

The request is on db2 "cache", if think is a good solution.

Regards,


As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.