Welcome to OS2.GURU site! (eComStation.RU)

Available databases

• MySQL (it lacks visual constructor) + phpmyadmin (WEB based administrator tool for MySQL)
• Lotus Approach is not available in the shops
• OpenOffice.org 1.1.x - doesn't have Database
• OpenOffice.org 2.0 - doesn't work
  • no Java support
  • MySQL V.4 + UNIXODBC + fixed odbc.dll
  • MySQL V.5 + UNIXODBC -- waiting..
• DBExpert -- Sundial systems, not available
• Postgres SQL (old versions, new experimental versions) + phpPgAdmin (WEB based administrator tool for PostgreSQL)
• SQLite, SQLite browser
• HSQLDB - Java based SQL database that can be run standalone or embedded into a Java application.

Documentation

• IBM DB2 for OS/2 (russian documentation)

Tutorials

• 1. ODBC on OS/2 (part 1, Part 2, Part 3, Part 4, Part 5, Part 6, Part 7, Part 8, Part 9, Part 10, Part 11, Part 12)
• 2. How to create a database using Lotus Smartsuite (part 1, part 2, part 3, part 4, part 5, part 6)
• 3. In close collaboration: MySQL and OS/2
  • Part 1: MySQL installation
  • Part 2: Creating the database
  • Part 3: Commands of console and SQL
  • Part 4: Insert and Select commands
  • Part 5: Update and Delete commands
  • Part 6: Accessing MySQL from REXX

FAQ

Q: How to setup MySQL?
A: a) readme.os2 -> For new users, to create the initial databases.. b) start mysqld.exe

The information is provided by: Yuri Dario, J. W. Ulbts, Stanislav Radchenko

Q: How to create small database and calculate home expenses using rexx?