String - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last updated
2024-12-13
Published on
2024-12-13T13:15:51.808000
Function Description
B2D Converts a character string value into its decimal equivalent
B2X Converts a binary value to its hexadecimal equivalent in character format
BITCHR Convert a the binary representation of a string into a character string
C2X Converts a character data string into a hexadecimal format
EXCLUDE Removes characters from a data string that are not specified in a second inclusion character string
FIX Capitalizes the first letter of each word in a string of characters
LEFT Returns the leftmost portion of the data string as specified by a length parameter
LENGTH Returns the length of a character text string
LOWER Sets all of the characters in a text string to lower case
LTRIM Removes specified characters from the left of a data string
MID Extract a substring from a source data string based on starting position and length
MTRIM Trims specified characters throughout a character string
PRINTF Print a formatted string into a string
RIGHT Returns the rightmost portion of a data string as specified by a length parameter
RTRIM Removes specified characters from the right of a data string
SEARCH Returns the starting position of a search string within a source data string
STRING Sets a field or variable to a constant literal value(s)
TRANSLATE Translates (replace) a specific character in a data string with another character
TRIM Removes specified characters from the left and right of a data string
UPPER Sets all the characters in a text string to upper case
WORD Returns a specified word from a source data string, based on its position with the string
WORDS Returns the number of words in a source data string
X2B Converts a hexadecimal value to its binary value equivalent
X2C Converts a data string in hexadecimal format into a character data string