Page 1¶
Program Description¶
Date: 87.02.10
Norsk Data A.S
Page 1 of 6
| Product | Name | Reg. no. | Category |
|---|---|---|---|
| SQL for ND-500 | 211049A | STPR |
| Reason | |
|---|---|
| x New product | . Error Correction |
| Documentation | Title | Reg. No |
|---|---|---|
| SQL User Manual | 60.258.1 EN |
Purpose¶
To provide an interactive version of the relational language SQL for use with SIBAS databases.
The A version of SQL will only include the DML part of the SQL language, which makes it possible to query existing SIBAS databases.
New databases must be defined with SIB2-DRL.
Prerequisites¶
| Computer | Type | Floating format | Op. System Version |
|---|---|---|---|
| ND-500 | All | All | SINTRAN III >= K |
| Reg. no. | Product name |
|---|---|
| 210340 | SIBAS II for ND-500 |
| 210319 | LINKAGE-LOADER for ND-500 |
Reg. no. for Source: 250195A
Storage Resources¶
Minimum mass storage resources for installation¶
| User | User space | Number of files |
|---|---|---|
| SYSTEM | 300 pages | 6 files |
| DIALOG-SYS | 1400 pages | 41 files |
Minimum permanent mass storage resources¶
| User | User space | Number of files |
|---|---|---|
| SYSTEM | 220 pages | 3 files |
| DIALOG-SYS | 1400 pages | 41 files |
Files Included on the System Diskettes¶
| File Name | Type | Containing |
|---|---|---|
| SQL-INSTALL-A |
PROG | Installation program |
| SQL-INSTALL-A |
XCOM | Installation command file |
| UE-ERMSG-EN-C |
ERR | Error message file in English |
| UE-ERMSG-NO-C |
ERR | Error message file in Norwegian |
| SQL-PATCH-A |
SYMB | Patch file for SIBAS ver. < E12 |
| SQL-DRL-A |
SYMB | SIB-DRL file for query storage |
| SQL-EXAMPLE-A |
SYMB | Schema for example database |
| SQL-CATALOG-A |
SYMB | Data Dictionary for ex. db. |
| SQL-TUTORIAL-A |
SQL | Tutorials for example database |
| DDBTABLES |
VTM | Terminal tables |
| SQL-01-A |
NRF | SQL :NRF file |
| SQL-02-A |
NRF | SQL :NRF file |
| SQL-03-A |
NRF | SQL :NRF file |
| SQL-04-EN-A |
NRF | SQL :NRF file |
| SQL-04-NO-A |
NRF | SQL :NRF file |
| SQL-05-A |
NRF | SQL :NRF file |
ooo ND Norsk Data ooo
Scanned by Jonny Oddene for Sintran Data © 2011
Page 2¶
Norsk Data A.S¶
Program Description¶
Date 87.02.10
Page 2 of 6
SQL for ND-500¶
| Product | Name | Reg. no. 211049A | Category STPR |
|---|---|---|---|
| SQL-06-A |
NRF | SQL :NRF file | |
| SQL-07-A |
NRF | SQL :NRF file | |
| SQL-08-A |
NRF | SQL :NRF file | |
| SQL-09-A |
NRF | SQL :NRF file | |
| SQL-10-A |
NRF | SQL :NRF file | |
| SQL-11-A |
NRF | SQL :NRF file | |
| SQL-12-A |
NRF | SQL :NRF file | |
| SQL-13-A |
NRF | SQL :NRF file | |
| SQL-14-A |
NRF | SQL :NRF file | |
| SQL-15-A |
NRF | SQL :NRF file | |
| SQL-16-A |
NRF | SQL :NRF file | |
| SQL-17-A |
NRF | SQL :NRF file | |
| SQL-18-A |
NRF | SQL :NRF file | |
| SQL-19-A |
NRF | SQL :NRF file | |
| SQL-20-A |
NRF | SQL :NRF file | |
| SQL-21-A |
NRF | SQL :NRF file | |
| SQL-22-A |
NRF | SQL :NRF file |
NOTE: <rev> is to be replaced by the current revision of the DIRECTORY or FILE. Revision is found on the "ND SOFTWARE LIBRARY DISKETTE" pages.
You will get two double density floppies called 211049A
ooo ND Norsk Data ooo
Scanned by Jonny Oddene for Sintran Data © 2011
Page 3¶
| Date | Norsk Data A.S | Page 3 of 6 |
|---|---|---|
| PROGRAM DESCRIPTION | ||
| Product | Name | Reg. no. |
| SQL for ND-500 | 211049A | STPR |
1 INSTALLATION PROCEDURE¶
The system may be delivered on:
- A - 1.2 Mbyte, 8 inch or 5 1/4 inch double-sided diskettes
- B - 0.3 Mbyte, 8 inch single-sided diskettes
You must use the same kind of diskettes ("A" or "B") throughout the whole installation procedure. The installation procedure is fully interactive, which means that once started, it will continuously check the operation. It will inform the operator if any error(s) occur, and what to do to continue.
1.1 How to run the installation procedure¶
- Log in as user SYSTEM.
- Ensure that you have the H-version of LINKAGE-LOADER available on your system.
- If you want to install the example database used in the SQL User Manual you must have a version of SIB2-DRL on user SYSTEM.
- Insert the diskette containing the directory name 211049A-XX-01 into the diskette station.
- Execute these commands (operator input is underlined and parameters are enclosed in brackets and must be terminated by ⏎ (carriage return)).
@ENTER-DIRECTORY 211049A-XX-01⏎
DEVICE NAME: FLOPPY-DISC-<drive-no.>⏎
DEVICE UNIT: <floppy-unit>⏎
@(211049A:FLOPPY-USER)SQL-INSTALL-A⏎
The installation procedure has now started. It is self-explanatory. If errors occur during installation, the program will display the reasons.
When the installation program terminates, give the SINTRAN command:
@DELETE-FILE SQL-INSTALL-A:XCOM⏎
ooo ND Norsk Data ooo
Scanned by Jonny Oddene for Sintran Data © 2011
Page 4¶
Program Description¶
| Date | Norsk Data A.S | Page 4 of 6 |
|---|---|---|
| Product | Name | Reg. no. |
| SQL for ND-500 | 211049A |
1.2 Patching in SIBAS¶
If your SIBAS is version E10 or older, the patch file SQL-PATCH:SYMB must be run from the SIB2-500 user.
This must be done before you use the SQL system.
Give this command to run the patch:
@MODE SQL-PATCH-A<rev>:SYMB,,↵
1.3 How to start the SQL program¶
When the installation program terminates normally, a standard domain named SQLI-A
@SQLI-A<rev>↵
The program will display a log-in form and you enter the database you want to use and the password. You can also enter the log-in parameters on the command line by typing:
@SQLI-A<rev> <db-name>,<password>↵
If you have a password, this log-in method will display the password.
ooo ND Norsk Data ooo
Scanned by Jonny Oddene for Sintran Data © 2011
Page 5¶
| Date | Norsk Data A.S | Page 5 of 6 |
|------------|----------------------------------------|------------------|
| Product | Name | Reg. no. | Category |
| SQL for ND-500 | | 211049A | STPR |
## 2 REGENERATING THE SQL PROGRAM
If the ND-500 domain should be destroyed, or if a new version of SIBAS is installed on your system, do the following:
- Log in as user SYSTEM and delete the standard domain by typing:
```
@ND↲
DELETE-STANDARD-DOMAIN SQLI-A<rev>↲
```
- Log in as the user where SQL has been installed and run:
```
@MODE SQLI-A<rev>:LOAD,,,↵
```
- Log in as user SYSTEM and define SQLI-A<rev> as a standard domain by typing
```
@ND↲
DEF-STANDARD-DOM SQLI-A<rev> (<sql user>)SQLI-A<rev>↲
```
## 3 SAVING DISK SPACE ON YOUR SYSTEM
If you have little disk space available on your system, the :NRF files on the user where SQL is installed can be deleted.
If the SQLI domain needs to be reinstalled, the installation program has to be rerun.
## 4 HOW TO USE NEW DATABASES
New databases are made available by defining them in the (SYSTEM)SQL:BASE file.
A description of this is found in Appendix E of the SQL User Manual.
ooo ND Norsk Data ooo
Scanned by Jonny Oddene for Sintran Data © 2011
Page 6¶
Program Description¶
| Product | Name | Reg. no. | Category |
|---|---|---|---|
| SQL for ND-500 | 211049A | STPR |
5 How to Set SQL in Read/Readwrite Mode¶
The SQLI program has a flag telling if the program is allowed to perform SIBAS updates.
This ReadWrite flag can be turned on/off in the following way:
Read Only Read Write
@ND- @ND-
LOOK-AT-DATA 1'4B SQLI-A- LOOK-AT-DATA 1'4B SQLI-A-
PERMIT- PERMIT-
0- 1-
EXIT- EXIT-
EXIT- EXIT-
6 Languages Available in SQL¶
SQLI supports two languages, English and Norwegian.
- When logged in via SINTRAN, English is the only language available.
- When logged in via User Environment, you will automatically get the language defined in your User Profile in User Environment. If the language does not exist (i.e. other than English or Norwegian), the default language is English. You are only authorized to give SINTRAN commands inside SQLI if it is granted in the User Profile.
Please note that the SQL language itself will always be in English. This is because SQL is an international standard.
7 Storing Queries in Existing Databases¶
In order to fetch and store queries, the database has to be redefined.
A detailed description of this is given in Appendix D of the SQL User Manual.
Page 7¶
ND Software Library Diskette¶
Page: 1
Containing:
SQL for ND-500
Directory Name:
211049A02-XX-01D
User Name: FLOPPY-USER¶
| No | File name | Type | T | Public | Friend | Own | Pages | Bytes |
|---|---|---|---|---|---|---|---|---|
| 0 | SQL-INSTALL-A02 | PROG | I | RWACD | RWACD | RWACD | 46 | 151086 |
| 1 | SQL-INSTALL-A02 | XCOM | I | RWACD | RWACD | RWACD | 35 | 56309 |
| 2 | UE-ERMSG-EN-C02 | ERR | I | RWACD | RWACD | RWACD | 103 | 208384 |
| 3 | UE-ERMSG-NO-C02 | ERR | I | RWACD | RWACD | RWACD | 106 | 214784 |
| 4 | SQL-PATCH-A00 | SYMB | I | RWACD | RWACD | RWACD | 2 | 794 |
| 5 | SQL-DRL-A00 | SYMB | I | RWACD | RWACD | RWACD | 2 | 1496 |
| 6 | SQL-EXAMPLE-A00 | SYMB | I | RWACD | RWACD | RWACD | 9 | 14842 |
| 7 | SQL-CATALOG-A00 | SYMB | I | RWACD | RWACD | RWACD | 2 | 1129 |
| 8 | SQL-TUTORIAL-A00 | SQL | I | RWAD | RWACD | RWACD | 36 | 70159 |
| 9 | DDBTABLES-G03 | VTM | I | RWACD | RWACD | RWACD | 38 | 75320 |
10 files using 379 pages. 610 pages reserved out of 610 pages.
Page 8¶
ND SOFTWARE LIBRARY DISKETTE¶
PAGE 1¶
Directory Name:
211049A02-XX-02D
Containing:
SQL for ND-500
User Name: FLOPPY-USER
| No | File name | Type | T | Public | Friend | Own | Pages | Bytes |
|---|---|---|---|---|---|---|---|---|
| 0 | SQL-01-A02 | NRF | I | RWACD | RWACD | RWACD | 47 | 89225 |
| 1 | SQL-02-A02 | NRF | I | RWACD | RWACD | RWACD | 116 | 227722 |
| 2 | SQL-03-A02 | NRF | I | RWACD | RWACD | RWACD | 46 | 89217 |
| 3 | SQL-04-EN-A02 | NRF | I | RWACD | RWACD | RWACD | 46 | 91919 |
| 4 | SQL-04-NO-A02 | NRF | I | RWACD | RWACD | RWACD | 46 | 90555 |
| 5 | SQL-05-A00 | NRF | I | RWACD | RWACD | RWACD | 14 | 25768 |
| 6 | SQL-06-A00 | NRF | I | RWACD | RWACD | RWACD | 5 | 7015 |
| 7 | SQL-07-A00 | NRF | I | RWACD | RWACD | RWACD | 9 | 14679 |
| 8 | SQL-08-A00 | NRF | I | RWACD | RWACD | RWACD | 5 | 6928 |
| 9 | SQL-09-A00 | NRF | I | RWACD | RWACD | RWACD | 24 | 46221 |
| 10 | SQL-10-A00 | NRF | I | RWACD | RWACD | RWACD | 27 | 51811 |
| 11 | SQL-11-A00 | NRF | I | RWACD | RWACD | RWACD | 3 | 907 |
| 12 | SQL-12-A01 | NRF | I | RWACD | RWACD | RWACD | 14 | 9481 |
| 13 | SQL-13-A00 | NRF | I | RWACD | RWACD | RWACD | 2 | 462 |
| 14 | SQL-14-A00 | NRF | I | RWACD | RWACD | RWACD | 72 | 145143 |
| 15 | SQL-15-A02 | NRF | I | RWACD | RWACD | RWACD | 17 | 30822 |
| 16 | SQL-16-A02 | NRF | I | RWACD | RWACD | RWACD | 39 | 77549 |
| 17 | SQL-17-A00 | NRF | I | RWACD | RWACD | RWACD | 8 | 13263 |
| 18 | SQL-18-A00 | NRF | I | RWACD | RWACD | RWACD | 2 | 367 |
| 19 | SQL-19-A00 | NRF | I | RWACD | RWACD | RWACD | 31 | 56175 |
| 20 | SQL-20-A00 | NRF | I | RWACD | RWACD | RWACD | 5 | 7378 |
| 21 | SQL-21-A00 | NRF | I | RWACD | RWACD | RWACD | 9 | 16082 |
| 22 | SQL-22-A02 | NRF | I | RWACD | RWACD | RWACD | 11 | 16518 |
23 files using 598 pages. 610 pages reserved out of 610 pages.