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

PACKDISK IN TERADATA

PACKDISK IN TERADATA In this article, we will see the PACKDISK IN TERADATA Purpose  The PACKDISK command arranges (packs and unpacks) data on the storage associated with the tables in the current scope, leaving a specified percentage, the free space percent (FSP), of the storage… Read More

EXPLAIN PLAN IN TERADATA

EXPLAIN PLAN IN TERADATA   In this article, we will see the explanation of plan in Teradata Explain plan is the step-by-step English translation of a query plan generated by the parsing engine. Explain plan can give you a clear picture the way optimizer will… Read More