MySQL Table Creation |
Virtual Machine |
 |
The file Definition in PROIV is also known as a logical file. It defines the format of the data fields in a file. Each physical file used by PROIV must have at least one logical File Definition, but may have more depending upon the application.
To create a new file definition of type MySQL follow these steps:
-
On the PROIV Developer toolbar, click the arrow next to the New icon
and select 
. Alternatively, click the Developer menu, hover the mouse on the New option and then click New File Definition.
The Name the new file definition window appears. -
In the File name box, enter the file name. This is the logical file name for the File Definition.
-
In the Description box, enter the description.
-
On the File Type list, select MYSQL.
-
On the Category list, select the required security category for the File Definition.
-
In the Physical File box, enter the name physical file where the data gets stored. If you do not enter a name for the physical file, the logical file name is used as the physical file name. Alternatively, you can also specify a database in the Physical File box. The format is %SECTIONNAME% where SECTIONNAME refers to the appropriate DATABASE section in the PROIV configuration file. The PROIV Kernel automatically connects to that database when an attempt to access the file is made. The logical file name will be used as the table name.
-
To get the details from the existing file definition, under Copy from file group, select the existing file from which you can copy details from.
-
In the Copy as group, select the appropriate option:
-
Select New File to create a new file with the same fields but with no relationship. It can be changed with no impact on the original file definition.
-
Select Child to create a new logical view on the original file, identical in all aspects except that the file name and fields will have the suffix added. This cannot be edited, but it is kept in step with the original if the original is edited.
-
Select Associate to create file which is similar to a Child File but can be edited and is not automatically kept in step with original. You can specify a suffix that gets appended to the copied fields to identify them as copied. These can be applied to Key Fields, Fields or both.
-
-
Click OK to create the File Definition.
The Editing File Definition window appears. -
Enter the File Variables for the File Definition. Refer to File Definition Window for more information. The window does not open if the file is a Child File. However, if the file is copied, the File Variables are automatically populated.
-
Click Storage tab and configure the external storage types. Refer to MySQL External Storage Formats for more information.
-
To generate SQL scripts, click SQL tab. Refer to SQL Tab for more information.
Topic ID: 560025