What's the total size of the data structure for 1192 elements?
On 1/22/2020 4:25 PM, Charles Wilt wrote:
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
bigger and we get the following exception on record 1193.QRWTSRVR
CPF3E01 Diagnostic 40 01/22/20 18:09:47.424155 QCNTEDDM QSYS *STMT
From user . . . . . . . . . : DT1PYDCStatement . . . . . . . . . : 8629
From module . . . . . . . . : QCNTEDDM
From procedure . . . . . . : SNDMSG
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
this server. The following are not supported (See X'2156'): -- '1144'X or'2112'X
'212D'X -- Version names. -- '2106'X -- Decimal precision of 15. --
-- Package names or collection identifiers greater than 10 characters inin
length. -- '2128'X -- Collection identifiers greater than 10 characters
length. -- '2129'X -- Release of allocated resources at conversation'2131'X --
deallocation. IBM i supports release of resources only after commit. --
'2130'X -- Option to explain information about SQL statements. --
User IDs greater than 10 characters in length. Recovery . . . : Changein
the value sent by the client and try the operation again. Technical
description . . . . . . . . : If DDM code point X'2156' does not appear
the list above refer to the DDM Architecture Reference for moreinformation.
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
One thing that's a little different, the results set is built as an RPG
dcl-ds my_data qualified dim(9999);
//other fields snipped
dcl-s OutputRows int(10);
Exec SQL Set Result Sets
WITH RETURN TO CLIENT
FOR :outputrows ROWS;
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.