SQL Statements
SQL statements are subject to the following restrictions:
• In the SQLVAR structure, nullable is managed when using is present in an SQL statement.
• Limit on the maximum number of columns selectable:
– Microsoft SQL: 1024
• Microsoft SQL Server does not set (on describe) the information about nullable (yes/no) 01xx in the sqltype field.
• Remarks (comments) embedded in SQL statements are not passed to the host DBMS. For example, Oracle optimizer hints cannot be sent to Oracle using remarks.