New release of utils2_ak! Also some great news!
Posted in 2021
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Triggers, Constraints & Referential Integrity, Jobs, Consulting & Announcements
Folks, I uploaded an update of utils2_ak to my web site (www.askdbmgt.com/my-utilities) GREAT NEWS! The ESQL/C bug that has prevented dbcopy from copying lvarchar type columns since v3.50.xC5 (over 10 years) has finally been fixed as of CSDK v4.50.FC5! Yippee! That means that only remaining limitations on using dbcopy are having more than one BYTE or TEXT column or CLOB or BLOB columns (coming soon). Added new features: -A - lock the source table in exclusive mode. When used with -a (lock target table) this can make dbcopy run MUCH faster! -G - Print run time and data copy rate during and following the copy. -v - Verbose status display that includes processing steps not otherwise displayed. -c disable active triggers on the source table. Re-enable them after the copy completes. -C disable active triggers on the target table. Re-enable them after the copy completes. The -c & -C prevent SELECT and INSERT triggers on the tables from firing during the mass copy. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------ #Informix