I want to connect to teradata.net via batch file. Version of teradata i am using is 13.10, i don't know whether it has bteq enabled or not?
Also i have tried sqla -c DBNAME [[\userid]\pwd] and it gives me error : not enough information to logon. When I write my IP in place of DBNAME the error changes to : data source name not found and no default driver specified
Can any tell me how to solve this issue?
if you don't show the actual query it's hard to tell, but it looks like you wrote CREATE QUEUE TABLE xxx instead of CREATE TABLE xxx, QUEUE
The query :
the create works for me using SQL Assistant plus dotNet.
If it's a SLECECT AND CONSUME it must be a plain select without any WHERE/JOIN/GROUP/ORDER. Without CONSUME you can do whatever you want.
Thanks for the info.
I tried to change from Teradata.net to odbc, it does not work. This is the first time I am working with this setup Teradata.net. I dont have any idea about it. Even some OLAP queries like---- with sum(...) by fields, it is complaining.
WITH SUM is not an OLAP query, it's a proprietary syntax for BTEQ reports which doesn't return a tabular result set and therefore can't be displayed in an answer set grid.