RE: SQL select from another database only selecting 80 or so rows. -- MIDRANGE-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.

STRDBG PGM(*NONE) UPDPROD(*YES)

strsql
CONNECT to relational database GDISYS completed.
Current connection is to relational database GDISYS.
Current connection is to relational database GDISYS.
CONNECT to relational database GDISYS1 completed.
EXECUTE IMMEDIATE completed.
Current connection is to relational database GDISYS.
35 rows fetched from cursor RAWDATACURSOR26.
(Editors note: In STRSQL this is where I entered: Control . . . . B)

73 rows fetched from cursor RAWDATACURSOR26.
Row not found for RAWDATACURSOR26.

Again why only 108 rows when the count(*) shows a more accurate figure?

details

Message ID . . . . . . : SQL7963 Severity . . . . . . . : 00
Message type . . . . . : Completion
Date sent . . . . . . : 12/04/16 Time sent . . . . . . : 17:19:56

Message . . . . : 35 rows fetched from cursor RAWDATACURSOR26.
Cause . . . . . : 35 rows were fetched from cursor RAWDATACURSOR26 with

result set identifier 0. If the result set identifier is non-zero, this

cursor was being accessed as a stored procedure result set.

Message ID . . . . . . : SQL7963 Severity . . . . . . . : 00
Message type . . . . . : Completion
Date sent . . . . . . : 12/04/16 Time sent . . . . . . : 17:19:57

Message . . . . : 73 rows fetched from cursor RAWDATACURSOR26.
Cause . . . . . : 73 rows were fetched from cursor RAWDATACURSOR26 with

result set identifier 0. If the result set identifier is non-zero, this

cursor was being accessed as a stored procedure result set.

Rob Berendt

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.