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