Solutions Application Development SQLer


SQLer for Open Systems

SQLer is a module to develop portable applications, independent from the relational database used. SQLer implements the XPG3 specifications to build a database, to modify its structure and to access the data. SQLer translates these specifications towards the target database management systems.
Using SQLer in open mode, the developers can also use the target dynamic SQL dialect directly.
SQLer supports the host-based and the client/server architectures.

Data Definition Language

Starting from a conceptual model and an internal schema, SQLer produces a command file for the SQL interpreter of the target database.
The internal schema maps the conceptual domain definitions of SQLer upon the data types supported by the target database. The index management is included in the internal schema. SQLer always enforces entity integrity and provides referential integrity on request.
You can change an existing database with the SQLer DDL. You don't need to unload and reload your data when changing the database schema. New columns are created with their default value. When a column data type is modified, the data are converted from the old data type to the new one.

Data Manipulation Language

The SQLer DML takes care of the data type conversion between the databases and the host language. SQLer provides standard error messages but still allows to read and test the database specific (native) error messages. Of course, SQLer DML allows to access any stored procedures.

Host-based SQLer (4 modes)

  • Standard SQL
    SQLer translates XPG3 compliant SQL commands into embedded SQL for C or to specific API calls for the target databases. The types are checked against the definitions in the conceptual schema.
  • Record SQL
    As an extension of standard SQL, this mode facilitates the use of cursors to access the database one row, one table at a time (database navigation).
  • Dynamic SQL
    Using this mode, the XPG3 compliant SQL commands are built, verified and translated at run-time.
  • Open SQL
    With this mode, the SQL commands are built at run-time using the target RDBMS SQL-dialect.

Available platforms

  • Operating systems: HP-UX, MPE/XL, MPE/iX, AIX, MS-Windows
  • Database systems: Allbase, ORACLE, SYBASE, INFORMIX
  • Host programming languages: SYDAID/C, C/C++
  • Network: TCP/IP
Benefits
  • portability of your applications at source level towards any combination of supported target databases and operating systems
  • saving in training time for the SQL language
  • reduce the investment for proprietary database client/server connections
  • reduce the database maintenance time and burden
  • save development time with the navigation mode (record SQL)
 
Subscribe here for our free WEBISO and STARJET
Workshops!