RPGLE based stored procedure with CLOB parameter -- 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.

Background:
Our system uses several SQL stored procedures that use an RPGLE service
program procedures which take a large VARCHAR as their parameter. The
scenario has come up where the max VARCHAR (32739) is not enough so I was
hoping to use a CLOB.

Problem:
If I define a RPGLE procedure using SQLTYPE(CLOB:2000000) it doesn't
compile because the precompile converts it to a DS with OVERLAY
008800 DCL-PI *N IND;

009000 //* JSONPARM SQLTYPE(CLOB:2000000);

009000 JSONPARM CHAR(2000004) CCSID(*HEX);
//SQL
009000 JSONPARM_LEN UNS(10) OVERLAY(JSONPARM);
//SQL
======> aaaaaaa

*RNF3748 20 a 009000 Keyword is not allowed for a parameter
definition; keyword is ignored.

009000 JSONPARM_DATA CHAR(2000000) OVERLAY(JSONPARM:5)
CCSID(*JOBRUNMIX); //SQL
======> aaaaaaa

*RNF3748 20 a 009000 Keyword is not allowed for a parameter
definition; keyword is ignored.

009100 END-PI;

I was hoping to do this in the same style of our current process (one long
string) to keep things similar.

Is there any way to use a CLOB parameter in an SQL stored procedure that
uses an RPGLE service program procedure.

Brian

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.