RTRIM FUNCTION IN TERADATA

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

SCALAR UDF IN TERADATA

SCALAR UDF IN TERADATA Dear Readers, In this article, we will learn about SCALAR UDF IN TERADATA Purpose Takes input arguments and returns a single value result. Syntax For UDFs that are defined with parameters of TD_ANYTYPE data type:       udf_name The name… Read More

SOUNDEX FUNCTION IN TERADATA

SOUNDEX FUNCTION IN TERADATA Dear Readers, In this article you will get to know the SOUNDEX FUNCTION IN TERADATA Purpose  Returns a character string that represents the Soundex code for string_expression. Syntax : string_expression : a character string or expression that contains a surname to… Read More

STRING_CS FUNCTION IN TERADATA

STRING_CS FUNCTION IN TERADATA Dear Readers, In this article you will get to know the STRING_CS FUNCTION IN TERADATA Purpose  Returns a heuristically derived integer value that you can use to help determine which KANJI1-compatible client character set was used to encode string_expression. Note: The… Read More

STROK FUNCTION IN TERADATA

STROK FUNCTION IN TERADATA Dear Readers, In this article you will get to know the STROK FUNCTION IN TERADATA Purpose  Splits instring into tokens based on the specified list of delimiter characters and returns the nth token, where n is specified by the tokennum argument.… Read More

STROK_SPLIT_TO_TABLE IN TERADATA

STROK_SPLIT_TO_TABLE IN TERADATA Dear Readers, In this article you will get to know the STROK_SPLIT_TO_TABLE IN TERADATA Purpose  Splits strings into a table of tokens based on the provided delimiter(s) string. Note: STRTOK_SPLIT_TO_TABLE has similar semantics to the standard C/C++ library STRTOK function. Syntax  TD_SYSFNLIB… Read More

SUBSTRING/SUBSTR IN TERADATA

SUBSTRING/SUBSTR IN TERADATA Dear Readers, In this article you will get to know the SUBSTRING/SUBSTR IN TERADATA Purpose  Extracts a substring from a named string based on position. ANSI Syntax string_expression : a string expression from which the substring is to be extracted. n1 :… Read More

TD_UNPIVOT IN TERADATA

TD_UNPIVOT IN TERADATA Dear Readers, In this article you will get to know the TD_UNPIVOT IN TERADATA Purpose Transforms table columns into rows Syntax : TD_SYSFNLIB. Name of the database where the function is located. tableName The name of the table with the input data… Read More

TRANSLATE FUNCTION IN TERADATA

TRANSLATE FUNCTION IN TERADATA Dear Readers, In this article you will get to know the TRANSLATE FUNCTION IN TERADATA Purpose  Converts a character string or character string expression from one server character set to another server character set. Syntax  character_string_expression : a character string to… Read More

TRANSLATE_CHK IN TERADATA

TRANSLATE_CHK IN TERADATA Dear Readers, In this article you will get to know the TRANSLATE_CHK IN TERADATA Purpose  Determines if a TRANSLATE conversion can be performed without producing errors; returns an integer test result. Use TRANSLATE_CHK to filter untranslatable strings. You can choose to select… Read More