Distributed Relational Database Architecture › Commands for DRDA › YCVTDSTFIL: Convert Distributed Files to Configuration

YCVTDSTFIL: Convert Distributed Files to Configuration

The YCVTDSTFIL command allows you to create entries for distributed files in the Distributed File Configuration Table. The command preserves the entries in the table already made for a file in the following ways:

• If the file is distributed and has an entry in the Distributed File Configuration Table, no new entry is required.
• If the file is distributed and there is no entry in the Distributed File Configuration Table, an entry is created with the YGENRDB model value as the default RDB name.
• If the file exists in the Distributed File Configuration Table and is not Distributed, all entries for that file are removed from the Distributed File Configuration Table.

The YCVTDSTFIL command creates the physical file and logical files required for the Distributed File Configuration Table if they do not already exist in the named generation library. It uses the i OS Create Duplicate Object (CRTDUPOBJ) command and copies the template objects from Y2SY.

The YCVTDSTFIL command can be run outside of the model. To access the Display Convert Model Data Menu from the Display Services Menu, select the option Convert condition values to database file. From the Display Convert Model Data Menu, you can select the option to run the YCVTDSTFIL command.

Note: There are two approaches to removing distributed functionality.

• Change generated, distributed files to Distributed = N. Generate and compile the functions to remove distributed functionality. Entries in the Distributed File Configuration Table will be removed when you execute the YCVTDSTFIL command.
• As an alternative to changing the Distributed option for a file from Y to N, you can modify the Distributed File Configuration Table and change the RDB name to be the name for the local RDB. By manipulating the Distributed File Configuration Table, you can avoid changing the generated code, the SQL CONNECT is to the local system, and you do not have to generate the code again.