602SQL Installation under Linux

602SQL for Linux is distributed in rpm packages format. Their installation must be executed by root:

rpm -ih /path_to_file/602sql11-xxx.rpm

Uninstallation is executed:

rpm -e 602sql11

rpm package name can differ according to the distribution mode: At SourceForge, the packages are marked by the date of issue, to differ from the older ones, e.g. 602sql11-2007-09-13.rpm; they can appear under the original identification 602sql11-server-1-0.i586.rpm.

The 602SQL package (602sql11-xxx.rpm file contains i.a. the following files:

/usr/bin/602sql11 - SQL server
/usr/bin/602gcli11 - graphics, full-valued client Development and operating environment
/usr/bin/602mng11 - graphics Server Manager
/usr/bin/602cli11 - row-oriented test client
/usr/bin/helpview11 - graphics help viewer (usage: helpview11 /usr/share/doc/602sql11/602sql11[cs|en].zip)
/etc/602sql - configuration file 602sql with comments
/etc/init.d/s602sql11 - script for batch server start in the background
/usr/lib/602sql11/lib602krnl11.so* - library of functions for client access to the server
/usr/lib/602sql11/lib602xml11.so* - XML extense
/usr/lib/602sql11/libodbc60211.so* - ODBC driver
/usr/lib/602sql11/libwx_*.so.* - wxWidgets libraries
/usr/lib/602sql11/libxerces_*.so.* - Xerces
/usr/lib/602sql11/ftx/*.* - fulltext converters (external utilities to extract words from binary documents)
/usr/share/602sql11/*.* - auxiliary files (dictionaries for fulltext stemming, icons in XPM and other things)
/usr/share/locale/cs_CZ|sk_SK/LC_MESSAGES/602gcli10.mo - translations of client environment strings into Czech and Slovak languages
/usr/share/doc/602sql11/602sql11[cs|en].zip - electronic documentation in a format for a client or helpview11 program
/usr/share/man/man1/602* - very brief pages of manuals for programs referring to help

Installation of the 602SQL basic package executes, apart from copying, following actions:

If nonexistent, then sql602 user is created; in his/her account the SQL server can be started.
If /etc/602sql configuration file is already existing, it is maintained (it is not overwritten by the file from package).
If chkconfig program is available, then it ensures calling of /etc/init.d/s602sql11 script at operating system start and shutdown and thus an automated start and shutdown of SQL server group that operate as daemons.
Information of the 602sql database file are appended to data of the file program.
If the unixODBC package has been already installed, then it registers the ODBC driver for 602sql server in it.

The sample configuration file /etc/602sql contains registration of a database named testdb located in /var/lib/602sql11/testdb directory, or a database named 602Office_db located in /var/lib/602sql11/602Office_db directory. Actual database file comes into being at the first server start. You can read more about start and operation of the SQL server on Linux here.

Drivers, header files and libraries for access via standard interface are not included in the 602sql package (with the exception of the odbc driver) and can be downloaded separately (some of them even in the source format). The SDBC driver installation is done manually from the OpenOffice.org environment.

Linux distribution without the rpm system

On Linux installations that do not include rpm (Ubuntu, Debian, Slackware), necessary 602SQL files can be unpacked from the 602sql11-binary-xx.tar.gz compressed archive that is available at vendor´site.

Files, including their location, can be listed from the rpm package, e.g.

rpm2cpio 602sql11-*.rpm | cpio -t

and unpack and copy them using, e.g., commands

rpm2cpio 602sql11-*.rpm | cpio -idv

or using Midnight Commander.

Programs with graphical interface

The 602gcliXX program - 602SQL Development Client is used for SQL server management and configuration, application development and for editing data in tables. Server Manager is used for start and stop of SQL servers. Programs are identical to those for Windows.

602SQL Installation on Windows

Installation of the 602SQL