× 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.



I'd imagine big enough to fit a count of all records.


Try our New Country Benedicts -- Breakfast with a Bob Evans twist!


rpg400-l-bounces@xxxxxxxxxxxx wrote on 08/17/2006 12:57:28 PM:

Hi!

What must be the length of my host variable that receives the result of
the
COUNT query?

Charles


"McGovern, Sean"
<Sean.McGovern@xxxxxxxxxxxxxxxxxxxxxxx> a écrit
dans le message de
news:D0BF1924AE5102408F091535623E32C00C60348B@xxxxxxxxxxxxxxxxxxxxxxx
I don't believe so, unfortunately. You would need to perform a COUNT.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Charles St-Laurent
Sent: 17 August 2006 16:21
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Get the row count from the SQLCA

Hi!

So, is there any SQLCA field that can indicate the EXACT number of rows
returned by my SELECT query before I try to use it to fill my subfile?

Charles


"McGovern, Sean"
<Sean.McGovern@xxxxxxxxxxxxxxxxxxxxxxx> a écrit
dans le message de
news:D0BF1924AE5102408F091535623E32C00C603486@xxxxxxxxxxxxxxxxxxxxxxx
SQLER3 is an 'estimated number of rows' value.



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Charles St-Laurent
Sent: 17 August 2006 15:23
To: rpg400-l@xxxxxxxxxxxx
Subject: Get the row count from the SQLCA

Hi!

I try to get the row count from the SQLCA in a SQLRPGLE program in
which I build my Select statement dynamically in a string. The program
works fine but I want to get the row count from the SQLCA before
trying to fill my subfile with my Select result.

I know that row count is usually in SQLER3 (I think so) but when I try
to get this value before my FETCH loop, the value is 1.

This is what I do:

Eval SQLSTR = 'SELECT MY_DATA FROM MY_TABLE'
C/EXEC SQL PREPARE S1 FROM :SQLSTR
C/END-EXEC
C/EXEC SQL DECLARE C1 CURSOR FOR S1
C/END-EXEC
C/EXEC SQL OPEN C1
C/END-EXEC
C/EXEC SQL FETCH C1 INTO :SQLREC
C/END-EXEC
C                   DUMP

When I look at the result of the DUMP operation, SQLER3 = 1 but in
fact
the
result should be 2... why?

Thanks for your help
Charles



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email:
RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before
posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.


****************************************************************************


This e-mail is confidential, intended only for the named recipient(s)
above,
and may well also be legally privileged. If you have received it in
error, you are on notice of its status. Please notify us immediately
by reply e-mail and then delete this message from your system. Please
do not copy
it
or use it for any purposes, or disclose its contents to any other
person:
to
do so could be a breach of confidence. Please contact us on +44 (0)
1329 224000 or email
postmaster@xxxxxxxxxxxxxxxxxxxxxxx if you need
assistance.
Thank you for your co-operation.



****************************************************************************

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email:
RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before
posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.






****************************************************************************


This e-mail is confidential, intended only for the named recipient(s)
above,
and may well also be legally privileged. If you have received it in
error,
you are on notice of its status. Please notify us immediately by reply
e-mail and then delete this message from your system. Please do not copy
it
or use it for any purposes, or disclose its contents to any other person:
to
do so could be a breach of confidence. Please contact us on +44 (0) 1329
224000 or email postmaster@xxxxxxxxxxxxxxxxxxxxxxx
if you need assistance.
Thank you for your co-operation.


****************************************************************************


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




As an Amazon Associate we earn from qualifying purchases.

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-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.