HP 3000 Manuals HP 3000 Manuals
Chapter 3 Moving from TurboIMAGE/XL to IMAGE/SQL
If you are coming to IMAGE/SQL from the world of TurboIMAGE/XL, this
chapter will help you make the transition. This chapter describes
comparative terminology and discusses steps in using IMAGE/SQL. At the
completion of this chapter, you will have the knowledge of IMAGE/SQL
needed to complete the tasks in Chapters 4, 5, and 6.
The following topics are covered in this chapter:
* Basic structures
* Creating databases
* Tables versus data sets
* Mapping of data types
* Defining security
* Methods of accessing databases
The goal in discussing these topics is not to present a complete picture
of either system, but rather to suggest some points of correspondence to
make learning IMAGE/SQL easier. The discussion is deliberately
oversimplified. For definitions of IMAGE/SQL terms, refer to Chapter 2,
"Basic Concepts," and the Glossary. Complete information about
TurboIMAGE/XL is in the TurboIMAGE/XL Database Management System
Reference Manual.
Although IMAGE/SQL and TurboIMAGE/XL use different terminology, they
share several similar concepts. Table 3-1 lists IMAGE/SQL terms and
lists the equivalent TurboIMAGE/XL concept. The IMAGE/SQL terms listed
here are defined in more detail in the Glossary.
Table 3-1. Comparing IMAGE/SQL and TurboIMAGE/XL Concepts
---------------------------------------------------------------------------------------------
| | |
| IMAGE/SQL Term | TurboIMAGE/XL Term |
| | |
---------------------------------------------------------------------------------------------
| | |
| DBEnvironment | Collection of databases |
| | |
---------------------------------------------------------------------------------------------
| | |
| Table | Data set |
| | |
---------------------------------------------------------------------------------------------
| | |
| Column | Data item within entry |
| | |
---------------------------------------------------------------------------------------------
| | |
| Row | Record or entry |
| | |
---------------------------------------------------------------------------------------------
| | |
| System catalog | Root file |
| | |
---------------------------------------------------------------------------------------------
| | |
| DBECon file | Root file1 |
| | |
---------------------------------------------------------------------------------------------
| | |
| DBEUserID | Password1 |
| | |
---------------------------------------------------------------------------------------------
| | |
| DBEFile | DB01, DB02, DB031 |
| | |
---------------------------------------------------------------------------------------------
1Shares some similarities, but differences do exist.