Archives of the TeradataForum

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

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

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>>