New utility: fcopy-table.pl, Perl application to copy/extract one table or view to another table

Hi Family. As Art knows, I've been fighting with github and sourceforge, trying to get my new utility into the SQL-Tools section of the repository. While that issue gets resolved, I figured I could share it with my community by posting it in a shared folder in my Google Drive. The utility is called fcopy-table; a Perl program. Now, I know Art is working on a new version of his table-copy utility, using the quasi-documented (i.e. known only to friends of Art :-) hidden column ifmx_row_id. It might be fun to benchmark them against each other and I would not be upset at losing that one. We are both attacking the same goal. But fcopy-table does not work the same way and, when I used it at a client site it managed well over 1 million rows per minute. So what advantage *does* fcopy-table have? Like Art's, one can tack on a WHERE clause to narrow the scope of the copy. Unlike Art's, one can skip a number of rows and limit the number of rows copied. (Two separate options) Since fcopy-table hasn't a clue if the source table is really a table or if it's a view, you can use it to realize a view into a real table. Here, ifmx_row_id is utterly useless because the concept of a row ID does not apply to a view. Interested? Y'all can view the shared directory here and download it. There are 3 files: fcopy-table.pl, the Perl source code. This is the important one; the others are arguable helpful. fcopy-table.help.txt, simple the output of the --help option. I really ought to create a POD for it and post that as well but I have my lazy moments. fcopy-table.pl.pdf, a 2-up printable listing of the source code. Have fun, family! -- Jacob Salomon ------------------------------ Jacob Salomon --- Nobody goes there anymore, it's too crowded. --Attr: Yogi Berra ------------------------------ #Informix

Just testing ------------------------------ Art Kagel ------------------------------

#Informix