On Tue, 25 Nov 2025 17:09:03 -0600 Jon Perryman <[email protected]> wrote:
:>On Tue, 25 Nov 2025 21:32:49 +0200, Binyamin Dissen <[email protected]> wrote: :>>The EXPLAIN got -219 :>What error messages were produced from GET DIAGNOSTICS? :>Is SPUFI still a thing? Maybe it would be useful while you are prototyping. If I remember correctly, it displays the diags. :>Did you create the explain tables? Did the SET SCHEMA DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE DOES NOT EXIST DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION The table exists under the the ID that I do a SET CURRENT SQLID. SET SCHEMA was ignored for the EXPLAIN table name. -- 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
