Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 45BE0CAFE for ; Thu, 7 Aug 2014 16:52:21 +0000 (UTC) Received: (qmail 53898 invoked by uid 500); 7 Aug 2014 16:52:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 53872 invoked by uid 500); 7 Aug 2014 16:52:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 53859 invoked by uid 99); 7 Aug 2014 16:52:20 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Aug 2014 16:52:20 +0000 X-ASF-Spam-Status: No, hits=3.0 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_PASS,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [207.46.163.141] (HELO na01-bn1-obe.outbound.protection.outlook.com) (207.46.163.141) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Aug 2014 16:52:17 +0000 Received: from BY2FFO11FD007.protection.gbl (10.1.14.31) by BY2FFO11HUB018.protection.gbl (10.1.14.92) with Microsoft SMTP Server (TLS) id 15.0.990.10; Thu, 7 Aug 2014 16:51:48 +0000 Received: from CPHUB1.canoga.com (74.62.37.82) by BY2FFO11FD007.mail.protection.outlook.com (10.1.14.128) with Microsoft SMTP Server (TLS) id 15.0.990.10 via Frontend Transport; Thu, 7 Aug 2014 16:51:47 +0000 Received: from vserver1.canoga.com ([169.254.2.160]) by CPHUB1.canoga.com ([172.16.1.93]) with mapi; Thu, 7 Aug 2014 09:50:35 -0700 From: "Bergquist, Brett" To: "derby-dev@db.apache.org" Date: Thu, 7 Aug 2014 09:51:46 -0700 Subject: Question on why the statement cache is saying a statement is invalid Thread-Topic: Question on why the statement cache is saying a statement is invalid Thread-Index: Ac+yXrLDNfZj3VUoT56tXdyofU90nw== Message-ID: <97EB699F861AD841B5908C7CA9C9565602C8665CFA76@VSERVER1.canoga.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US x-tm-as-product-ver: SMEX-10.2.0.3176-7.500.1018-20862.005 x-tm-as-result: No--36.304800-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: multipart/alternative; boundary="_000_97EB699F861AD841B5908C7CA9C9565602C8665CFA76VSERVER1can_" MIME-Version: 1.0 X-EOPAttributedMessage: 0 X-Forefront-Antispam-Report: CIP:74.62.37.82;CTRY:US;IPV:NLI;IPV:NLI;EFV:NLI;SFV:NSPM;SFS:(6009001)(428002)(199002)(189002)(16236675004)(86362001)(105586002)(81156004)(106466001)(99396002)(107886001)(33656002)(104016003)(19625215002)(101416001)(110136001)(512954002)(4396001)(46102001)(55846006)(21056001)(80022001)(64706001)(15202345003)(77982001)(54356999)(19300405004)(69596002)(83322001)(77096002)(44976005)(6806004)(19580395003)(20776003)(85306004)(79102001)(81342001)(71186001)(76482001)(83072002)(53416004)(85852003)(2656002)(50986999)(2351001)(81542001)(107046002)(229853001)(92566001)(92726001)(74502001)(31966008)(84326002)(15975445006)(87936001)(95666004)(80792004);DIR:OUT;SFP:;SCL:1;SRVR:BY2FFO11HUB018;H:CPHUB1.canoga.com;FPR:;MLV:sfv;PTR:rrcs-74-62-37-82.west.biz.rr.com;A:1;MX:1;LANG:en; X-OriginatorOrg: canogaperkins.onmicrosoft.com X-Microsoft-Antispam: BCL:0;PCL:0;RULEID: X-Forefront-PRVS: 029651C7A1 Received-SPF: None (: canoga.com does not designate permitted sender hosts) Authentication-Results: spf=none (sender IP is 74.62.37.82) smtp.mailfrom=BBergquist@canoga.com; X-Virus-Checked: Checked by ClamAV on apache.org --_000_97EB699F861AD841B5908C7CA9C9565602C8665CFA76VSERVER1can_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am trying to figure out an issue where the optimizer is taking a long tim= e to compile a statement and want to make sure that the subsequent times th= rough it will use the cached statement if present in the statement cache. I prepare the statement and then I look at the cache with: SELECT * FROM SYSCS_DIAG.STATEMENT_CACHE And it shows that the statement is invalid. Why would the a statement be i= n the cache and be invalid? ij> SELECT * FROM SYSCS_DIAG.STATEMENT_CACHE; ID |SCHEMANAME = = |SQL_TEXT ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= -------------- 3d3b0068-0147-b12d-b252-000065089f97|CSEM = = |SELECT * FROM SYSCS_DIAG.STATEMENT_CACHE order by ID desc = = |true |true |NULL 5e838074-0147-b12d-b252-000065089f97|APP = = |call SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) = = |true |true |NULL 6302404f-0147-b12d-b252-000065089f97|CSEM = = |call SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) = = |true |true |NULL 65f6406f-0147-b12d-b252-000065089f97|CSEM = = |SELECT t0.ID, t0.DTYPE, t0.RELATIVE_POSITION, t0.ALIAS_NAME, t0.DESCRIPTION, t0.DEVICE_NAME, t0.OPLOCK, t0.PARENTENTITY_ID, t1.ID, t1.MODEL, t1.SERIAL_NUMBER, t1.HARDWARE_TYPE, t1.HARDWARE_VERSION, t2.ID, t2.NEXT_CONFIGURATION_NUMBER, t2.NEWEST_CONFIGURATIONSET_ID, t2.OLDEST_CONFIGURATIONSET_ID, t3.ID, t3.TEMPLATE, t3.SYSTEM_TEMPLATE, t3.ADMIN_ENABLED, t3.TEMPLATE_PROPERTIES_ID, t3.ENTITY_FACET_MANAGER_ID, t4.ID, t4.LAST_OBSERVED_PING, t4.SNMP_READ_TIMESTAMP, t4.LAST_OBSERVED_SNMP_WRITE, t4.LAST_OBSERVED_SNMP_READ, t4.PING_TIMESTAMP, t4.SNMP_WRITE_TIMESTAMP, t5.ID, t5.POWER_LED_STATE_TIMESTAMP, t5.LAST_OBSERVED_STATUS_LED_STATE, t5.MAINBOARD_VOLTAGE_STATUS_TIMESTAMP, t5.LAST_OBSERVED_MAINBOARD_VOLTAGE_STATUS, t5.STATUS_LED_STATE_TIMESTAMP, t5.LAST_OBSERVED_POWER_LED_STATE, t6.ID, t7.ID FROM CORE_V1.SNMP_DEVICE t9, CORE_V1.SNMP_DEVICE_IP t8, PKG_9145E_V1.CHASSIS_9145E_104_0_0 t7, PKG_9145E_V1.CHASSIS_9145E_BC04 t6, PKG_9145E_V1.CHASSIS_9145E t5, CORE_V1.AGENT_MANAGED_HARDWARE t4, CORE_V1.MANAGED_HARDWARE t3, CORE_V1.CONFIGURABLE_HARDWARE t2, CORE_V1.HARDWARE t1, CORE_V1.DEVICE_ENTITY t0 WHERE ( ( (t8.IP =3D CSEM.STRING_TO_IP(?)) AND ( ( (t7.ID =3D t0.ID) AND ( (t6.ID =3D t0.ID) AND ( (t5.ID =3D t0.ID) AND ( (t4.ID =3D t0.ID) AND ( (t3.ID =3D t0.ID) AND ((t2.ID =3D t0.ID) AND (t1.ID =3D t0.ID)) ) ) ) ) ) AND (t0.DTYPE =3D 'CHASSIS_9145E_104_0_0') ) ) AND ((t9.AGENT_MANAGED_HARDWARE_ID =3D t0.ID) AND (t8.SNMPDEVICE_ID =3D = t9.ID)) ) = = |true |true |NULL 832a0051-0147-b12d-b252-000065089f97|CSEM = = |SELECT t0.ID, t0.DTYPE, t0.RELATIVE_POSITION, t0.ALIAS_NAME, t0.DESCRIPTION, t0.DEVICE_NAME, t0.OPLOCK, t0.PARENTENTITY_ID, t1.ID, t1.MODEL, t1.SERIAL_NUMBER, t1.HARDWARE_TYPE, t1.HARDWARE_VERSION, t2.ID, t2.NEXT_CONFIGURATION_NUMBER, t2.NEWEST_CONFIGURATIONSET_ID, t2.OLDEST_CONFIGURATIONSET_ID, t3.ID, t3.TEMPLATE, t3.SYSTEM_TEMPLATE, t3.ADMIN_ENABLED, t3.TEMPLATE_PROPERTIES_ID, t3.ENTITY_FACET_MANAGER_ID, t4.ID, t4.LAST_OBSERVED_PING, t4.SNMP_READ_TIMESTAMP, t4.LAST_OBSERVED_SNMP_WRITE, t4.LAST_OBSERVED_SNMP_READ, t4.PING_TIMESTAMP, t4.SNMP_WRITE_TIMESTAMP, t5.ID, t5.POWER_LED_STATE_TIMESTAMP, t5.LAST_OBSERVED_STATUS_LED_STATE, t5.MAINBOARD_VOLTAGE_STATUS_TIMESTAMP, t5.LAST_OBSERVED_MAINBOARD_VOLTAGE_STATUS, t5.STATUS_LED_STATE_TIMESTAMP, t5.LAST_OBSERVED_POWER_LED_STATE, t6.ID, t7.ID FROM CORE_V1.SNMP_DEVICE t9, CORE_V1.SNMP_DEVICE_IP t8, PKG_9145E_V1.CHASSIS_9145E_104_0_0 t7, PKG_9145E_V1.CHASSIS_9145E_BC04 t6, PKG_9145E_V1.CHASSIS_9145E t5, CORE_V1.AGENT_MANAGED_HARDWARE t4, CORE_V1.MANAGED_HARDWARE t3, CORE_V1.CONFIGURABLE_HARDWARE t2, CORE_V1.HARDWARE t1, CORE_V1.DEVICE_ENTITY t0 WHERE ( ( (t8.IP =3D ?) AND ( ( (t7.ID =3D t0.ID) AND ( (t6.ID =3D t0.ID) AND ( (t5.ID =3D t0.ID) AND ( (t4.ID =3D t0.ID) AND ( (t3.ID =3D t0.ID) AND ((t2.ID =3D t0.ID) AND (t1.ID =3D t0.ID)) ) ) ) ) ) AND (t0.DTYPE =3D 'CHASSIS_9145E_104_0_0') ) ) AND ((t9.AGENT_MANAGED_HARDWARE_ID =3D t0.ID) AND (t8.SNMPDEVICE_ID =3D = t9.ID)) ) = = |true |= false|NULL 6ebdc076-0147-b12d-b252-000065089f97|APP = = |SELECT * FROM SYSCS_DIAG.STATEMENT_CACHE = = |true |true |NULL c5bf806d-0147-b12d-b252-000065089f97|SYS = = |SELECT M->allProceduresAreCallable(), M->allTablesAreSe= lectable(), M->supportsCatalogsInTableDefinitions(), M->supportsCatalogsInIndexD= efinitions(), M->supportsCatalogsInPrivilegeDefinitions(), M->sup= portsPositionedDelete(), M->supportsPositionedUpdate(), M->supportsSelect= ForUpdate(), 2589c06b-0147-b12d-b252-000065089f97|CSEM = = |CALL SYSIBM.MetaData() = = |true |true |NULL --_000_97EB699F861AD841B5908C7CA9C9565602C8665CFA76VSERVER1can_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am trying to f= igure out an issue where the optimizer is taking a long time to compile a s= tatement and want to make sure that the subsequent times through it will us= e the cached statement if present in the statement cache.

 

I prepare the s= tatement and then I look at the cache with:

 

SELECT * FROM SYSCS_DIAG.STAT= EMENT_CACHE

 

And it shows that the statement is invalid.  Why would t= he a statement be in the cache and be invalid?

 

ij> SELECT * FROM SYSCS= _DIAG.STATEMENT_CACHE;

ID  &nb= sp;            =             &nb= sp;      |SCHEMANAME     =              &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            |S= QL_TEXT

--------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------

3d3b0068-0147-b12d-b252-000065089f97|CSEM  &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;             =         |SELECT * FROM SYSCS_DIAG.S= TATEMENT_CACHE order by ID desc

 &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;  |true |true |NULL

5e838074-0147-= b12d-b252-000065089f97|APP        &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;    |call SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,= ?,?)

      = ;            &n= bsp;            = ;             &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;         |true |true |NULL

6302404f-0147-b12d-b252-000065089f97|CSEM=             &nb= sp;            =             &nb= sp;            =             &nb= sp;             = ;            &n= bsp;            = ;            &n= bsp;          |call SYSIB= M.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

           &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;            &nb= sp;            =     |true |true |NULL

65f6406f-0147-b12d-b252-000065089f97|CSEM     &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;      |SELECT

= t0.ID,

t0.DTYPE,

t0.RELATIVE_POSITION,

t0.AL= IAS_NAME,

t0.DESCRIPTION,

=

t0.DEVICE_NAME,

t0.= OPLOCK,

t0.PARENTENTITY_ID,

t1.ID,

t1.MODEL,<= o:p>

t1.SERIAL_NUMBER,

t1.HARDWARE_TYPE,

t1.HARDWA= RE_VERSION,

t2.ID,

t2.NEXT_CONFIGURATION_NUMBER,

t2.NEWEST_CONFIGURATIONSET_ID,

t2.OL= DEST_CONFIGURATIONSET_ID,

t3.ID,

t3.TEMPLATE,

t3.SYSTEM_TEMPLATE,

t3.ADMIN_ENABLED,

t3.TEMPLATE_PROPERTIES_ID,

=

t3.ENTITY_FACET_MANAGER_ID,

t4.ID,

t4.LAST_OBSERVED_PING,

t4.SNMP_READ_TIMESTAMP,

t4.LAST_OBSERVED_SNMP_WRITE,

t4.LAST_OBSERVED_SNMP_READ,

t4.PI= NG_TIMESTAMP,

t4.SNMP_WRITE_TIMESTAMP,

t5.ID,

t5.POWER_LED_STATE_TIMESTAMP,

t5.LAST_O= BSERVED_STATUS_LED_STATE,

t5.MAINBOARD_V= OLTAGE_STATUS_TIMESTAMP,

t5.LAST_OBSERVE= D_MAINBOARD_VOLTAGE_STATUS,

t5.STATUS_LE= D_STATE_TIMESTAMP,

t5.LAST_OBSERVED_POWE= R_LED_STATE,

t6.ID,

t7.ID

FROM CORE_V1.SNMP_D= EVICE t9,

CORE_V1.SNMP_DEVICE_IP t8,

PKG_9145E_V1.CHASSIS_9145E_104_0_0 t7,=

PKG_9145E_V1.CHASSIS_9145E_BC04 t6,

PKG_9145E_V1.CHASSIS_9145E t5,

CORE_V1.AGENT_MANAGED_HARDWARE t4,

CORE_V1.MANAGED_HARDWARE t3,

CORE_V1.CONFIGURABLE_HARDWARE t2,

CORE= _V1.HARDWARE t1,

CORE_V1.DEVICE_ENTITY t= 0

WHERE

(

   (

      (t8.IP =3D CSEM.STRING_TO_IP(= ?))

      AND

      (

        = (

      &= nbsp;     (t7.ID =3D t0.ID)

            = AND

      =       (

 &= nbsp;           &nbs= p; (t6.ID =3D t0.ID)

   &= nbsp;           AND<= /o:p>

       &nb= sp;       (

             =      (t5.ID =3D t0.ID)

           &= nbsp;      AND

=             &nb= sp;     (

 &nbs= p;            &= nbsp;      (t4.ID =3D t0.ID)

          &= nbsp;          AND<= /p>

        &nb= sp;            (

       &= nbsp;           &nbs= p;    (t3.ID =3D t0.ID)

&= nbsp;           &nbs= p;           AND ((t2.ID = =3D t0.ID) AND (t1.ID =3D t0.ID))

 =             &nb= sp;       )

            &= nbsp;     )

 &n= bsp;            = ; )

      =       )

 &= nbsp;       )

         AND (t0.DTYPE =3D 'CHA= SSIS_9145E_104_0_0')

   &= nbsp;  )

   )<= /p>

   AND ((t9.AGENT_MANAGED_HARDWARE_ID =3D= t0.ID) AND (t8.SNMPDEVICE_ID =3D t9.ID))

)            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =            |true |true |N= ULL

832a0051-0147-b12d-b252-000065089f97= |CSEM           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            |SELEC= T

t0.ID,

t0.DTYPE,

t0.RELATIVE_POSITION,=

t0.ALIAS_NAME,

t0.DESCRIPTION,

t0.DEVICE_NAME,

t0.OPLOCK,

t0.PARENTENTITY_ID,

t1.ID,

t1.MODEL,

t1.S= ERIAL_NUMBER,

t1.HARDWARE_TYPE,

t1.HARDWARE_VERSION,

t2.ID,

t2.NEXT_CONFIGURATION_NUM= BER,

t2.NEWEST_CONFIGURATIONSET_ID,=

t2.OLDEST_CONFIGURATIONSET_ID,

t3.ID,

t3.TEMPLATE= ,

t3.SYSTEM_TEMPLATE,

t3.ADMIN_ENABLED,

t3.TE= MPLATE_PROPERTIES_ID,

t3.ENTITY_FACET_MA= NAGER_ID,

t4.ID,

t4.LAST_OBSERVED_PING,

t4.S= NMP_READ_TIMESTAMP,

t4.LAST_OBSERVED_SNM= P_WRITE,

t4.LAST_OBSERVED_SNMP_READ,

t4.PING_TIMESTAMP,

t4.SNMP_WRITE_TIMESTAMP,

t5= .ID,

t5.POWER_LED_STATE_TIMESTAMP,<= /o:p>

t5.LAST_OBSERVED_STATUS_LED_STATE,=

t5.MAINBOARD_VOLTAGE_STATUS_TIMESTAMP,<= /p>

t5.LAST_OBSERVED_MAINBOARD_VOLTAGE_STATUS,

t5.STATUS_LED_STATE_TIMESTAMP,

t5.LAST_OBSERVED_POWER_LED_STATE,

t6.ID,

t7.ID

=

FROM CORE_V1.SNMP_DEVICE t9,

CORE_V1.SNMP_DEVICE_IP t8,

PKG= _9145E_V1.CHASSIS_9145E_104_0_0 t7,

PKG_= 9145E_V1.CHASSIS_9145E_BC04 t6,

PKG_9145= E_V1.CHASSIS_9145E t5,

CORE_V1.AGENT_MAN= AGED_HARDWARE t4,

CORE_V1.MANAGED_HARDWA= RE t3,

CORE_V1.CONFIGURABLE_HARDWARE t2,=

CORE_V1.HARDWARE t1,

CORE_V1.DEVICE_ENTITY t0

WHERE

(

   (

   &n= bsp;  (t8.IP =3D ?)

  &nb= sp;   AND

   &n= bsp;  (

    &nb= sp;    (

  &nbs= p;         (t7.ID =3D t0.ID)

       &nbs= p;    AND

  &nb= sp;         (

          &= nbsp;    (t6.ID =3D t0.ID)

            &= nbsp;  AND

    =            (

        &nbs= p;         (t5.ID =3D t0.ID)

       &nbs= p;          AND

=

         =          (

          &n= bsp;          (t4.ID =3D t0.ID= )

      &n= bsp;            = ;  AND

    &nbs= p;            &= nbsp;   (

   &n= bsp;            = ;        (t3.ID =3D t0.ID)

         = ;            &n= bsp;  AND ((t2.ID =3D t0.ID) AND (t1.ID =3D t0.ID))

         &nbs= p;           )=

        &n= bsp;         )

          =      )

  &= nbsp;         )

         )

        = AND (t0.DTYPE =3D 'CHASSIS_9145E_104_0_0')

      )

&nb= sp;  )

   AND ((t9.AGENT_= MANAGED_HARDWARE_ID =3D t0.ID) AND (t8.SNMPDEVICE_ID =3D t9.ID))=

)        &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;            &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =         |true |false|NULL

6ebdc076-0147-b12d-b252-000065089f97|APP &nb= sp;            =             &nb= sp;            =             &nb= sp;            =              &n= bsp;            = ;            &n= bsp;            = ;          |SELECT * FROM= SYSCS_DIAG.STATEMENT_CACHE

  =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =              &n= bsp;|true |true |NULL

c5bf806d-0147-b12d= -b252-000065089f97|SYS         = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;   |SELECT    M->allProceduresAreCallable()= ,  M->allTablesAreSelectable(),

= M->supportsCatalogsInTableDefinitions(),     &n= bsp;  M->supportsCatalogsInIndexDefinitions(),   &nb= sp;    M->supportsCatalogsInPrivilegeDefinitions(), =    M->supportsPositionedDelete(),  M->supportsPosition= edUpdate(),  M->supportsSelectForUpdate(),

2589c06b-0147-b12d-b252-000065089f97|CSEM   &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;            =         |CALL SYSIBM.MetaData()

        =             &nb= sp;            =             &nb= sp;            =             &nb= sp;             = ;            &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;            = ;       |true |true |NULL

=
= --_000_97EB699F861AD841B5908C7CA9C9565602C8665CFA76VSERVER1can_--