Skip to content

Page 1

Product Information

Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 211575B

Description of Product

With version B01 of SIBAS/R SQL Interactive for ND-500/5000 (SQLI-B01) you can write and execute queries, look at the result, and store queries in a database.

The product also contains the file REDEF-SQL, containing instructions to redefine a database with the system tables NDSQLT01 and NDSQLT02.

NDSQLT01 allows you to store queries in the database. NDSQLT02 allows you to protect individual tables against select, delete, update, or insert queries.

The schema definition for the DIALOGUE example database is also included. The file SQL-TUTORIAL-B01:LIST is a collection of examples from this database. It is produced by the batch input file SQL-TUTORIAL-B01:SQL.

Reason(s) for New Release

- The new SIBAS process with built in SQL server allows SQL
  programming from application programs.

- The Interactive Query Editor, SQLI-B01, is an updated version
  of the SQLI-A version, but can only use SIBAS with built in
  SQL server. SQLI-B01 sends queries to the database server for
  execution, just like an application program using the SQL
  Library. The old SQLI-A version can still be used, but cannot
  store queries in the new database.

ND-895615.1 EN

Page 2

Product Information

Date Norsk Data Page
90.10.17 Product Information 2 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

Table of Contents

Table of Contents Page
Prerequisites 3
Dependencies 4
Documentation 4
Installation procedure 5
Modifications 12
Errors corrected 14
Errors known but not corrected 14

ND-895615.1 EN

Scanned by Jonny Oddene for Sintran Data © 2011

Page 3

1 Prerequisites

The following things are required in order to use this product.

1.1 Hardware Prerequisites

The following hardware must be present for this product to be used:

CPU type (any of the following): - 500 - 5000

1.2 Software Prerequisites

The following software must be installed on the system for this product to be used:

Operating system:

Name Version/Revision
SINTRAN III - K >J1000B
SINTRAN III - L

Other software:

Product name Product number
SIBAS/R version B05 220001B05
UE-ERRORS, version D09 or later. 210586D

1.3 Other Prerequisites

The following are necessary for this product to be used.

Minimum Permanent Mass Storage:

User Space (pages) Number of files
SQL-SYS 1300 12

ND-895615.1 EN

Page 4

Product Information

Date Norsk Data Page
90.10.17 Product Information 4 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

2 Dependencies

SQLI is self-contained and does not depend on any other software.

3 Documentation

Included (distributed free with product)

Title Number
DIALOGUE - SQL User Guide 60.258.2 EN

ND-895615.1 EN

Page 5

Product Information

Date Produkt name Product number
90.10.17 SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

4 Installation Procedure

The installation process is fairly simple. SQLI is in the new domain format. All files should be copied to user SQL-SYS.

SIBAS/R B05 must have been installed! Then SQLI must be linked to Sibas library on Sintran user SIBR-B.

SQLI-B is language dependent. The text strings on the message and status lines are fetched from UE. The UE-ERMSG-xx-Dyy:ERR file on your system should therefore be D09 or later.

NOTIS-WP
SQLI calls NOTIS-WP as a subroutine when the user wants to look at the contents of a wide column.
SQLI in the new domain format and must be linked to NOTIS-WP in the new format.
The system therefore contains a special converted WP-500-N05.

4.1 Automatic Installation

The installation must be done manually.

4.2 Non-Automatic Installation

  1. Log in as SINTRAN user SYSTEM

  2. Create a user with the name SQL-SYS
    If user already exists, you should delete all files on this user. (Except for SQL-library if you have installed it already). 

    @create-user sql-sys
@create-user <directory>:SQL-SYS

  3. Give SQL-SYS 1300 pages (minimum)

    @give-user-space <directory>:SQL-SYS,1300

  4. Enter user SQL-SYS

    @new SQL-SYS
    You must be this user in the following steps.

ND-895615.1 EN

Page 6

Product Information

Date Norsk Data Page
90.10.17 Product Information Page 6 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

Instructions

  1. Copy all files on the floppies to this user.
    Use the backup-system.
@ENT-DIR ,FL-D-1,0            From unit 0 if you want.
@BA-SY
COPY
D                             destination type is directory
_                             return, default directory
_                             return, default user
D                             source type is also directory
211575B                       directory name of floppy
_                             return, default user is floppy
_                             return, copy all files
L                             list files as they are copied
EXIT                          finished

@REL-DIR 211575               Release directory
                              Insert next floppy.
@ENT-DIR ,FL-D-1,0            Enter directory
@BA-SY                        and copy the second diskette.
......
                              Copy the third in the same way.

  1. The file (SQL-SYS)SQLI-BO1:DOM is not complete.
    It must be linked to the SIBAS Library on your computer
    site to resolve the 31 undefined entries.

    The file SQLI-INSTALL-B:LOAD will link SQLI-BO1:DOM to
    (SIBR-B)SIBR-LIB-B:SEG. Check to see that the library is
    present and the file name is correct, edit if necessary.

    Link by executing the mode file:
    @mode SQLI-INSTALL-B:LOAD,"sq1i:list"

    Inspect sq1i:list.

    At the moment there are two versions of the SIBAS library,
    one with SIBAS message communication and one with nucleus
    communication. If you change the SIBAS-LIBRARY, you must
    fetch a fresh SQLI-BO1:DOM from the first floppy and
    execute "SQLI-INSTALL-B:LOAD" once again.

    If you install a new SIBAS version, you must change the
    link key of (sibr-b)sibr-lib-b segment.

ND-895615.1 EN

[Scanned by Jonny Oddene for Sintran Data © 2011]

Page 7

Product Information

Date 90.10.17 Norsk Data Page 7 of 14
Product name SIBAS/R SQL Interactive for ND-500/5000 (SQLI)
Product number 211575B

6

SQLI is normally defined as a standard domain: 

@ND
define-standard-domain SQLI-B01,(SQL-SYS)SQLI-B01:DOM
exit

The first time you use SQLI and open a database, the SQL-server in the SIBAS/R database process will be activated for the first time. The parameters for SQLI and the SQL-server must be set correctly in the (ND-OPERATIONS)SW-CONFIG file before you access a database. See chapter 4.4.

Any errors from initialization of the SQL-server will be printed on the error device. NOTE: If the server does not start correctly the first time, you must stop and restart SIBAS before you try again.

4.3 Installing HELP-Pictures in a New Language

This is an option. Skip this chapter if first installation.

To make HELP-pictures in a new language, you have to translate the file SQLI-EN-B01:CMND. Call the file SQLI-YY-B01:CMND where YY is the new language code.

This file will be automatically compiled the first time a user with language code YY (registered in User Environment) enters SQLI-B. A new object file (SQL-SYS)SQLI-YY-B01:DATA is generated.

Next time a user with language code YY enters SQLI-B, no compilation will take place. The existence of the file SQLI-YY-B01:DATA indicates that the data is ready and will be loaded into the data segment overlapping the default language.

Languages other than the default (English) need a little extra overhead because the file SQLI-YY-B01:DATA is located, opened and read into the data segment called SQL-NDP-SEG:SEG each time SQLI is started.

ND-895615.1 EN

Page 8

Product Information

Date Page
90.10.17 8 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

It is possible to install a new default language permanently by letting SQLI-YY-B01:DATA be dumped into SQLI-NDP-SEG:SEG, as follows:

  1. Ensure that the compilation was ok and that the HELP-pictures work correctly when used as a special language.

  2. Set SINTRAN user SQL-SYS and enter the LINKER program.
    Give the commands:

    set-advanced-mode
append-segment sql-ndp-seg:seg,swap-on-original-file
close n n
exit

  3. Start SQLI-B:DOM.
    The new language is now loaded into the original SQLI-NDP-SEG:SEG.
    Exit immediately.

  4. Enter the LINKER program.
    Give the commands:

    set-advanced-mode
append-segment sql-ndp-seg:seg,swap-on-swap-file
close n n
exit

4.4 Update of (ND-Operation)SW-CONFIG:SYMB

At startup, SQLI will ask for the database name and fetch system parameters for the database from the global software configuration file.

Comments:

DATABASE-NAME : <name of database>
ACCESS = RW                      To restrict the operations of SQLI
                                 to R or RW. (default=R)
                                 (Note: used by SIBAS also, omit
                                 this statement if you want R for
                                 SQL only)

SUPPRESS-TABLE-HEADING = ON      These parameters should be ON if
SUPPRESS-COLUMN-HEADING = ON     you want to use the SIBAS Realm
                                 names. 
                                 The default value is OFF.
                                 In this case the values defined in
                                 the schema as HEADING will be used.

ND-895615.1 EN

Page 9

Product Information

Date Norsk Data Page 9 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

DATABASE-ADMINISTRATOR =

The name of the database administrator is only important if you use the security system. Only the database administrator can grant or revoke privileges.

PURPOSE =

The purpose will appear as a description after the database name when you press shift+HELP.

PASSWORD = ?

Prompt for database password

The SQL-server part of a SIBAS process looks for a SYSTEM with the name SQL-SERVER- where is the SIBAS process number.

If this specification is missing, you cannot use SQLI on the database!

SYSTEM-NAME : SQL-SERVER-kk

This process contains a SQL server. kk is the process number. This system name must be present for local databases. Otherwise you will not see them when you press shift+HELP at request for database name.

The parameters of SQL-SEVER-xx are described in the SIBAS documentation, and may be changed in new SIBAS versions. Only the database administrator should insert or change these parameters.

However, for SIBAS/R B05, the following information can be given:

FUNCTIONS =

The parameter tells which functions the SQL server can perform. The legal values are:

  • SELECT: Select only.
  • INSERT: Insert only.
  • UPDATE: Update only.
  • DELETE: Delete only.
  • ALL: All SQL transactions can be run. (default)

ND-895615.1 EN

Page 10

Product Information

Date Norsk Data Page 10 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

AVAILABILITY = <avail>

The <avail> parameter tells which range of users the server can handle.
The legal values are:

  • SQLI: only requests sent from SQLI are legal
  • LIBRARY: only requests sent from user written programs are legal.
  • ALL: Both SQLI and LIBRARY. (default)

DATA-FILE = <filename> No default, must be present!

The SQL server will use this file name as a basis for creating temporary work files.
The server will work as the Sintran user SYSTEM.
Make sure that user SYSTEM is able to create and use these files.

The files are:

<filename>:SWAP
<filename>:SORT
<filename>:DATA
<filename>-n:JOI1
<filename>-n:JOI2
<filename>-n:JOI3
<filename>-n:UNI0

where n is the SIBAS thread number (only one thread in BO5).

The size of these files depends on the size of the database and the queries.
The files could be placed on a special SINTRAN user area, or on the database user area. (Example: (sql-work)serv4)

ND-895615.1 EN

Scanned by Jonny Oddene for Sintran Data © 2011

Page 11

Product Information

Date Norsk Data Page 11 of 14
Product name SIBAS/R SQL Interactive for ND-500/5000 (SQLI) Product number 211575B

LOGGING =

The <logtype> parameter specifies which kind of logging the user requests. This log is only for troubleshooting, and is normally not used.

The legal values are:

  • NOLOG
    No logging is used. (default)
  • SIMPLE
    A simple logging is performed. This logging tells which users the server has received requests from.
  • DETAILED
    A detailed logging telling which calls and transactions the users have used.
  • COMPLEX
    A complex logging logging almost everything happening in the SQL server. This feature is time consuming and should be used only when debugging errors.

LOG-FILE =

This is a trouble-shooting log for SQL only.
The log is cyclic, and has a fixed size of 300 pages (600K bytes).
You can inspect the file (or print it) with an editor.
The last error or message in the log is followed by a sequence of equal signs '=================='.
The default file type is :LOGG.
This file is not created automatically. You must create it!

Example:

SYSTEM-NAME : SQL-SERVER-4
FUNCTIONS   = ALL
AVAILABILITY = ALL
DATA-FILE   = (SQL-TEST)SQL-FIL4

ND-895615.1 EN

Scanned by Jonny Oddene for Sintran Data © 2011

Page 12

Product Information

Date Norsk Data Page 12 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

5 Modifications

5.1 New Functions/Commands

In the SQL language:

  • UNION has been implemented.
  • Cartesian product when joining tables. The A version could only handle equi-joins.
  • Wide Columns.
  • Keyword index. SQL will use the keyword index to find rows in a column with keyword index.
  • The GRANT and REVOKE have been implemented. These functions will work on databases if the system table NDSQLT02 is present.
  • You can refer to an element of an array within a column. (This is a feature of SIBAS and not standard SQL.)
  • Datatypes date, week and time.

A new batch command lets you make a form or letter for each row of a result table.

All new features are shown in the tutorial batch files of the DIALOGUE database, SQL-TUTORIAL-B01:SQL and SQL-TUTORIAL-B01:LIST. The :LIST file is in NOTIS-WP format, the :SQL file is in 7 bit format.

5.2 Changed Functions/Commands

SQL system tables (Changes in database schema for SQL tables).

SQLI-B01 can not execute queries stored in a database with SQLI-A. The structure of the system table has been totally changed.

SQLI-B01 stores queries in one table, NDSQLT01, with two wide columns.

A new system table, NDSQLT02, must be added if you want the security system to work. The file REDEF-SQL-B will add the new tables to a database.

If you have a database with the old tables NDSQLT01, NDSQLT02 and NDSQLT03, these tables must be deleted. (The simplest way is to rename the tables. Otherwise you must unload all other data tables, change the schema and reload.) Then you must add the new tables

ND-895615.1 EN

Page 13

Product Information

Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

NDSQLT01 and NDSQLT02. You can use SQLI to display the query table (old NDSQLT02) to a file, edit the file, insert store statements, and use the file as batch input for SQLI-B01.

Temporary tables

In the A-version, a result of a select query could be stored on a temporary table. This table would disappear when SQLI was terminated.

In the B-version you can store the result on a SINTRAN file. These files are permanent and contain a header describing the columns of the table. A result table on a SINTRAN file can be copied to other databases. It can also be used in queries.

With SQLI-B01 you can import the table back into the same database or into another database if the column descriptions are equal. This restriction will be removed in later versions.

The B01 version can not export or import wide columns to/from tables on SINTRAN files.

Query parameters

The special character to signal a query parameter has been changed from $ to : in accordance with the SQL standard.

5.3 Removed Functions/Commands

None.

5.4 Other Modifications

The DIALOGUE database schema supplied with the product has been extended with two new tables, PERSON and BUDGET, to show date and time functions, and array within a column.

There are also two changes in the PRODUCT table:

  • A wide column describing the product has been added.
    (the supplied texts are not good, just examples)
    The new column is called Description.
  • A synonym for the ProdName column has been defined as a keyword index. The synonym is called Prodkeys.

The SQL-TUTORIAL-B tutorial files have been updated to show all new features.

ND-895615.1 EN

Page 14

Product Information

Date Norsk Data Page 14 of 14
Product name Product number
SIBAS/R SQL Interactive for ND-500/5000 (SQLI) 211575B

6 Errors Corrected

None.

7 Errors Known But Not Corrected

When looking at wide columns, the content does not appear automatically. You must strike a key.

The interpretation and execution of queries are done by the SQL server in SIBAS. Any known errors are described there.

The present version of the SQL-server in SIBAS-B05 can only handle one SQL thread. This means that only one query can be executed at a time. If one query is executing, other users will "hang" until the execution is finished or until timeout. If the server is busy, you will get a message back after 30 seconds. This message is cryptic, "SQLLIB 43" which means "SQL server is busy". The message will be correct in the D10 version of UE-ERRORS.

ND-895615.1 EN