BTEQ Connection


BTEQ Connection

I want to connect to a remote machine using BTEQ from my system (DEMO Teradata installed).The entry has been added to the hosts file , I can ping the machine using the alias .
But while I try to connect through BTEQ it's giving me following error
*** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

*** Return code from CLI is: 224
*** Error: Logon failed!
Message Remedy in the message manual is "Check the DBC/1012 name."

Could some one please help me understand what does that mean (DBC/1012)?

Your inputs will be highly appreciated.

Re: BTEQ Connection

Hi KM,
when you log on via bteq, you have stg like this:

.logon /,;

suppose that your server's name is TDSERVER, you need to:
1. write in the bteq file: .LOGON TDSERVER/,
2. have in you hosts file an entry like this: address of the server) TDSERVER TDSERVERCOP1

Remember that BTEQ can connect to the server using the hosts file.

Let me know if you need further detail.


Re: BTEQ Connection


Your BTEQ must start with
.logon TDEMO/USERID,password;

It think for the TeraData demo it is
.logon TDmon/dbc,dbc;

Also BTEQ will not work unless your etc host file does not contain the following entery

# Copyright (c) 1993-1999 Microsoft Corp.
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
# For example:
# # source server
# # x client host localhost TDEMO tdemocop1 is the IP Address of your PC or the server where this server resides.