Derived Column Element

Documentation

Derived Column Element

API Type:

Varigence.Languages.Biml.Transformation.AstDerivedColumnNode

X-Ref:

Ast Derived Column Node

Attributes

Attribute	API Type	Default	Description
DataType	DbType		This value specifies the type of the derived column node using a .NET DbType. This is a required property
Name	String		Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property
CodePage	Int32	0	This value specifies the integer index for the codepage of the derived column. This property applies only to derived column types that support code pages, such as strings. Codepages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx.
Length	Int32	0	This value specifies the length parameter for the column type associated with this column. This property applies only to column types that support a length specification, such as String and Binary types.
Precision	Int32	0	This value specifies the precision, or the number of digits in a value. This property applies only to derived column types that support precision, such as decimal.
ReplaceExisting	Boolean	false	This value specifies whether this derived column definition should (1) replace an existing derived column definition with the same name or (2) create a new derived column with its own unique lineage.
Scale	Int32	0	This value specifies the scale, the number of digits to the right of the decimal point in a value. This property applies only to derived column types that support precision, such as decimal.
SsisDataTypeOverride	SsisDataType	Varigence.Utility.DataType.SsisDataType.DT_EMPTY	Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the DataType property.

Collection Children

Child	API Type	Description
<Annotations> <Annotation /> </Annotations>	AstAnnotationNode	This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.