SQL Programming Manual for TAL

Examples of Static NonStop SQL Programs
HP NonStop SQL Programming Manual for TAL—527887-001
B-14
Date-Time Program
Figure B-2. Date-Time Program Run (page 3 of 3)
PLEASE ENTER:
1 - - to insert new project data
2 - - to add wait time to a project
3 - - to report original and new project dates
4 - - to exit the program
Please enter selection:4
TERMINATING PROJECTS UPDATE PROGRAM
16> SQLCI
>>select * from =projects;
--- 3 row(s) selected.
PROJECT_NAME
920
134
777
START_DATE
1988-02-21:20:30
1970-01-01:00:00
1989-07-15:06:30
END_DATE
1989-03-21:20:30
1978-03-21:20:30
1989-10-31:23:58
WAIT_TIME
30
30
92
VSTB02.vsd