## tableSpec ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR tableSpec_start((START)) tableSpec_start --> tableSpec_0_0[fullTableIdentifier] tableSpec_0_0 --> tableSpec_0_1[distributedAliasDirective] tableSpec_0_1 --> tableSpec_end((END)) ``` ## Purpose A table specification without parameters. The optional alias after the at-sign specifies a specific data source to be used, such as 'exactonlinerest..journals@eolbe' specifying the use of Exact Online Belgium when 'eolbe' is associated by the database definitions in settings.xml with Exact Online Belgium. number of special so-called 'service providers' are always present, such as 'datadictionary' for use by an alias. ## tableOrFunctionSpec ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart TD tableOrFunctionSpec_start((START)) tableOrFunctionSpec_start --> tableOrFunctionSpec_0_0[fullTableIdentifier] tableOrFunctionSpec_0_0 --> tableOrFunctionSpec_0_1[distributedAliasDirective] tableOrFunctionSpec_0_1 --> tableOrFunctionSpec_0_2[tableFunctionSpec] tableOrFunctionSpec_0_2 --> tableOrFunctionSpec_0_3[distributedAliasDirective] tableOrFunctionSpec_0_3 --> tableOrFunctionSpec_end((END)) ``` ## Purpose A table specification requiring a comma-separated list of parameters to determine the rows to be retrieved. Traditional SQL syntax did not provide for parameterized queries, matching set theory. Modern variants such as pipelined table functions allow a stored procedure or other imperative language-based approaches to generate rows based upon parameter values. Many data containers support queries that returns rows based upon parameter values. This holds especially for SOAP web services. Table specifications with parameters ease queries on such data containers. The optional alias after the at-sign specifies a specific data source to be used, such as 'exactonlinerest..journals@eolbe' specifying the use of Exact Online Belgium when 'eolbe' is associated by the database definitions in settings.xml with Exact Online Belgium. ## tableFunctionSpec ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR tableFunctionSpec_start((START)) tableFunctionSpec_start --> tableFunctionSpec_0_0["("]:::quoted tableFunctionSpec_0_0 --> tableFunctionSpec_0_1[numberedOrNamedExpressionList] tableFunctionSpec_0_1 --> tableFunctionSpec_0_2[")"]:::quoted tableFunctionSpec_0_2 --> tableFunctionSpec_end((END)) ``` ## Purpose A list of parameter value expressions identified by position or name to determine the rows to be retrieved by a tableOrFunctionSpec.