https://sourceforge.net/p/squirrel-sql/bugs/1514/2023-04-15T13:17:16.605000ZRecent changes to 1514: Trigger list not populating on DB2 for z/OS2023-04-15T13:17:16.605000Z2023-04-15T13:17:16.605000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netdbda3399cf47e74afa98cc5988fcc8b3d569fa66

<div class="markdown_content"><p>Sorry I can't reproduce your problem on any DB2 DB I have access to.<br/> The one that I guess is closest to yours is<br/> ~~~<br/> | getDriverName | IBM Data Server Driver for JDBC and SQLJ |<br/> | getDatabaseProductName | DB2/LINUXX8664 |<br/> | getDatabaseProductVersion | SQL110550 |<br/> | getDriverVersion | 4.25.13 ~~~</p></div>

2023-04-12T18:01:44.185000Z2023-04-12T18:01:44.185000ZMichael McDermotthttps://sourceforge.net/u/mmcdermott/https://sourceforge.net1c4746c5e05273a90b140f38ed7d09f6acea0af1

<div class="markdown_content"><p>When I connect to DB2 for z/OS with SquirrelSQL 4.5.1, I do not find a list of triggers associated with a table. There is a "TRIGGER" node under a table that I know has triggers, but it shows none of the triggers that exist.</p> <p>I am able to manually query <code>SYSIBM.SYSTRIGGERS</code>, so it isn't a permissions issue. Moreover, that table is the one used for the database product name in <code>DB2PlatformType</code>. Driver information is in the attached image.</p> <p>I see the following errors:</p> <div class="codehilite"><pre><span></span><code><span class="mf">2023</span><span class="o">-</span><span class="mf">04</span><span class="o">-</span><span class="mf">12</span><span class="w"> </span><span class="mf">11</span><span class="p">:</span><span class="mf">51</span><span class="p">:</span><span class="mf">44</span><span class="p">:</span><span class="mf">053</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">INFO</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">plugins</span><span class="mf">.</span><span class="n">db2</span><span class="mf">.</span><span class="n">DB2Plugin</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">MESSAGE</span><span class="p">:</span><span class="w"> </span><span class="kr">SYS</span><span class="n">CAT</span><span class="mf">.</span><span class="n">TRIGGERS</span><span class="w"> </span><span class="n">IS</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="n">UNDEFINED</span><span class="w"> </span><span class="n">NAME</span><span class="mf">.</span><span class="w"> </span><span class="n">SQLCODE</span><span class="o">=-</span><span class="mf">204</span><span class="p">,</span><span class="w"> </span><span class="n">SQLSTATE</span><span class="o">=</span><span class="mf">42704</span><span class="p">,</span><span class="w"> </span><span class="n">DRIVER</span><span class="o">=</span><span class="mf">3.65.77</span> <span class="mf">2023</span><span class="o">-</span><span class="mf">04</span><span class="o">-</span><span class="mf">12</span><span class="w"> </span><span class="mf">11</span><span class="p">:</span><span class="mf">56</span><span class="p">:</span><span class="mf">34</span><span class="p">:</span><span class="mf">263</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">INFO</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">plugins</span><span class="mf">.</span><span class="n">db2</span><span class="mf">.</span><span class="n">DB2Plugin</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">MESSAGE</span><span class="p">:</span><span class="w"> </span><span class="kr">SYS</span><span class="n">IBM</span><span class="mf">.</span><span class="n">TRIGGERS</span><span class="w"> </span><span class="n">IS</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="n">UNDEFINED</span><span class="w"> </span><span class="n">NAME</span><span class="mf">.</span><span class="w"> </span><span class="n">SQLCODE</span><span class="o">=-</span><span class="mf">204</span><span class="p">,</span><span class="w"> </span><span class="n">SQLSTATE</span><span class="o">=</span><span class="mf">42704</span><span class="p">,</span><span class="w"> </span><span class="n">DRIVER</span><span class="o">=</span><span class="mf">3.65.77</span> <span class="mf">2023</span><span class="o">-</span><span class="mf">04</span><span class="o">-</span><span class="mf">12</span><span class="w"> </span><span class="mf">11</span><span class="p">:</span><span class="mf">56</span><span class="p">:</span><span class="mf">37</span><span class="p">:</span><span class="mf">328</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">INFO</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">plugins</span><span class="mf">.</span><span class="n">db2</span><span class="mf">.</span><span class="n">DB2Plugin</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">MESSAGE</span><span class="p">:</span><span class="w"> </span><span class="kr">SYS</span><span class="mf">.</span><span class="n">TRIGGERS</span><span class="w"> </span><span class="n">IS</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="n">UNDEFINED</span><span class="w"> </span><span class="n">NAME</span><span class="mf">.</span><span class="w"> </span><span class="n">SQLCODE</span><span class="o">=-</span><span class="mf">204</span><span class="p">,</span><span class="w"> </span><span class="n">SQLSTATE</span><span class="o">=</span><span class="mf">42704</span><span class="p">,</span><span class="w"> </span><span class="n">DRIVER</span><span class="o">=</span><span class="mf">3.65.77</span> <span class="mf">2023</span><span class="o">-</span><span class="mf">04</span><span class="o">-</span><span class="mf">12</span><span class="w"> </span><span class="mf">11</span><span class="p">:</span><span class="mf">58</span><span class="p">:</span><span class="mf">59</span><span class="p">:</span><span class="mf">213</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">INFO</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">plugins</span><span class="mf">.</span><span class="n">db2</span><span class="mf">.</span><span class="n">DB2Plugin</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">MESSAGE</span><span class="p">:</span><span class="w"> </span><span class="kr">SYS</span><span class="n">CAT</span><span class="mf">.</span><span class="n">TRIGGERS</span><span class="w"> </span><span class="n">IS</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="n">UNDEFINED</span><span class="w"> </span><span class="n">NAME</span><span class="mf">.</span><span class="w"> </span><span class="n">SQLCODE</span><span class="o">=-</span><span class="mf">204</span><span class="p">,</span><span class="w"> </span><span class="n">SQLSTATE</span><span class="o">=</span><span class="mf">42704</span><span class="p">,</span><span class="w"> </span><span class="n">DRIVER</span><span class="o">=</span><span class="mf">3.65.77</span> <span class="mf">2023</span><span class="o">-</span><span class="mf">04</span><span class="o">-</span><span class="mf">12</span><span class="w"> </span><span class="mf">11</span><span class="p">:</span><span class="mf">59</span><span class="p">:</span><span class="mf">15</span><span class="p">:</span><span class="mf">816</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">INFO</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">plugins</span><span class="mf">.</span><span class="n">db2</span><span class="mf">.</span><span class="n">DB2Plugin</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">MESSAGE</span><span class="p">:</span><span class="w"> </span><span class="kr">SYS</span><span class="n">IBM</span><span class="mf">.</span><span class="n">TRIGGERS</span><span class="w"> </span><span class="n">IS</span><span class="w"> </span><span class="n">AN</span><span class="w"> </span><span class="n">UNDEFINED</span><span class="w"> </span><span class="n">NAME</span><span class="mf">.</span><span class="w"> </span><span class="n">SQLCODE</span><span class="o">=-</span><span class="mf">204</span><span class="p">,</span><span class="w"> </span><span class="n">SQLSTATE</span><span class="o">=</span><span class="mf">42704</span><span class="p">,</span><span class="w"> </span><span class="n">DRIVER</span><span class="o">=</span><span class="mf">3.65.77</span> </code></pre></div> </div>