Sample Database to Help Users of Nonstop Sql/Mp

Topics: Attribute, SQL, Following Pages: 88 (20570 words) Published: May 6, 2013
Sample Database
To help users of NonStop SQL/MP become familiar with the product's features, Tandem includes a sample database and sample application on the product site update tape (SUT). The sample database demonstrates the use of NonStop SQL/MP in a Pathway transaction processing environment. It includes several host language programs that use embedded SQL statements to access the sample database. Users can also access the sample database with SQLCI commands. The source code, database creation and load files, and installation instructions for the sample database and application are stored on a file named DOCUMENT on a subvolume named ZTSQLMSG when NonStop SQL/MP is installed. (The volume name is specified at installation time by the user who installs NonStop SQL/MP. To determine the volume name, check with the group that installs NonStop SQL/MP at your site.) If you set your volume default to the appropriate disk volume, you can use the following command to print the installation instructions: 35> TGAL /IN ZTSQLMSG.DOCUMENT, OUT $S.#printer/

The sample database is used as the basis for many examples in the NonStop SQL/MP manuals. In the examples, most of the sample database is presented as installed on three subvolumes—PERSNL, SALES, and INVENT—on a single volume. Each subvolume contains a catalog and tables relating to a specific operation in the organization as follows: PERSNL SALES Contains the EMPLOYEE, JOB, and DEPT tables, which hold personnel data. Contains the CUSTOMER, ORDERS, ODETAIL, and PARTS tables, which are used for order data. Also contains the SUPPKANJ table, which accepts Kanji data for the supplier's name and address. Contains the SUPPLIER, PARTSUPP, PARTLOC, and ERRORS tables, which hold inventory data.


One table in the sample data base—the PARTLOC table—can be installed as a partitioned table. The examples show it as partitioned over three volumes on two different nodes. See the DOCUMENT file for additional details about the sample database or the sample application. See the NonStop SQL/MP programming manual for the host language you use for a figure that shows the tables in the sample data base and the relationships between them.

NonStop SQL/MP Reference Manual—142115 S-1

SAVE Command

SAVE Command
SAVE is an SQLCI command that saves in a file the values of one or more session attributes in command format. The file can be executed later with an OBEY command. SAVE {ALL } {ENV } {DEFINES } { } { { [ PARAM ] param-name [, param-name ] ... } } { { PARAM * } } { } { { [ LAYOUT ] layout-opt [,layout-opt ] ... } } { { LAYOUT * } } { } { [ SESSION ] { session-opt [, session-opt ]...}} { {* }} { } { { [ STYLE ] style-opt [, style-opt ] ...} } { { STYLE * } } { } { REPORT { report-cmd [, report-cmd ] ... } } { { * } } { } { COMMAND { "command-string"} } { { number } } { { -number } } TO file [ ( section-name ) ] [ CLEAR ] ;


saves all the session attributes: environmental parameters, DEFINEs, user-defined parameters, session options, layout options, style options, current report formatting commands, and the most recent SELECT command. ENV

saves the environmental attributes: SYSTEM, VOLUME, CATALOG, OUT, LOG, and OUT_REPORT. DEFINES

saves the current =_DEFAULTS DEFINE as an ALTER DEFINE command and saves all other current DEFINEs as ADD DEFINE commands. { [ PARAM ] param-name [, param-name ] ... } { PARAM * }

saves user-defined parameters as SET PARAM commands; param-name is the name of a user-defined parameter.You can specify a list of parameter names to save NonStop SQL/MP Reference Manual—142115 S-2

SAVE Command

specific parameters or specify an asterisk (*) to save the names and values of all current parameters. { [ LAYOUT ] layout-opt [, layout-opt ] ... } { LAYOUT * }

saves the layout options you specify; layout-opt is a single layout option.An asterisk (*) specifies all layout options. See SET LAYOUT Command on page S-35 for more information about layout...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Database Sql Essay
  • Oracle Database: SQL Fundamentals Essay
  • database Essay
  • Essay about DATABASE SQL
  • Sql Database Language Essay
  • Sql Introduction to Database Essay
  • Database Research Paper
  • Relational Database System – Sql Tutorial Essay

Become a StudyMode Member

Sign Up - It's Free