HXTT Cobol 3.0.016

HXTT Cobol is a comprehensive software package that offers unique features for managing Cobol data. One of its standout features is the inclusion of type 4 JDBC driver packages, which support various types of Cobol data such as FB (fixed block) files, VB (variable block) files, FB sequential files, VB sequential files, FB relative files, IBM mainframe line sequential files, PC line sequential files, Open Cobol MVS VB files, Fujitsu NetCOBOL VB files, MicroFocus VB sequential files, MicroFocus VB relative files, AcuCobol Vision data files, and more.

The software supports Cobol Copybook files, Cobol source programs (including free format, fixed format, Fujitsu-Siemens style, and Tandem Non-stop style), FD files, SEL files, as well as ASCII and EBCDIC encodings. It offers transactional capabilities, embedded access, remote access, client/server mode, and the ability to create memory-only databases. Additionally, HXTT Cobol supports compressed databases in various formats like ZIP, JAR, GZ, TAR, BZ2, 7z, TGZ, TAR.GZ, and TAR.BZ2, as well as SAMBA databases (smb) and URL databases (http, https, ftp, sftp).

The software utilizes an embedded Pure Java database engine, allowing Cobol databases to be deployed and accessed on any platform with a Java Virtual Machine (JVM). It seamlessly integrates with different versions of JDBC (1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3) and provides SQL92 support, eliminating the need for special coding by programmers. Moreover, it allows database administrators to easily access local and remote data using any Java database tool.

HXTT Cobol offers several compelling reasons to consider using it. First, it boasts high performance with its small footprint and transactional-oriented database engine. It supports embedded and client/server modes for mobile systems and can handle join operations, GROUP BY, ORDER BY, and DISTINCT on large tables with significant data volumes. The software has demonstrated faster speeds compared to other databases in PolePosition database benchmark tests.

The flexibility of HXTT Cobol is another key advantage. It automatically detects the data format for various Cobol file types, including FB files, VB files, sequential files, relative files, and more. The SQL capabilities allow fetching data from different column types, such as atomic columns, virtual columns, alias columns, redefined columns, repeated columns, and array columns without the need for a predefined data dictionary. It intelligently loads data layouts from Cobol-related files based on different Cobol dialects, including COBOL 68, COBOL 74, COBOL 1985, RM COBOL, MF COBOL, IBM COBOL, COBOL II, Microsoft COBOL, Fujitsu COBOL, AS400 COBOL, ACUCOBOL, CA Realia COBOL, Tandem NonStop COBOL, and Open Cobol. HXTT Cobol also supports a wide range of data types, including BINARY, COMP, COMPUTATIONAL, COMP-1, COMP-2, COMP-3, COMP-4, COMP-5, COMP-6, COMP-X, DISPLAY, DISPLAY-1, NATIONAL, and PACKED-DECIMAL.

Beyond SQL92 compatibility, HXTT Cobol supports numerous SQL:2008 enhancements, over 230 SQL functions, open user-defined SQL function APIs, XOPEN SQLState, RMI, Jini, JNDI, and serialization. It enables advanced querying features such as { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] queries, various types of joins (INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self-join), grouping functions (GROUP_CONCAT, GROUPING, WITH ROLLUP, WITH CUBE), multi-row VALUES table, PIVOT table, UNPIVOT table, and subqueries (single-row, multirow, multiple-column, inline views, and correlated subqueries). The software facilitates seamless data mining operations on memory-only tables, physical tables, URL tables, SAMBA tables, and compressed tables using SQL.

HXTT Cobol supports different data access modes, including embedded mode, client/server mode, and remote access through protocols like map network drive, SAMBA, HTTP, HTTPS, FTP, SFTP, and UNC path. It prioritizes data security by providing user/password verification, SSL encrypted connections, and customizable connection options. Various encryption algorithms such as DES, Triple DES, Blowfish, and AES are supported at both the SQL and database level.

Transaction support is a core feature of HXTT Cobol, with compatibility for different transaction levels including READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. The software also handles concurrent database connections and ensures thread safety.

HXTT Cobol's type 4 JDBC drivers are entirely written in Java, making them deployable on any platform with Java VM support. This includes operating systems like Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, SCO Unix, UNIX, and LINUX.

The software extends its functionality to seamlessly handle files and directories within ZIP, GZIP, BZ2, 7z, and TAR file formats, which can be accessed through JDBC URLs and SQL. It also supports seamless integration with databases accessed through HTTP, HTTPS, FTP, and SFTP URLs. Additionally, HXTT Cobol supports SAMBA databases accessed via SMB URLs. It offers the ability to work with memory-only databases for internal data processing, applets, and special applications. Furthermore, it can read databases from standard or compressed java.io.InputStream objects.

HXTT Cobol ensures compatibility across multiple JVM versions, including Personal Java, JDK 1.0.X, JDK 1.1.X, JDK 1.2.X, JDK 1.3.X, JDK 1.4.X, JDK 1.5.X, JDK 1.6.X, JDK 1.7.X, JDK 1.8.X, Java 9, Java 10, and Java 11. It supports various JDBC versions (1.2, 2.0, 3.0, 4.0, 4.1, 4.2, 4.3), along with features like Connection Pooling, DataSource, Distributed Transaction, and RowSet. HXTT Cobol integrates with several development tools and utilities, including Borland's BDE, Borland's Database Desktop, JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, iSQL-Viewer, AquaDataStudio, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, Crystal Reports, Jisql, RazorSQL, and DbEdit Database Utilities for the Eclipse Platform.

Internationalization is another noteworthy aspect of HXTT Cobol. It supports all Unicode, locales, and encodings provided by the JVM. Additionally, it offers extra support for specific encodings such as Cp895 (Czech MS-DOS 895), Cp620 (Polish MS-DOS 620), and Mazovia, even though they are not natively supported by the JVM.

Lastly, HXTT Cobol provides a user-friendly GUI database server manager for client/server mode. This manager offers remote control capabilities and can be configured to run as a Windows service, Unix/Linux daemon, or standalone application.