QUERY  LOGGING IN TERADATA

QUERY  LOGGING Dear Readers, In this article, we will discuss QUERY  LOGGING What is query logging in teradata database and how it is implemented? Database Query Logging (DBQL) is a feature in Teradata that logs data in the predefined tables created under       … Read More

DIFFERENT SPACE ERRORS IN TERADATA

DIFFERENT SPACE ERRORS Dear Readers, In this article, we will discuss DIFFERENT SPACE ERRORS There are various Errorcodes that can be returned due to insufficient space. Some of them are 2507 2646 2644 Every errorcode has a different meaning and so is their cause and… Read More

SAMPLE FUNCTION IN TERADATA

SAMPLE FUNCTION Dear Readers, In this article, we will discuss SAMPLE FUNCTION As the name suggests, SAMPLE function will an idea on the data stored in the table/view by returning few numbers of rows specified either as a list of fractions of the total number… Read More

ABBREVIATIONS IN TERADATA

ABBREVIATIONS IN TERADATA Dear Readers, In this article, we will discuss ABBREVIATIONS IN TERADATA AccessRight Column Value Description AE ALTER EXTERNAL PROCEDURE AF ALTER FUNCTION AP ALTER PROCEDURE AS ABORT SESSION CA CREATE AUTHORIZATION CD CREATE DATABASE CE CREATE EXTERNAL PROCEDURE CF CREATE FUNCTION CG… Read More

TDWM Throttle Statistics

TDWM Throttle Statistics In this article you will get to know the TDWM Throttle Statistics This section describes about a Teradata Dynamic Workload Management SQL interface that is used to manage the workload and update the stored components (such as, WDs and related data) in the… Read More

COALESCE EXPRESSION IN TERADATA

Purpose of COALESCE expression Dear Readers, In this article you will get to know the Purpose of COALESCE expression It is used for NULL Handling. In the COALESCE expression, a list of arguments is passed. It is used to check if the arguments are NULL.… Read More

QUEUE TABLES

QUEUE TABLES Dear Readers, In this article you will get to know the QUEUE TABLES What is a Queue table ? It is a Teradata extension to ANSI SQL at the database/ table level. It is used to handle queue-oriented data, such as event processing and… Read More

Restricted Words In Teradata

Restricted Words In Teradata Dear Readers, In this article you will get to know the  Restricted Words in Teradata. What are restricted words ? Teradata Database and ANSI/ISO SQL standards restrict the use of certain words as identifiers because thosewords may be incorrectly interpreted as… Read More