SQL Programming Manual for TAL

Sample NonStop SQL Database
HP NonStop SQL Programming Manual for TAL—527887-001
A-5
Figure A-2. Sample Database Source File (page 3 of 4)
BEGIN
int(32)
int
int(32)
int(32)
END;
ordernum;
partnum;
unit^price;
! scale is 2
qty^ordered;
?SECTION ODETAIL
! Record Definition for table \SYS.$VOL.SALES.ODETAIL
! Definition current at 17:11:42 - 04/20/90
struct odetail^type(*);
?SECTION PARTS
! Record Definition for table \SYS.$VOL.SALES.PARTS
! Definition current at 17:11:50 - 04/20/90
struct parts^type(*);
BEGIN
END;
int(32)
qty^available;
int(32) price; ! scale is 2
string partdesc[ 0: 17 ];
int
partnum;
!
!
!
!
! Inventory (INVENT)
?SECTION SUPPLIER
! Record Definition for table \SYS.$VOL.INVENT.SUPPLIER
! Definition current at 17:12:01 - 04/20/90
struct supplier^type(*);
BEGIN
int
string
string
string
string
string
END;
suppnum;
suppname[ 0: 17 ];
street[ 0: 21 ];
city[ 0: 13 ];
state[ 0: 11 ];
postcode[ 0: 9 ];
VSTA02.vsd