Test Data Management
- Test Data Management 10.5.3
- All Products
Function
| Description
|
---|---|
CONCAT(string1, string2)
| Creates a single character string by joining two or more strings.
|
LOWER(str)
| Converts a string to lowercase.
|
SUBSTR(str,m,n)
| Returns a portion of a string, beginning and ending at specified positions in the string. m = start index and n = end index. Indexes start from 0. The substring is calculated from start index to end index-1.
|
UPPER(STR,m,n)
| Converts a string to uppercase.
|
Variable Name
| Description
|
---|---|
$PROJECTNAME
| The name of the project.
|
$PLANNAME
| The name of the plan.
|
$SOURCECONNECTIONNAME
| The name of the source connection in the plan.
|
$TARGETCONNECTIONNAME
| The name of the target connection in the plan.
|
$SOURCESCHEMANAME
| The name of the source schema in the plan.
|
$TARGETSCHEMANAME
| The name of the target schema in the plan.
|
$TABLENAME
| The name of the table in the workflow.
If you use the variable $TABLENAME in an expression, the variable is ignored in the name in the following situations:
|