@SF186017, It sounds like it is having trouble collect the metadata from the Teradata VM data dictionary. Can you disconnect and reconnect the connection profile and see if that helps?
@tjfoley, The issue with the parameters inside strings is treated differently with Studio than SQLA.
In SQLA, parameters are simply text substitution markers. They aren't SQL parameters. So, question marks inside strings are simply question marks inside strings. If you want to have parameterized strings they might try using string concatenation, as you mentioned above, to create the parameterized string:
'First part of string ' || ? || ' rest of string'
Parameter placeholders in SQL represent constants so they have to appear where a constant can (which is not inside a quoted string).
As for repeated parameters within the SQL, we will add that improvement to the list of items for future release.
I am unable to connect ther server :
it is giving the below error :
Mahesh, the stack trace shows a JDBC error UnknownHostException error. This means that the hostname SAIRAM is not known. Try the IP address or update your hosts file to include the hostname SAIRAM.
Thanks for your response.
i have tried like this .
opened the drivers file -- > ETC -- > Hosts File --> Copied the IP Address of the local host
and pasted in the database server name and followed remaining.
Still , I am unable to connect ..
Please suggest , if above is wrong.
Any step - by step guide is more help full.
Mahesh, What happens when you enter the IP address into Studio connection profile dialog for the database server name?
I'm using Teradata Studio 14.10 (connecting to Aster) and trying to look for the position of the '?' character within a string. The following query wont work in Teradata Studio however, it's working just find when I use Aster act tool.
SELECT position('?' IN 'hello?') FROM sometable;
Thanks fgrimmer for the quick respond. I'm using 14.10.01. Do you know if there's any workaround?