User's Guide Part V. The SQL Anywhere Programming InterfacesWSQL HLI is a high level callable interface which allows you to access data in SQL Anywhere databases from a variety of applications and programming environments. This chapter documents the WSQL HLI programming interface.
WSQL HLI is available as a DLL for Windows, OS/2 and Windows NT.
The WSQL HLI call interface allows you to access information in SQL Anywhere databases from a programming environment such as Visual Basic in Windows or REXX in OS/2. It allows programmers to use a record-at-a-time cursored database interface similar to Embedded SQL or a set-at-a-time interface similar to the WSQL DDE Server . WSQL HLI can process queries and database commands using host variables, return query results from both individual fields and entire query result sets, and provide error information. Most of the functionality is provided by the wsqlexec function which takes a string as a parameter. This string is parsed by WSQL HLI, and the appropriate Embedded SQL commands are executed.
DLL concepts Using WSQL HLI Host variables with WSQL HLI WSQL HLI functions wsqlexec command strings CLIP HLI Statement CLOSE HLI Statement COMMIT HLI Statement DECLARE HLI Statement DROP HLI Statement EXECUTE HLI Statement FETCH HLI Statement OPEN HLI Statement PREPARE HLI Statement ROLLBACK HLI Statement SET CONNECTION HLI Statement START USING DATABASE HLI Statement STOP USING DATABASE HLI Statement WSQL HLI and Visual Basic WSQL HLI and REXX