SQL Programming Manual for TAL

Sample NonStop SQL Database
HP NonStop SQL Programming Manual for TAL—527887-001
A-6
Figure A-2. Sample Database Source File (page 4 of 4)
?SECTION PARTSUPP
! Record Definition for table \SYS.$VOL.INVENT.PARTSUPP
! Definition current at 17:12:11 - 04/20/90
struct partsupp^type(*);
END;
BEGIN
int(32)
qty^received;
int(32) partcost; ! scale is 2
int
suppnum;
int partnum;
?SECTION PARTLOC
! Record Definition for table \SYS.$VOL.INVENT.PARTLOC
! Definition current at 17:12:23 - 04/20/90
struct partloc^type(*);
END;
BEGIN
string loc^code[ 0: 2 ];
int
partnum;
int(32)
qty^on^hand;
?SECTION ERRORS
! Record Definition for table \SYS.$VOL.INVENT.ERRORS
! Definition current at 17:12:23 - 04/20/90
struct errors^type(*);
BEGIN
END;
int(32)
int(32)
int(32)
int
int
string
string
errors^date;
errors^time;
errors^id;
errors^sql;
errors^fs;
errors^text1 [ 0: 239 ];
errors^text2 [ 0: 239 ];
VSTA02.vsd