Employing Open Query File and ASNA DataGate® ^® for SQL Server^®

If your application makes use of the Open Query File with DataGate® for SQL Server, the following restrictions apply:

• The string passed in the QrySelect must comply with the syntax of SQL Server, for example you should use the word 'and' not the symbol '&'.
• If you are changing the order of the file by providing a value in the QryKeyFlds parameter, you must:
  • Specify RANDOM(*NO) in the DCLDISKFILE to state that you will be accessing this file only consecutively.
  • Open the file for *INPUT only