Salesforce

Using the SQL Gateway (Magic xpa 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Using the SQL Gateway (Magic xpa 3.x)

To use the SQL Gateway to create tables and indexes, follow the procedure below:

  1. In the Options tab of the Database Properties dialog box, set the Keep Change Tables in Studio property to No.

  2. For the Magic xpa SQL Gateway, open the DB2/400 DBMS Properties dialog box and set the Check Existence property to No. The SQL Gateway does not create the tables automatically on the IBM i server.

  3. For running Direct SQL Tasks, use the ISAM database as the Result Database. It is recommended to define an ISAM database in the QTEMP library.

  4. Use the SQL View instead of the Link Join operation for better performance. Create the SQL View and populate the Data repository with the SQL View by using the Get Definition function. The SQL View requires a virtual unique key.

Reference
Attachment 
Attachment