HowToTeraData: CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

Solution:-
Edit the file C:/WINDOWS/SYSTEM32/DRIVERS/ETC/HOSTS
Edit the following line as:-

127.0.0.1 localhost dbccop1

Close Bteq/Bteqwin and retry.

** How will you know it should be dbccop1 ?
In the tdpid,after cop it should be 1 as you are using on a local machine and there is only one RDBMS and before cop it should be dbc as you can verify your i_dbcpath variable value from C:\Program Files\Teradata\Client\13.0\CLIv2\clispb.dat.