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

INITCAP FUNCTION IN TERADATA

INITCAP FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INITCAP FUNCTION IN TERADATA Purpose  Modifies a string argument and returns the string with the first character in each word in uppercase and all other characters in lowercase. Words are delimited by white… Read More

INSTR FUNCTION IN TERADATA

INSTR FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INSTR FUNCTION IN TERADATA Purpose  Searches the source_string argument for occurrences of search_string. Syntax  TD_SYSFNLIB : the name of the database where the function is located. source_string: a character string or string… Read More

LENGTH FUNCTION IN TERADATA

LENGTH FUNCTION IN TERADATA Dear Readers, In this article, we will learn about LENGTH FUNCTION IN TERADATA Purpose  Returns the number of characters in the string argument. Syntax    TD_SYSFNLIB : the name of the database where the function is located. string : a character… Read More

LTRIM FUNCTION IN TERADATA

LTRIM FUNCTION IN TERADATA Dear Readers, In this article, we will learn about LTRIM FUNCTION IN TERADATA Purpose  Returns the string argument string1, with its left-most characters removed up to the first character that is not in the string argument string2. Syntax  TD_SYSFNLIB : The… Read More

OREPLACE FUNCTION IN TERADATA

OREPLACE FUNCTION IN TERADATA Dear Readers, In this article, we will learn about OREPLACE FUNCTION IN TERADATA Purpose  Replaces every occurrence of search_string in the source_string with the replace_string. Use this function either to replace or remove portions of a string. Syntax: TD_SYSFNLIB : the… Read More