Handling MSSQL's Multi-Format Limitation

Overview

Although DGL tries to make SQL Server look like DB2 for IBM i, support for Multi-format files is not provided by DGL.

DGL implements a physical file through the use of a native SQL Server table. A logical file is implemented through a native view. SQL Server Views are single formatted in nature, so there is no support for multi-format logical data files. You will have to eliminate any reference to multi-format logical files in your application.

Print files, which are typically multi-format, are fully supported in DGL.