Syntax of DML Commands (Magic xpa 2.x)

The utility uses the existing connection to the data source selected and sends the function SQLExecDirect with a SQL command in the szSqlStr field.

After each command, the log indicates whether the command was successful or not.

Note: The table and index are actually created and dropped from the database that the data source points to.

CREATE TABLE T11025 (FLD1 CHAR(1), FLD2 CHAR(1))

**** Succeeded ****

CREATE UNIQUE INDEX I11025 ON T11025 (FLD1)

**** Succeeded ****

DROP INDEX I11025 ON T11025

**** Succeeded ****

DROP TABLE T11025

**** Succeeded ****

The utility disconnects from the data source using the SQLDisconnect function.

In order to do the same, simply select Connect\Full Disconnect.

******* Disconnected Successfully ... ******

******************************************************