“使用选择"表示法可指定“精确在线"数据容器的多个分区 [英] 'Use select' notation to specify multiple partitions of Exact Online data container

问题描述

我想在数据中心中选择一个活动分区.通常，我会使用以下语句:

I'd like to select an active partition in the Data Hub. Normally I would use the following statement:

INVANTIVE> use 1552839
2>
Exclamation itgendhb077: Error in Invantive Data Hub.
Database '1552839' does not exist. Make sure that the name is entered correctly.

这给出了一个错误.我注意到，当我为我的精确在线连接"使用别名时，它确实可以正常工作:

That gives an error. I noticed when I use the alias for my Exact Online Connection it does work so:

INVANTIVE> use 1552839@eol
2>
itgendhb018: 0 Rows Affected (111 ms)

但是我想执行以下操作，从SQL表中选择我想要的分区，但这是行不通的:

But I'd like to do the following, selecting the divisions I want from a SQL table, that doesn't work:

use select division_code from dc.rs.selected_admins@sql

替代方法也不起作用:

INVANTIVE> use select code from systemdivisions@eol sd inner join dc.rs.selected_admins@sql sa on sd.code = sa.division_code
2>
Exclamation itgendhb077: Error in Invantive Data Hub.
Database '1552839' does not exist. Make sure that the name is entered correctly.

推荐答案

如果未指定别名，则将使用"sortingorder"来解决第一个连接的数据容器.根据错误消息的类型，可能是SQL Server数据库.

When the alias is not specified, the first connected data container in terms of "sortingorder" is addressed. Given the type of error message, that is probably a SQL Server database.

假设您正在寻找一种在特定数据容器中指定分区的方法，则最佳方法是使用:

Assuming that you are looking for a way to specify the partitions in a specific data container, the best approach is to use:

use select code partitioncode, 'eol' datacontaineralias from ...

这与得出以下结果相同:

This is identical to taking the outcome of:

select 'use ' || lst from ( select listagg(code || '@' || eol') lst from ... )

然后执行那个.

当然，当您连接了多个数据容器(如Exact Online Belgium，荷兰以及Loket和Nmbrs)时，可以在一个use语句中全部提供它们.

Of course, when you have multiple data containers connected like Exact Online Belgium, the Netherlands and Loket and Nmbrs, you can provide them all in one use statement.

这篇关于“使用选择"表示法可指定“精确在线"数据容器的多个分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！