Accessing teradata tables from shell scripts

Database
Enthusiast

Accessing teradata tables from shell scripts

Hi,

Is there a way to access the teradata tables from shell scripts. Lets say we have to run a script in case of a load failure, Is it possible to access the error tables in the script and then mail a group based on the status. ?

Thanks in advance,
Arun
1 REPLY
Senior Apprentice

Re: Accessing teradata tables from shell scripts

Hi Arun,
you might use Perl to access Teradata via Geoffrey Rommel's Teradata::SQL

http://search.cpan.org/~grommel/Teradata-SQL-0.06/SQL.pm

Dieter