SQL Programming Manual for TAL

Sample NonStop SQL Database
HP NonStop SQL Programming Manual for TAL—527887-001
A-4
Figure A-2. Sample Database Source File (page 2 of 4)
BEGIN
struct jobdesc;
begin
string val[ 0:17 ];
end;
END;
int len;
int jobcode;
?SECTION JOB
! Record Definition for table \SYS.$VOL.PERSNL.JOB
! Definition current at 17:11:12 - 04/20/90
struct job^type(*);
! Sales (SALES)
!
!
!
!
?SECTION CUSTOMER
! Record Definition for table \SYS.$VOL.SALES.CUSTOMER
! Definition current at 17:11:21 - 04/20/90
struct customer^type(*);
BEGIN
int
string
string
city[ 0: 13 ];
state[ 0: 11 ];
postcode[ 0: 9 ];
credit[ 0: 1 ];
END;
custnum;
custname[ 0: 17 ];
street[ 0: 21 ];
string
string
string
string
BEGIN
int(32)
order^date;
deliv^date;
int
END;
custnum;
ordernum;
int(32)
int(32)
salesrep;
int
?SECTION ORDERS
! Record Definition for table \SYS.$VOL.SALES.ORDERS
! Definition current at 17:11:32 - 04/20/90
struct orders^type(*);
VSTA02.vsd