Re: qsys2.clear_data_queue

Hi, Don,

QSYS2.CLEAR_DATA_QUEUE is an SQL user defined function procedure.  You can see it listed in the SQL catalog in table (or view) SYSPROCS.

   select * from sysprocs where procname = 'CLEAR_DATA_QUEUE' 

So, you cannot just bind to it or call it like some ILE procedure.

CL does not directly support "embedded SQL".

You might be able to invoke it from a CL program via the CL command RUNSQL or similar.

It may be easier to simply call the original API named QCLRDTAQ.  It is an OPM *PGM so easily CALLed from CL, or whatever.

Hope that helps,

Mark S. Waterbury

On Thursday, July 4, 2024 at 12:15:11 AM EDT, Don Brown via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi

I want to use the procedure to clear a data queue in a CL program.

I can not find any binding directory with this procedure.

How do I compile the program, the module compiles ok but the program fails as it can not find the procedure.

Thanks

Don