Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Oct 2002 @ 21:27:19 GMT


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


Subj:   Re: Perl Scipts and BTEQ
 
From:   Calvin W. Kline, jr.

Does anyone use BTEQ to interface with Teradata and a Perl Script? If so, how would you do this?

A. Pulling data: From a Windows command file (dot-bat or dot.cmd file) or UNIX script, execute bteq and .export the data to a file. Then read the (ASCII) file with the perl file system calls.

B. Storing data: From a Windows command file (dot-bat or dot.cmd file) or UNIX script, execute the perl program which reads the data to be stored from some source, and generate or execute another Windows command file (dot-bat or dot.cmd file) or UNIX script to (1) perform a series of bteq SQL INSERT commands, (2) perform a bteq .import command, (3) use a ML/FL to store the data.

C. Interactively, use the perl ODBC interfaces.

Are there more efficient or better ways to access data from Teradata within a Perl Application? It depends on the requirements of the application system.



     
  <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