Not able to select partitions (itgengpr015)

[trr]

In response to this topic: Selecting partitions/administrations via the use SQL statement.

How would this statement work for Twinfield? I have tried the following two, but without success:

use
select PROVIDER_DATA_CONTAINER_ALIAS
from   DataDictionary.Invantive.SYSTEMPARTITIONS@DataDictionary
where  short_name not in (company_code)

resulting in:

itgencun016:
itgengpr012:
Can not change active partitions to tfd since the partition ‘tfd’ does not exist.
Choose a set of only authorized and licensed partitions.

And:

use
select code
,      'tfd'
from   SystemDivisions@tfd
where  code not in (company_code)

resulting in:

itgencun016
itgengpr015
Unknown table ‘SYSTEMDIVISIONS’.
Possible valid alternatives: Twinfield.Twinfield.DistributionByPeriods, Twinfield.Twinfield.AnnualReportTotalsMulticurrency, Twinfield.Twinfield.Declarations.

[forums]

The first alternative can be reformulated as:

use
select code
,      PROVIDER_DATA_CONTAINER_ALIAS
from   DataDictionary.Invantive.SYSTEMPARTITIONS@DataDictionary
where  short_name not in (company_code)

since use with a SQL statement always requires specification of the alias, but only after specifying the partition code.

The second one can be reformulated as:

use
select code
,      'tfd'
from   Offices@tfd
where  code not in (company_code)

using Twinfield’s own specific list of companies instead of a generalized tables SystemPartitions@DataDictionary.

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.