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

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