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:
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 “Comparing IMAGE/SQL and TurboIMAGE/XL Concepts”
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 file[1] |
DBEUserID | Password[1] |
DBEFile | DB01, DB02, DB03[1] |