The following Technical Notes deal with SQL issues in Magic xpa:
Implementing Scalar Queries with Magic xpa
Informix ODBC Driver Database Error
Defining an ODBC Data Source
Setting Up Communication to a Database Via ODBC on 64-bit Systems
Connecting to an MSSQL Instance that Is Not Using the Default Port
Securing a Database Connection Between MSSQL and Magic xpa
Creating a Top One Link
Using Comments in a Direct SQL Task
Calling a Stored Procedure and Passing a NULL as a Valid Value
Using a MSSQL Table with Bigint Fields
Using and Operating an Oracle Global Temporary Table