Folks:

I just uploaded an update to the utils2_ak package to my web site (My Utilities) that contains an update to myschema:

Fixed handling of NOT NULL constraints with FILTERING! Thanks to David Grove for identifying the issue and JC at
HCL for pointing me at the solution!

FYI: All of the utils2_ak utilities are v15 ready (though support for new Informix v15 features are not included in the current release). I will upload an update containing support for new v15 features as soon as v15 is released!

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Hello Art,

Please, what IDS versions is your fix_ipa compatible with?

------------------------------
Sincerely,
Dennis
------------------------------

Dennis:

It has been tested and used on 12.10 & 14.10 and tested on v15Beta. Note that in v12.10 and the earliest v14.10 releases (prior to xC7) it will likely be slow on any partitioned table because it has to use ifx_row_id which was treated as an unindexed normal column prior to 14.10FC7 (after that it is properly treated as a physical row address ala ROWID).

Art

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Tue December 03, 2024 02:16 AM
From: Dennis Melnikov
Subject: Updated utils2_ak package available

Hello Art,

Please, what IDS versions is your fix_ipa compatible with?

------------------------------
Sincerely,
Dennis
------------------------------