SQL Programming Manual for TAL

Sample NonStop SQL Database
HP NonStop SQL Programming Manual for TAL—527887-001
A-3
Figure A-2. Sample Database Source File (page 1 of 4)
BEGIN
int
deptnum;
string deptname[ 0: 11 ];
int manager;
int rptdept;
struct location;
begin
int
string
end;
END;
len;
val[ 0:17 ];
?SECTION DEPT
! Record Definition for table \SYS.$VOL.PERSNL.DEPT
! Definition current at 17:10:59 - 04/20/90
struct dept^type(*);
!
! Personnel (PERSNL)
!
!
?SECTION EMPLOYEE
! Record Definition for table \SYS.$VOL.PERSNL.EMPLOYEE
! Definition current at 17:10:47 - 04/20/90
struct employee^type(*);
BEGIN
END;
int(32)
salary; ! scale is 2
int jobcode;
int
deptnum;
string
last^name[ 0: 19 ];
string first^name[ 0: 14 ];
int empnum;
VSTA02.vsd