On Tue, 25 Nov 2025 19:50:13 -0600 Jon Perryman <[email protected]> wrote:
:>On Wed, 26 Nov 2025 01:30:16 +0200, Binyamin Dissen <[email protected]> wrote: :>>The table exists under the the ID that I do a SET CURRENT SQLID. :>SET SQLID is not valid for your situation because you did not implement the exit. When the SQLID is a group name and connected to the user it does work. I am trying to avoid this requirement. :>>Did the SET SCHEMA :>>DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE DOES NOT :>>EXIST :>Notice "TABLE DOES" shows the table name is null. I wonder if it's caused by the invalid SET SQLID. The SET SCHEMA had SQLCODE 0 :>>SET SCHEMA was ignored for the EXPLAIN table name. :>Did you specify AUTHORIZATION 'uuu' on the CREATE SCHEMA where uuu is the name you specified on the SET SQLID? I can't find the CREATE SCHEMA command in the DB2 V3.1 SQL Reference -- Binyamin Dissen <[email protected]> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
