IPrimaryMsSqlSPLD.FileGroup

Fore Syntax

FileGroup: String;

Fore.NET Syntax

FileGroup: System.String;

Description

The FileGroup property determines a file group for creating tables.

Comments

By default the DEFAULT value, meaning that, if a user name is not entered, the file group, set in database properties by default, has to be used when connecting, is used.

Fore Example

To execute the example, add the Metabase system assembly to the module.

Sub UserProc;
Var
    MbMan: IMetabaseManager;
    MbDefs: IMetabaseDefinitions;
    MbDef: IMetabaseDefinition;
    MsSqlSPLD: IPrimaryMsSqlSPLD;
Begin
    MbMan := MetabaseManagerFactory.Active;
    MbDefs := MbMan.Definitions;
    MbDef := MbDefs.Add;
    MbDef.DriverId := "MSSQL2008";
    MbDef.Id := "Test_MSSQL";
    MbDef.Name := "Test_MSSQL";
    MbDef.Authentication := AuthenticationMode.Password;
    MbDef.SecurityPackage := "STANDARDSECURITYPACKAGE";
    MsSqlSPLD := MbDef.LogonData As IPrimaryMsSqlSPLD;
    MsSqlSPLD.Server := "Test_MS";
    MsSqlSPLD.DatabaseOnly := "DB_Repository";
    MsSqlSPLD.SchemaOnly := "UserSchema";
    MsSqlSPLD.FileGroup := "file group on DB server";
    MbDef.Save;
End Sub UserProc;

A new description of the repository is created after executing this example. The UserSchema user schema in the specified database is used for connection. The MS SQL Server 2008 DBMS is used on the Test_MS server. The "file group on DB server" is used to create tables.

Fore.NET Example

The Main procedure is an entry point for .NET assembly.

Imports Prognoz.Platform.Interop.Metabase;

...

Public Shared Sub Main(Params: StartParams);
Var
    MbMan: IMetabaseManager;
    MbDefs: IMetabaseDefinitions;
    MbDef: IMetabaseDefinition;
    MsSqlSPLD: IPrimaryMsSqlSPLD;
    MF: IMetabaseManagerFactory;
Begin
    MF := New MetabaseManagerFactoryClass();
    MbMan := MF.Active;
    MbDefs := MbMan.Definitions;
    MbDef := MbDefs.Add();
    MbDef.DriverId := "MSSQL2008";
    MbDef.Id := "Test_MSSQL1";
    MbDef.Name := "Test_MSSQL1";
    MbDef.Authentication := AuthenticationMode.amPassword;
    MbDef.SecurityPackage := "STANDARDSECURITYPACKAGE";
    MsSqlSPLD := MbDef.LogonData As IPrimaryMsSqlSPLD;
    MsSqlSPLD.Server := "Test_MS";
    MsSqlSPLD.DatabaseOnly := "DB_Repository";
    MsSqlSPLD.SchemaOnly := "UserSchema";
    MsSqlSPLD.FileGroup := "file group on DB server";
    MbDef.Save();
End Sub;