|
|||||||||||
|
|||||||||||
|
 FULL SQL SUPPORT Supports ODBC SQL (Insert, Update, Select, and Delete). Supports group by and distinct and aggregate functions (AVG, MIN, MAX, SUM, and COUNT). Support for all string, date, conversion, and math functions. Supports nested inner and outer left/right joins. Supports subqueries and correlated subqueries. Supports substring and date functions. Support for Unions and Insert/Select. SYBASE SUPPORT CONNX supports full access to OLEDB or ODBC enabled Sybase data sources allowing one or many Sybase data sources and other supported CONNX data sources to be presented as a single federated relational data source. MULTITHREADED ASYNCHRONOUS EXECUTION Supports the ODBC Asynchronous execution model and true 32bit threads for each SQL Statement being executed. This feature makes it possible to have a query running in the background while per-forming other meaningful work. DATA CONVERSION CONNX supports all ODBC data types including BLOBs, and CLOBs (Binary Large Objects and Character Large Objects). COMPATIBILITY CONNX works with any SQL based OLEDB or ODBC compliant application. CONNX has been tested with 32bit Versions of Microsoft Access, Microsoft Studio including Visual Basic/ C++ etc, Crystal Reports, Delphi, PowerBuilder, Impromptu, Lotus Approach, and I.Q. Support for ADO,ASP (Active Server Pages). FAST JOINS, FAST THROUGHPUT CONNX has turbo charged its proprietary RFFA Technology, resulting in faster multi-table joins between and within data sources, and an increase in speed when performing searches on non-Keyed fields. FAST CONNX DATA DICTIONARY The CONNX data dictionary uses the Microsoft Component Object Model (COM) format, resulting in Fast access to information in the data dictionary, and fast queries. MASS RECORD DEFINITION IMPORTS CONNX imports table & view definitions directly from your Sybase data sources. SECURITY CONNX respects all existing database security. The CONNX CDD utility supports setting up field and Table level security by group as well as individuals. CONNX also supports row level security with CONNX Views. Additionally, the CONNX data dictionary is encrypted to secure sensitive information. VIEWS CONNX supports the creation of views, which facil-itate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases. WIZARDS CONNX includes a Wizard that greatly reduces startup time, and truly provides instant access to your data. CONNX also includes application wizards for Microsoft Access, Visual Basic, Crystal Reports and Impromptu. SYSTEM REQUIREMENTS PC:
|
