More than 1 INI file ina Catalog

[suriakumar]

Sir

We are using Leagacy files (Non-Normazlized data file)

Each module has more pxplus data files.

Each Pxplus data file has Huge amount of Record typeS (Each record type has seperate MUSTBE value.  You have a attribute called "MUSTBE" when we create INI file).

Since each pxplus data file has multiple record type,  i am in a position to create huge amount of DATA TABLES to convert it.   I can not depend on single INI file to create all the tables.  IE.,  INI table has huge amount of table definition.  without depending on single INI file i am in a position to create multiple INI files for a single MODULE. 

So it is possible to use multiple INI files in a single catalog of PXPLUS SQL Server ? .  We have a CATALOG option in PXPLUS SQL SERVER Configuration where we use this ini file. IN this CATALOG field is it possible to enter more number of INI files ?  .  If not what are the other options to solve my problem.

SURIAKUMAR

[Devon Austen]

In your INI file were you specify the table name you can point to a alternate INI for were the table definition can be.

https://manual.pvxplus.com/page/odbc/table_definitions/ini_definition.htm

Look at the alternate option.

[suriakumar]

I AM having huge amount of tables.  Each INI file has 25 tables.  so i have multiple ini's.

Your documentaion does not have example such example.  Even the ALTERNATE ini also runs into error

SURIAKUMAR

[Devon Austen]

The setup to use multiple INI files is to have one INI file with all the table names and use the alternate to specify the INI file with the definition of that table. This way you could have one INI file for each table definition/layout and one INI file that is just a list of table names and INI paths. Nothing should be too big then.