By providing an industry-standard application program interface (API) between Windows applications and BASIS databases, the BASIS ODBC/JDBC Driver gives users transparent access to corporate data. Utilizing a wide variety of ODBC/JDBC-aware tools such as spreadsheets, graphics programs and Web browsers, end users can make the best use of this valuable data.
Minimum + SQL Grammar and Level 1 API
Aggregate functions such as SUM, MEAN and MOD are available while functions like EXISTS, NOT EXISTS, IN and NOT IN have been added.
Data Abstraction with the BBjRecordSet
Additionally, the BBjRecordSet lets developers abstract the data handling code by providing a common interface for both file and SQL access. The SQL access lets developers incorporate data from any ODBC/JDBC-capable database into a BBj application.
BBjRecordSets offer developers a new and powerful way to view and manipulate data. Not only do they provide extensive capabilities in an easy-to-understand object-oriented manner, but they abstract the data, freeing the programmer from the detailed low-level file I/O operations that were necessary in the past. Using BBjRecordSets, developers can quickly access selected data in a few lines of code, and then easily search and manipulate that subset. After using BBjRecordSets a couple of times, developers may wonder how they ever programmed without them!
For more information about BBjRecordSets and Databound Controls, refer to the BBjRecordSet API documentation and the articles Using the BBjRecordSet, BBj Databound Controls, and Why Use the BBjRecordSet? published in the BASIS International Advantage.