Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2000 @ 21:21:53 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023