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.