Uber Newb - trying to connect from Command line on AIX

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.

Uber Newb - trying to connect from Command...

Rate Topic

Display Mode

Topic Options

Author

Message

Steven007

Posted 5/8/2008 3:08:54 PM

Forum Newbie

Group: Forum Members
Last Login: 6/19/2008 3:50:40 PM
Posts: 2, Visits: 16

Hi everyone.,

I am trying to get a connection to a remote TeraData server from an AIX(Unix) command line. What tools do I need to Install and what documentation should I be looking at?

Seems everyone at my company uses a reporting tool through windows and no one has any experience in this area.

Thanks a bunch!

Post #11394

Xueling

Posted 5/13/2008 2:34:08 AM

Forum Newbie

Group: Forum Members
Last Login: 5/13/2008 4:43:06 PM
Posts: 5, Visits: 15

You need to install Teradata Tools and Utilities (TTU) 8.0 or 8.1, then use bteq (Teradata BTEQ Application) to connect and run your SQLs.

Post #11418

Xueling

Posted 5/13/2008 2:42:53 AM

Forum Newbie

Group: Forum Members
Last Login: 5/13/2008 4:43:06 PM
Posts: 5, Visits: 15

If you try to connect to the Teradara server on a Unix box, then use TTU & bteq; If you try to connect Teradata server on your window system, just need "Teradata SQL Assistant", or some other tools using ODBC to connect to any database servers

Post #11419

Steven007

Posted 5/13/2008 1:10:30 PM

Forum Newbie

Group: Forum Members
Last Login: 6/19/2008 3:50:40 PM
Posts: 2, Visits: 16

Thanks for your reply.
I downloaded and installed: TTU 8.2 AIX Power cliv2.04.08.02.00
I also installed the odbc drivers:
TTU 8.2 AIX-power32 tdodbc.03.06.00.02

Both from the download center. I cant find a bteq anywhere on the server it is installed under. any ideas?

Post #11427

Xueling

Posted 5/13/2008 2:18:16 PM

Forum Newbie

Group: Forum Members
Last Login: 5/13/2008 4:43:06 PM
Posts: 5, Visits: 15

Inside the TTU package, run setup.bat, the TTU Installation screen appears. Select bteq to install it.
After installation, type the following command to check:
pkginfo -l bteq
If your installation is successful, the information for bteq will display. Otherwise, bteq is not there and you have to re-install.

Xueling

Post #11428

« Prev Topic | Next Topic »

Reading This Topic

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 10:05pm