File Open Considerations for ISAM Access and SQL Access (Magic xpa 3.x)
Files are opened according to the Access mode specified in the Data View Editor.
Keys are not opened until they are actually used. Magic xpa will create a key if one does not already exist the first time the key is used in the program.
Before the file is opened, Magic xpa compares the file level identifier of the IBM i file with the FILELEVEL= keyword value specified in the Information for SQL Database window on the SQL tab of the Data Source Properties dialog box. Magic xpa will not open the file if these two values are not identical.
If the keyword RECLVL= is specified in the Information for SQL Database window, and the record level ID matches the value of this keyword, the file will open successfully even if the FILELEVEL does not match.
Joined views can be opened by defining a program which specifies opening the view in read-only mode. An attempt to open a joined view for updating will result in an error message and program termination.
For a list of keywords, see the Database Information - ISAM Gateway topic.
For SQL, indexes are created immediately.
