|
|||||||||||
|
|||||||||||
 
|
 CONNX AND DB2, 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. SQL SERVER SUPPORT CONNX supports full access to OLEDB or ODBC enabled SQL Server data sources allowing one or many SQL Server 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 SQL Server 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 facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases. WIZARDS CONNX includes a Data Dictionary Wizard that greatly reduces startup time, and truly provides instant access to data. CONNX also includes application wizards for Microsoft Access, Visual Basic, Crystal Reports and Impromptu. SQL PASSTHROUGH CONNX optimises performance by analysing SQL statements to determine if they can be directly passed to the target database. STATIC SQL Support for invocation of pre-compiled SQL (Static SQL), improving performance. STORED PROCEDURES Support for the invocation of compiled host code. COMMAND EXECUTION CONNX provides an RPC (Remote Procedure Call) mechanism that allows remote execution of batch jobs, command procedures, AS/400 Command Language (CL), and applications from a PC. SYSTEM REQUIREMENTS PC:
SERVER:
|
