Teradata : How to get the server name using query -


How do I get the server name using the query in Teradata? That is, if I am writing a question on 'Dev' server, then he must return the Dev Server Name. For example, in Sybase: We will select the @@ Servers name.

There is nothing like @@ server name TD you can create a SQL UDF on each server Are, e.g.

  Repeat functions syslib. # Servername () returns VARCHAR (30) Language SQL is SQL SQL Ditermnistik reverse tap input SQL Security Defender COLLATION INVOKER inline type 1 returns Dev ' 

If the syslib , then it can be reached without qualification like this:

  SELECT #sernvername ();  

Comments

Popular posts from this blog

c++ - C/pp Sockets, recv()/send() works only under gdb -

GO: Serve static pages -

objective c - How to open front/back camera at the same time in iOS developing? -