HP 3000 Manuals HP 3000 Manuals
What Are the Components of IMAGE/SQL? [REV BEG] IMAGE/SQL includes TurboIMAGE/XL, certain components of ALLBASE/SQL, and a database administration tool that links them together. The database administration tool is the IMAGE/SQL utility. The components of IMAGE/SQL are described below:[REV END] TurboIMAGE/XL A set of programs and procedures for defining, creating, accessing, and maintaining TurboIMAGE/XL databases. TurboIMAGE/XL databases can be accessed using TurboIMAGE/XL procedures, utilities, and applications. IMAGE/SQL adds the ability to access TurboIMAGE/XL databases by using the industry-standard SQL language. ALLBASE/SQL A set of programs and procedures for creating, maintaining, and accessing relational database environments. IMAGE/SQL includes the ALLBASE/SQL components needed to provide relational access to TurboIMAGE/XL databases. [REV BEG] HP PC API for ALLBASE/SQL and IMAGE/SQL Software that provides a programmatic interface to IMAGE/SQL for creating Microsoft windows-based client-server applications. With HP PC API for ALLBASE/SQL and IMAGE/SQL, you use one of several available 4GL and decision support tools to build your application, which connects to ALLBASE/SQL over a network through ALLBASE/NET. ALLBASE/NET Works with HP PC API for ALLBASE/SQL and IMAGE/SQL in connecting users with databases over a network. IMAGE/SQL Utility A database administrator's tool for managing TurboIMAGE/XL databases in a relational access environment. This tool attaches and detaches databases to and from DBEnvironments for access via SQL. Other management functions, such as security and data type mapping, are accomplished through this utility. Refer to the HP IMAGE/SQL Administration Guide for details on the IMAGE/SQL utility.[REV END] ISQL An interactive command processor that lets you enter SQL statements at the keyboard and observe query results, messages, and other information on a video display. SQL is a language--not a software system. Therefore, you need an interactive way to submit SQL statements. ISQL is the main tool used by IMAGE/SQL programmers and database administrators to create and modify DBEnvironments. It is also used by anyone who needs to submit queries using the SQL language. ISQL is especially useful for loading and unloading data. SQLGEN A database administrator's tool that generates the commands used to recreate all or part of an existing DBEnvironment. It also generates LOAD/UNLOAD and UPDATE STATISTICS statements. These commands are placed in one or more data files called schema files, which can then be used as ISQL command files to recreate the DBEnvironment (not the TurboIMAGE/XL database.) SQLUtil A database administrator's tool for displaying and setting the basic parameters of a DBEnvironment (explained further in Chapter 2, "Basic Concepts"), storing and restoring DBEnvironments, setting the size of system buffers, and purging DBEnvironments. The database administrator (DBA) is the individual who creates and maintains objects in a DBEnvironment. SQLUtil is seldom needed by the ordinary user. Preprocessors Tools that convert source programs containing SQL statements into source code that can be compiled in a programming language of your choice. Different preprocessors let you code applications in C, COBOL, FORTRAN, and Pascal.