Articles

Teradata Logical Operators

Dear Readers, In this article, we will see Teradata Logical Operators. Operators are symbols or words that cause an ‘operation’ to occur on one or more elements called ‘operands’. Logical expressions combine operands and operators to produce a Boolean (True/False) result. These expressions can be… Read More

DATE/TIME FUNCTIONS in Teradata

Dear Readers, Let’s understand what the date/time functions in teradata are and different operations associated with them. How is the date stored in Teradata ? Dates are stored as integer internally using the following formula. ((YEAR – 1900) * 10000) + (MONTH * 100) +… Read More

BTEQ TIPS in Teradata

Dear Readers, In this article, we will see BTEQ TIPS    Question :How to display more than 100 columns in BTEQ ? Answer: BTEQ Export defaults to a maximum of 100 columns to be SELECTED in the SELECT statement. Hence, when we try to run… Read More

SHOWLOCKS UTILITY

SHOWLOCKS UTILITY Dear Readers. In this article ,we will see SHOWLOCKS UTILITY The Show Locks utility, showlocks, provides information about Host Utility (HUT) locks placed on databases and tables by the Archive/Recovery (ARC) utility during database operations. These locks might interfere with application processing and… Read More

VARIOUS TABLES IN TERADATA

VARIOUS TABLES IN TERADATA Dear Readers. In this article ,we will see VARIOUS TABLES IN TERADATA Teradata supports the following table types to hold temporary data. Derived Table Volatile Table Global Temporary Table Derived Table Derived tables are created, used and dropped within a query.… Read More

STATISTICS COLLECTIONS AND RECOMMENDATIONS

STATISTICS COLLECTIONS AND RECOMMENDATIONS Dear Readers. In this article ,we will see STATISTICS COLLECTIONS AND RECOMMENDATIONS Statistical information is vital for the optimizer when it builds query plans. But collecting statistics can involve time and resources. By understanding and combining several different statistics gathering techniques,… Read More

ROW_NUMBER FUNCTION IN TERADATA

ROW_NUMBER FUNCTION IN TERADATA Dear Readers. In this article ,we will see ROW_NUMBER FUNCTION IN TERADATA Purpose  Returns the sequential row number, where the first row is number one, of the row within its window partition according to the window ordering of the window. Type… Read More

REGEXP_SUBSTR IN TERADATA

REGEXP_SUBSTR IN TERADATA Dear Readers. In this article ,we will see REGEXP_SUBSTR IN TERADATA Purpose  Extracts a substring from source_string that matches a regular expression specified by regexp_string. REGEXP_SUBSTR supports 2, 3, 4, or 5 parameters. Syntax  Where, TD_SYSFNLIB    : the name of the database… Read More

REG_REPLACE IN TERADATA

REG_REPLACE IN TERADATA Dear Readers. In this article ,we will see REG_REPLACE IN TERADATA Purpose  Replaces portions of source_string that match regexp_string with the replace_string. REGEXP_REPLACE supports 2, 3, 4, 5, or 6 parameters. Syntax Where, TD_SYSFNLIB    :  the name of the database where the… Read More

REGEXP_INSTR IN TERADATA

REGEXP_INSTR IN TERADATA In this article you will get to know the REGEXP_INSTR IN TERADATA Purpose  Searches source_string for a match to regexp_string. REGEXP_INSTR supports 2, 3, 4, 5, or 6 parameters. Syntax Where, TD_SYSFNLIB    :  the name of the database where the function is… Read More

RECOVERY MANAGER IN TERADATA

RECOVERY MANAGER IN TERADATA Dear Readers, In this article ,we will see RECOVERY MANAGER IN TERADATA The Recovery Manager utility, rcvmanager, monitors and provides information about the progress of a Teradata Database system in recovery, including transaction rollbacks, because of a Teradata Database system crash… Read More

PROFILES IN TERADATA

PROFILES IN TERADATA In this article you will get to know the PROFILES IN TERADATA About Profiles You can create profiles to define resource parameters for groups of users with similar needs instead of defining them for each individual user. Then list the profile in… Read More

More Latest News »