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



Scenario
Db2 Connect driver for .NET CORE

Calling an external stored procedure written in RPG.

As long as the results set is 1192 records or less, it works fine, but any
bigger and we get the following exception on record 1193.


CPF3E01 Diagnostic 40 01/22/20 18:09:47.424155 QCNTEDDM QSYS *STMT QRWTSRVR
QSYS *STMT

From user . . . . . . . . . : DT1PYDC
From module . . . . . . . . : QCNTEDDM
From procedure . . . . . . : SNDMSG
Statement . . . . . . . . . : 8629
To module . . . . . . . . . : QRWTSRVR
To procedure . . . . . . . : main
Statement . . . . . . . . . : 325
Message . . . . : DDM parameter value not supported.
Cause . . . . . : A value was sent from the client that is not supported by
this server. The following are not supported (See X'2156'): -- '1144'X or
'212D'X -- Version names. -- '2106'X -- Decimal precision of 15. -- '2112'X
-- Package names or collection identifiers greater than 10 characters in
length. -- '2128'X -- Collection identifiers greater than 10 characters in
length. -- '2129'X -- Release of allocated resources at conversation
deallocation. IBM i supports release of resources only after commit. --
'2130'X -- Option to explain information about SQL statements. -- '2131'X --
User IDs greater than 10 characters in length. Recovery . . . : Change
the value sent by the client and try the operation again. Technical
description . . . . . . . . : If DDM code point X'2156' does not appear in
the list above refer to the DDM Architecture Reference for more information.

Doesn't matter what's in the results set, only if it bigger than 1192.

Calling the same store proc via JBDC using ACS Run SQL Scripts works fine.

One thing that's a little different, the results set is built as an RPG
Array...

dcl-ds my_data qualified dim(9999);
ENTERPRISE char(4);
COMPANY char(3);
EMPLOYEE_ID char(9);
TECH_ID char(3);
//other fields snipped
end-ds;
dcl-s OutputRows int(10);

Exec SQL Set Result Sets
WITH RETURN TO CLIENT
ARRAY :my_data
FOR :outputrows ROWS;

Thoughts?
Charles

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.