Connectivity to bteq through Perl Script
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Connectivity to bteq through Perl Script Expand / Collapse
Author
Message
Posted 7/3/2008 3:20:01 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2 days ago @ 5:45:16 AM
Posts: 22, Visits: 54
I want to connect to bteq using Perl script and i am unaware of how to do this?
In Shell script it is very simple,
Bteq<<-END
.logon .....
...
.quit ...
END

but what is the syntex for perl?

Please help me out .


Thanks
Kunal
Post #12022
Posted 7/3/2008 11:46:27 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 11/25/2008 1:20:39 PM
Posts: 91, Visits: 119
Here are your free choices:

1. Use the open source from CPAN

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

2. Write your own by piping to BTEQ. Something like: open("BFH","|bteq") || die $!;

Suggest you get a Perl book to learn about piping to processes.
Post #12027
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:47pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.125. 9 queries. Compression Disabled.