Good catch. I rechecked. Don't know what happened (forget to recompile
after changing source???). But I deleted the table and recreated it using
the DDS as unique key. Now it is closer to the SQL constraint. Good news
/ bad news. Good news - SQL is not the culprit. Bad news - some people
may use this information to continue not having keys on a physical file
(even though 95+% of their updates will involve some use of a key anyway).
However, if I add this "standard" logical
R IIMJOER PFILE(IIMJOE)
Against that same physical file then you will see the same times.
So, why not just have the UNIQUE key on the physical?
This thread ...
Re: Which of the SYSIBM tables/views show the row count for, (continued)
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact