SQL/MX Report Writer Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series

Introduction to the NonStop SQL/MX Report Writer

HP NonStop SQL/MX Report Writer Guide—527194-002

1-2

Database Organization

For information on the SQL/MP language, see the SQL/MP Reference Manual .

Database Organization

In an SQL/MX database, data is organized and maintained in tables. A table consists

of vertical columns and horizontal rows:

•

A row contains pieces of related data, such as an employee's identification

number, name, and address.

•

A column contains data of the same type, such as all employee ID numbers.

Columns have names; rows do not.

Figure 1-1 contains sample rows from the PARTS and ODETAIL tables of an inventory

database. The PARTS table describes each part in the inventory. The ODETAIL table

contains order details (line entries).

Figure 1-1. Sample Content of Tables

VST0101.vsd

PARTNUM PARTDESC PRICE QTY_AVAILABLE

212

244

255

2001

6500

6603

7102

7301

PC SILVER, 20 MB

PC GOLD, 30 MB

PC DIAMOND, 60 MB

GRAPHIC PRINTER, M1

DISK CONTROLLER

PRINTER CONTROLLER

SMART MODEM, 1200

SMART MODEM, 2400

2500.00

3000.00

4000.00

1100.00

95.00

45.00

275.00

425.00

3525

4426

3321

2100

2532

430

2200

2332

ROWS

COLUMNS

ODETAIL Table

ORDERNUM

100210

100250

800660

PARTNUM

244

2001

2403

5100

244

5103

7102

7301

UNITPRICE

3500.00

1100.00

620.00

150.00

3500.00

400.00

275.00

425.00

QTY_ORDERED