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 columnssince 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 makedbcopy 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