SQLFunctionSpec Attributes

The following attributes are available within the root SQLFunctionSpec element on page definition specs.

Attribute	Type	Description
xmlns	bb_appfx_sqlfunction	The xmlns determines what tags are available.
xmlns:c	bb_appfx_commontypes	Reference common tools for the SDK.
ID	Unique GUID	Required. The database ID to use for this item in the catalog table.
Name	String	Required. A friendly name to use when displaying this item in the catalog browser.
Description	String	Required. A description of this catalog item.
Author	String	Required. The author of this catalog item.
CountryAddressFormatName	String	Optional. Indicates that this function defines a country address format. The value is the name of the format.
DBFunctionName	String	Required. Indicates the database name of the function.
DBFunctionSchema	String	Optional. Indicates database schema of the function.
GrantServiceRolePermission	Boolean	Optional. Default value = "false". Used to indicate if a SQL function/stored proc loaded via a spec needs to have the BBAPPFXSERVICEROLE granted rights to it. This should only be true for functions/procs that are called directly from code executing in the service process. If the function is called from another function (such as a dataform) then there is no need to specify this attribute.
IsNameFormatFunction	Boolean	Optional. Indicates that this function defines a name format. A true value indicates this is a name format function.
MartKey	String	Optional. Indicates where the SQL function defined in the CreateFunctionSQL is created. When no option is specified the SQL function is created in the application database; otherwise, it is created in the OLAP data source provided.