SQL Restrictions

<< Click to Display Table of Contents >>

Navigation:  General Functions > Import / Export > Secure File Transfer > Direct Database Transfers > Defining a query >

SQL Restrictions

The client will not allow the following SQL statements:

1. INSERT

2. UPDATE

3. Stored procedures

4. Multiple statements

Your statement must be a SELECT statement.  It may be a SELECT using JOIN and/or UNION running directly against one or more tables or views.