Syntax
parseCreateRoleCommand = OMBCREATE ( ROLE "QUOTED_STRING" [ SET
"setPropertiesClause" ] )
setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "("
"propertyValueList" ")"
propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
propertyValueList = "propertyValue" { "," "propertyValue" }
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
Parameters
parseCreateRoleCommand
This clause creates a Warehouse Builder role.
setPropertiesClause
Used to set properties of a Warehouse Builder role. Valid properties are shown below.
getPropertiesClause
Basic properties for ROLE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the role
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the role
propertyNameList
A list of valid properties are shown in section of Basic properties for Role.
propertyValueList
A list of valid property value shown in section of Basic properties for Role.
propertyValue
The valid property value shown in section of Basic properties for Role.
