ASNA DataGate® for SQL Server Reference Manual

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