having an issue with connecting to the teradata 13 server with bteq
if i do this
*** Error: Invalid Logon!
but if it try this
*** Logon Sucessfully complete
Thought it might have something to do with my /etc/hosts files. but i compared to our 13.10 release (I can logon just fine there too) and they are the similar. Also, I can connect just fine using Teradata Studio, using host:localhost User:dbc Pass:dbc
127.0.0.1 localhost dbccop1
Thanks ahead of time for any help and or assistance
The default system name is "dbc".
The old way for name resolution was to add COPx to the system name (e.g. localhost -> localhostCOP1).
ODBC/.NET/JDBC additionally try to resolve the system name without expansion, i can't remember when this was added to CLI.
You probably use different versions of BTEQ/CLI, 13 vs. 13.10.
There are some articles on similar topics:
I was just trying to run some insert statements as a script from bteq.
ie $>bteq < /tmp/script
insert table (...) values (...);
<200k insert statements of spatial data>
instead of was able to manually log in and still run
<prompt for user>dbc
<prompt for pass>dbc
so still scripted some what, but not fully.
Thanks for your links, was not able to figure out how to fully automate the scripts like i was in 13.10