Creating IBM i Files Using the SQL Gateway (Magic xpa 3.x)
The process for creating IBM i files using the SQL gateway is similar to the process described in the Creating IBM i Files Using the ISAM Gateway topic, except that there is no limitation on the length of the table, field, or index names and you must define a unique key.
For better performance during application deployment, it is best to set the Check existence property to Yes.
To set the Check existence property:
-
From the data source entry in the Data repository, press Alt+Enter to open the Data Source Properties dialog box.
-
On the SQL tab, set Check Existence to Yes.
The Column and Index names are automatically defined by the Magic xpa SQL Gateway.
An example of source code used to create an SQL table and index on IBM i using the SQL Gateway is shown below:
