Archives of the TeradataForum
Message Posted: Thu, 22 Jun 2000 @ 21:21:53 GMT
| Subj: || || Re: C Preprocessor2 Alternatives |
| From: || || Mark Landry |
If you want to do procedural processing against the Teradata using a programming language, I would urge you to seriously consider PERL.
It's an interpretive language that executes very fast and is ideal for processing database records. PERL is a widely-used, open-source
product available from www.perl.org. It's available for Windows, UNIX and even OS/390.
As a quick experiment I implemented the CLI sample application using PERL. The results are that the PERL program using an ODBC driver is
only 26 lines compared to over 340 for the equivalent C program. And it runs only one half second slower. Moral: don't waste you time
writing C code for business processing that's dominated by the speed of the database.
I've attached a sample program so you can see how it works.