Changes for page 12 Validation and Transformation Language (VTL)
Last modified by Artur on 2025/09/10 11:19
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -537,9 +537,9 @@ 537 537 538 538 **Figure 22 – VTL Data Types** 539 539 540 -The [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] scalar types are in turn subdivided in basic scalar types, which are elementary (not defined in term of other data types) and Value Domain and Set scalar types, which are defined in terms of the basic scalar types.540 +The VTL scalar types are in turn subdivided in basic scalar types, which are elementary (not defined in term of other data types) and Value Domain and Set scalar types, which are defined in terms of the basic scalar types. 541 541 542 -The [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar types are listed below and follow a hierarchical structure in terms of supersets/subsets (e.g. "scalar" is the superset of all the basic scalar types):542 +The VTL basic scalar types are listed below and follow a hierarchical structure in terms of supersets/subsets (e.g. "scalar" is the superset of all the basic scalar types): 543 543 544 544 [[image:1750070310572-584.png]] 545 545 ... ... @@ -547,28 +547,28 @@ 547 547 548 548 === 12.4.2 VTL basic scalar types and SDMX data types === 549 549 550 -The [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] assumes that a basic scalar type has a unique internal[[representation>>doc:sdmx:Glossary.Representation.WebHome]]and can have more external[[representations>>doc:sdmx:Glossary.Representation.WebHome]].550 +The VTL assumes that a basic scalar type has a unique internal representation and can have more external representations. 551 551 552 -The internal [[representation>>doc:sdmx:Glossary.Representation.WebHome]]is the format used within a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] system to represent (and process) all the scalar values of a certain type. In principle, this format is hidden and not necessarily known by users. The external[[representations>>doc:sdmx:Glossary.Representation.WebHome]]are instead the external formats of the values of a certain basic scalar type, i.e. the formats known by the users. For example, the internal[[representation>>doc:sdmx:Glossary.Representation.WebHome]]of the dates can be an integer counting the days since a predefined date (e.g. from 01/01/4713 BC up to 31/12/5874897 AD like in Postgres) while two possible external[[representations>>doc:sdmx:Glossary.Representation.WebHome]]are the formats YYYY-MMGG and MM-GG-YYYY (e.g. respectively 2010-12-31 and 12-31-2010).552 +The internal representation is the format used within a VTL system to represent (and process) all the scalar values of a certain type. In principle, this format is hidden and not necessarily known by users. The external representations are instead the external formats of the values of a certain basic scalar type, i.e. the formats known by the users. For example, the internal representation of the dates can be an integer counting the days since a predefined date (e.g. from 01/01/4713 BC up to 31/12/5874897 AD like in Postgres) while two possible external representations are the formats YYYY-MMGG and MM-GG-YYYY (e.g. respectively 2010-12-31 and 12-31-2010). 553 553 554 -The internal [[representation>>doc:sdmx:Glossary.Representation.WebHome]]is the reference format that allows[[VTL>>doc:sdmx:Glossary.Validationandtransformationlanguage.WebHome]] to operate on more values of the same type (for example on more dates) even if such values have different external formats: these values are all converted to the unique internal[[representation>>doc:sdmx:Glossary.Representation.WebHome]]so that they can be composed together (e.g. to find the more recent date, to find the time span between these dates and so on).554 +The internal representation is the reference format that allows VTL to operate on more values of the same type (for example on more dates) even if such values have different external formats: these values are all converted to the unique internal representation so that they can be composed together (e.g. to find the more recent date, to find the time span between these dates and so on). 555 555 556 -The [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] assumes that a unique internal[[representation>>doc:sdmx:Glossary.Representation.WebHome]]exists for each basic scalar type but does not prescribe any particular format for it, leaving the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] systems free to using they preferred or already existing internal format. By consequence, in[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] the basic scalar types are abstractions not associated to a specific format.556 +The VTL assumes that a unique internal representation exists for each basic scalar type but does not prescribe any particular format for it, leaving the VTL systems free to using they preferred or already existing internal format. By consequence, in VTL the basic scalar types are abstractions not associated to a specific format. 557 557 558 - [[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data types are conceived instead to support the data exchange, therefore they do have a format, which is known by the users and correspond, in[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] terms, to external[[representations>>doc:sdmx:Glossary.Representation.WebHome]].Therefore, for each[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type there can be more[[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data types (the latter are explained in the section "General Notes for Implementers" of this document and are actually much more numerous than the former).558 +SDMX data types are conceived instead to support the data exchange, therefore they do have a format, which is known by the users and correspond, in VTL terms, to external representations. Therefore, for each VTL basic scalar type there can be more SDMX data types (the latter are explained in the section "General Notes for Implementers" of this document and are actually much more numerous than the former). 559 559 560 -The following paragraphs describe the mapping between the [[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data types and the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar types. This mapping shall be presented in the two directions of possible conversion, i.e. from[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]to [[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] andvice-versa.560 +The following paragraphs describe the mapping between the SDMX data types and the VTL basic scalar types. This mapping shall be presented in the two directions of possible conversion, i.e. from SDMX to VTL and vice-versa. 561 561 562 -The conversion from [[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]to [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]happens when an[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]]acts as inputs of a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Transformation. As already said, in fact, at compile time the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] needs to know the[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] type of the operands in order to check their compliance with the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] operators and at runtime it must convert the values from their external ([[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]])[[representations>>doc:sdmx:Glossary.Representation.WebHome]]to the corresponding internal ([[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]]) ones.562 +The conversion from SDMX to VTL happens when an SDMX artefact acts as inputs of a VTL Transformation. As already said, in fact, at compile time the VTL needs to know the VTL type of the operands in order to check their compliance with the VTL operators and at runtime it must convert the values from their external (SDMX) representations to the corresponding internal (VTL) ones. 563 563 564 -The opposite conversion, i.e. from [[VTL>>doc:sdmx:Glossary.Validationandtransformationlanguage.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]], happens when a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] result, i.e. a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] [[Data Set>>doc:sdmx:Glossary.Dataset.WebHome]] output of a Transformation, must become a[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]](or part of it). The values of the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] result must be converted into the desired ([[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]]) external[[representations>>doc:sdmx:Glossary.Representation.WebHome]](data types) of the[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[artefact>>doc:sdmx:Glossary.Artefact.WebHome]].564 +The opposite conversion, i.e. from VTL to SDMX, happens when a VTL result, i.e. a VTL Data Set output of a Transformation, must become a SDMX artefact (or part of it). The values of the VTL result must be converted into the desired (SDMX) external representations (data types) of the SDMX artefact. 565 565 566 566 === 12.4.3 Mapping SDMX data types to VTL basic scalar types === 567 567 568 -The following table describes the default mapping for converting from the [[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data types to the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar types.568 +The following table describes the default mapping for converting from the SDMX data types to the VTL basic scalar types. 569 569 570 570 (% style="width:583.294px" %) 571 -|(% style="width:360px" %) [[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data type (BasicComponentDataType)|(% style="width:221px" %)Default[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type571 +|(% style="width:360px" %)SDMX data type (BasicComponentDataType)|(% style="width:221px" %)Default VTL basic scalar type 572 572 |(% style="width:360px" %)((( 573 573 String 574 574 (string allowing any character) ... ... @@ -603,7 +603,7 @@ 603 603 Short 604 604 (corresponds to XML Schema xs:short datatype; between -32768 and -32767 (inclusive)) 605 605 )))|(% style="width:221px" %)integer 606 -|(% style="width:360px" %) [[Decimal>>doc:sdmx:Glossary.Decimals.WebHome]](corresponds to XML Schema xs:[[decimal>>doc:sdmx:Glossary.Decimals.WebHome]]datatype; subset of real numbers that can be represented as[[decimals>>doc:sdmx:Glossary.Decimals.WebHome]])|(% style="width:221px" %)number606 +|(% style="width:360px" %)Decimal (corresponds to XML Schema xs:decimal datatype; subset of real numbers that can be represented as decimals)|(% style="width:221px" %)number 607 607 |(% style="width:360px" %)((( 608 608 Float 609 609 (corresponds to XML Schema xs:float datatype; patterned after the IEEE single-precision 32-bit floating point type) ... ... @@ -614,7 +614,7 @@ 614 614 )))|(% style="width:221px" %)number 615 615 |(% style="width:360px" %)((( 616 616 Boolean 617 -(corresponds to the XML Schema xs:boolean datatype; support the mathematical (% style="color:#e74c3c" %)concept(%%)of617 +(corresponds to the XML Schema xs:boolean datatype; support the mathematical concept of 618 618 binary-valued logic: {true, false}) 619 619 )))|(% style="width:221px" %)boolean 620 620 |(% style="width:360px" %)((( ... ... @@ -627,15 +627,15 @@ 627 627 )))|(% style="width:221px" %)integer 628 628 |(% style="width:360px" %)((( 629 629 InclusiveValueRange 630 -( [[decimal>>doc:sdmx:Glossary.Decimals.WebHome]]number within a closed interval, whose bounds are specified in the[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[representation>>doc:sdmx:Glossary.Representation.WebHome]]by the[[facets>>doc:sdmx:Glossary.Facet.WebHome]]minValue and maxValue)630 +(decimal number within a closed interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue) 631 631 )))|(% style="width:221px" %)number 632 632 |(% style="width:360px" %)((( 633 633 ExclusiveValueRange 634 -( [[decimal>>doc:sdmx:Glossary.Decimals.WebHome]]number within an open interval, whose bounds are specified in the[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[representation>>doc:sdmx:Glossary.Representation.WebHome]]by the[[facets>>doc:sdmx:Glossary.Facet.WebHome]]minValue and maxValue)634 +(decimal number within an open interval, whose bounds are specified in the SDMX representation by the facets minValue and maxValue) 635 635 )))|(% style="width:221px" %)number 636 636 |(% style="width:360px" %)((( 637 637 Incremental 638 -( [[decimal>>doc:sdmx:Glossary.Decimals.WebHome]]number the increased by a specific interval (defined by the interval[[facet>>doc:sdmx:Glossary.Facet.WebHome]]), which is typically enforced outside of the XML validation)638 +(decimal number the increased by a specific interval (defined by the interval facet), which is typically enforced outside of the XML validation) 639 639 )))|(% style="width:221px" %)number 640 640 |(% style="width:360px" %)((( 641 641 ObservationalTimePeriod ... ... @@ -692,19 +692,19 @@ 692 692 )))|(% style="width:221px" %)date 693 693 |(% style="width:360px" %)((( 694 694 TimeRange 695 -(YYYY-MM-DD(Thh:mm:ss)?/) 695 +(YYYY-MM-DD(Thh:mm:ss)?/<duration>) 696 696 )))|(% style="width:221px" %)time 697 697 |(% style="width:360px" %)((( 698 698 Month 699 -(MM; speicifies a month independent of a year; e.g. February is black history month in the United States) 699 +(~-~-MM; speicifies a month independent of a year; e.g. February is black history month in the United States) 700 700 )))|(% style="width:221px" %)string 701 701 |(% style="width:360px" %)((( 702 702 MonthDay 703 -(MM-DD; specifies a day within a month independent of a year; e.g. Christmas is December 25^^th^^; used to specify reporting year start day) 703 +(~-~-MM-DD; specifies a day within a month independent of a year; e.g. Christmas is December 25^^th^^; used to specify reporting year start day) 704 704 )))|(% style="width:221px" %)string 705 705 |(% style="width:360px" %)((( 706 706 Day 707 -(-DD; specifies a day independent of a month or year; e.g. the 15^^th^^ is payday) 707 +(~-~--DD; specifies a day independent of a month or year; e.g. the 15^^th^^ is payday) 708 708 )))|(% style="width:221px" %)string 709 709 |(% style="width:360px" %)((( 710 710 Time ... ... @@ -721,7 +721,7 @@ 721 721 722 722 **Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types** 723 723 724 -When [[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] takes in input[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]], it is assumed that a type conversion according to the table above always happens. In case a different[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type is desired, it can be achieved in the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]program taking in input the default[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type above and applying to it the[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] type conversion features (see the implicit and explicit type conversion and the "cast" operator in the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Reference Manual).724 +When VTL takes in input SDMX artefacts, it is assumed that a type conversion according to the table above always happens. In case a different VTL basic scalar type is desired, it can be achieved in the VTL program taking in input the default VTL basic scalar type above and applying to it the VTL type conversion features (see the implicit and explicit type conversion and the "cast" operator in the VTL Reference Manual). 725 725 726 726 === 12.4.4 Mapping VTL basic scalar types to SDMX data types === 727 727 ... ... @@ -751,9 +751,9 @@ 751 751 752 752 **Figure 14 – Mappings from SDMX data types to VTL Basic Scalar Types** 753 753 754 -In case a different default conversion is desired, it can be achieved through the CustomTypeScheme and CustomType [[artefacts>>doc:sdmx:Glossary.Artefact.WebHome]](see also the section Transformations and Expressions of the[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]information model).754 +In case a different default conversion is desired, it can be achieved through the CustomTypeScheme and CustomType artefacts (see also the section Transformations and Expressions of the SDMX information model). 755 755 756 -The custom output formats can be specified by means of the [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] formatting mask described in the section "Type Conversion and Formatting Mask" of the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Reference Manual. Such a section describes the masks for the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar types "number", "integer", "date", "time", "time_period" and "duration" and gives examples. As for the types "string" and "boolean" the[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]conventions are extended with some other special characters as described in the following table.756 +The custom output formats can be specified by means of the VTL formatting mask described in the section "Type Conversion and Formatting Mask" of the VTL Reference Manual. Such a section describes the masks for the VTL basic scalar types "number", "integer", "date", "time", "time_period" and "duration" and gives examples. As for the types "string" and "boolean" the VTL conventions are extended with some other special characters as described in the following table. 757 757 758 758 (% style="width:717.294px" %) 759 759 |(% colspan="2" style="width:714px" %)VTL special characters for the formatting masks ... ... @@ -804,27 +804,27 @@ 804 804 |(% style="width:122px" %)N|(% style="width:591px" %)fixed number of digits used in the preceding textual representation of the month or the day 805 805 |(% style="width:122px" %) |(% style="width:591px" %) 806 806 807 -The default conversion, either standard or customized, can be used to deduce automatically the [[representation>>doc:sdmx:Glossary.Representation.WebHome]]of the[[components>>doc:sdmx:Glossary.Component.WebHome]]of the result of a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Transformation. In alternative, the[[representation>>doc:sdmx:Glossary.Representation.WebHome]]of the resulting[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[Dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]]can be given explicitly by providing its DataStructureDefinition. In other words, the[[representation>>doc:sdmx:Glossary.Representation.WebHome]]specified in the[[DSD>>doc:sdmx:Glossary.Data structure definition.WebHome]], if available, overrides any default conversion{{footnote}}The representation given in the DSD should obviously be compatible with the VTL data type.{{/footnote}}.807 +The default conversion, either standard or customized, can be used to deduce automatically the representation of the components of the result of a VTL Transformation. In alternative, the representation of the resulting SDMX Dataflow can be given explicitly by providing its DataStructureDefinition. In other words, the representation specified in the DSD, if available, overrides any default conversion{{footnote}}The representation given in the DSD should obviously be compatible with the VTL data type.{{/footnote}}. 808 808 809 809 === 12.4.3 Null Values === 810 810 811 -In the conversions from [[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]to [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] it is assumed by default that a missing value in[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] becomes a NULL in[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]].After the conversion, the NULLs can be manipulated through the proper[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] operators.811 +In the conversions from SDMX to VTL it is assumed by default that a missing value in SDMX becomes a NULL in VTL. After the conversion, the NULLs can be manipulated through the proper VTL operators. 812 812 813 -On the other side, the [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]programs can produce in output NULL values for[[Measures>>doc:sdmx:Glossary.Measure.WebHome]]and[[Attributes>>doc:sdmx:Glossary.Attribute.WebHome]](Null values are not allowed in the Identifiers). In the conversion from[[VTL>>doc:sdmx:Glossary.Validationandtransformationlanguage.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]], it is assumed that a NULL in[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] becomes a missing value in[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]].In the conversion from[[VTL>>doc:sdmx:Glossary.Validationandtransformationlanguage.WebHome]] to [[SDMX>>doc:sdmx:Glossary.Statistical data and metadata exchange.WebHome]], the default assumption can be overridden, separately for each[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type, by specifying which the value that represents the NULL in[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]is. This can be specified in the[[attribute>>doc:sdmx:Glossary.Attribute.WebHome]]"nullValue" of the CustomType[[artefact>>doc:sdmx:Glossary.Artefact.WebHome]](see also the section Transformations and Expressions of the[[SDMX information model>>doc:sdmx:Glossary.SDMX Information Model.WebHome]]). A CustomType belongs to a CustomTypeScheme, which can be referenced by one or more TransformationScheme (i.e.[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]programs). The overriding assumption is applied for all the[[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]] [[Dataflows>>doc:sdmx:Glossary.Dataflow.WebHome]]calculated in the TransformationScheme.813 +On the other side, the VTL programs can produce in output NULL values for Measures and Attributes (Null values are not allowed in the Identifiers). In the conversion from VTL to SDMX, it is assumed that a NULL in VTL becomes a missing value in SDMX. In the conversion from VTL to SDMX, the default assumption can be overridden, separately for each VTL basic scalar type, by specifying which the value that represents the NULL in SDMX is. This can be specified in the attribute "nullValue" of the CustomType artefact (see also the section Transformations and Expressions of the SDMX information model). A CustomType belongs to a CustomTypeScheme, which can be referenced by one or more TransformationScheme (i.e. VTL programs). The overriding assumption is applied for all the SDMX Dataflows calculated in the TransformationScheme. 814 814 815 815 === 12.4.5 Format of the literals used in VTL Transformations === 816 816 817 -The [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]programs can contain literals, i.e. specific values of certain data types written directly in the[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] definitions or expressions. The[[VTL>>doc:sdmx:Glossary.Validationandtransformation language.WebHome]] does not prescribe a specific format for the literals and leave the specific[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] systems and the definers of[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Transformations free of using their preferred formats.817 +The VTL programs can contain literals, i.e. specific values of certain data types written directly in the VTL definitions or expressions. The VTL does not prescribe a specific format for the literals and leave the specific VTL systems and the definers of VTL Transformations free of using their preferred formats. 818 818 819 -Given this discretion, it is essential to know which are the external [[representations>>doc:sdmx:Glossary.Representation.WebHome]]adopted for the literals in a[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]program, in order to interpret them correctly. For example, if the external format for the dates is YYYY-MM-DD the date literal 2010-0102 has the meaning of 2^^nd^^ January 2010, instead if the external format for the dates is YYYY-DD-MM the same literal has the meaning of 1^^st^^ February 2010.819 +Given this discretion, it is essential to know which are the external representations adopted for the literals in a VTL program, in order to interpret them correctly. For example, if the external format for the dates is YYYY-MM-DD the date literal 2010-0102 has the meaning of 2^^nd^^ January 2010, instead if the external format for the dates is YYYY-DD-MM the same literal has the meaning of 1^^st^^ February 2010. 820 820 821 -Hereinafter, i.e. in the [[SDMX>>doc:sdmx:Glossary.Statisticaldata and metadata exchange.WebHome]]implementation of the[[VTL>>doc:sdmx:Glossary.Validation and transformation language.WebHome]], it is assumed that the literals are expressed according to the "default output format" of the table of the previous paragraph ("Mapping[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar types to[[SDMX>>doc:sdmx:Glossary.Statisticaldataand metadata exchange.WebHome]] data types") unless otherwise specified.821 +Hereinafter, i.e. in the SDMX implementation of the VTL, it is assumed that the literals are expressed according to the "default output format" of the table of the previous paragraph ("Mapping VTL basic scalar types to SDMX data types") unless otherwise specified. 822 822 823 -A different format can be specified in the [[attribute>>doc:sdmx:Glossary.Attribute.WebHome]]"vtlLiteralFormat" of the CustomType[[artefact>>doc:sdmx:Glossary.Artefact.WebHome]](see also the section Transformations and Expressions of the[[SDMX information model>>doc:sdmx:Glossary.SDMX Information Model.WebHome]]).823 +A different format can be specified in the attribute "vtlLiteralFormat" of the CustomType artefact (see also the section Transformations and Expressions of the SDMX information model). 824 824 825 -Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type, if a value is found for the vtlLiteralFormat[[attribute>>doc:sdmx:Glossary.Attribute.WebHome]]of the CustomType of such[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]] basic scalar type. The overriding assumption is applied for all the literals of a related[[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]TransformationScheme.825 +Like in the case of the conversion of NULLs described in the previous paragraph, the overriding assumption is applied, for a certain VTL basic scalar type, if a value is found for the vtlLiteralFormat attribute of the CustomType of such VTL basic scalar type. The overriding assumption is applied for all the literals of a related VTL TransformationScheme. 826 826 827 -In case a literal is operand of a [[VTL>>doc:sdmx:Glossary.Validationand transformation language.WebHome]]Cast operation, the format specified in the Cast overrides all the possible otherwise specified formats.827 +In case a literal is operand of a VTL Cast operation, the format specified in the Cast overrides all the possible otherwise specified formats. 828 828 829 829 ---- 830 830