Author: Raj

teradata 1

Check SQL history in Teradata

Checking SQL history in Teradata can be very important.Few of the key points can be : Check commands you executed in Teradata. Check commands executed by other users in Teradata. Who modified any object...

teradata 1

How to check CASESPECIFIC in Teradata

We all know that Teradata by default is case insensitive.Even the column definitions while creating a table is NOT CASESPECIFIC by default.However if the requirement is to create a column as casespecific then what...

Unix Linux 1

Kill process after specific time in UNIX

We may come across a situation when one of our process may take more time than expected which may eventually result in affecting other processes in UNIX.Suppose we have a script which is performing...

Unix Linux 0

Execute C program in UNIX

To execute a C program in UNIX , we need a file which have  ‘C’ code in it.In this example we will print “My name is Nitin Srivastava”.Let us first create a C program...

teradata 1

Use of Teradata Qualify Row Number

We can use Teradata Qualify Row Number to have an alternate solution to Group by clause or using distinct. The keyword “Qualify” works on the final resultset before it is returned to the user....

teradata 1

Teradata Help Commands

Let us see the various help commands and their uses in Teradata. HELP SESSION; This command is used to display the user name, account name, logon date and time, current database name, collation code...