SQL Programming Manual for TAL

Examples of Static NonStop SQL Programs
HP NonStop SQL Programming Manual for TAL—527887-001
B-12
Date-Time Program
Figure B-2. Date-Time Program Run (page 1 of 3)
End of SQLCI Session
15> RUN TALDTO
START PROJECTS UPDATE PROGRAM
PLEASE ENTER:
Please enter selection:2
Enter a project name of up to 10 characters:777
Enter number of days of wait time to add:092
***** WAIT TIME ADDED *****
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:1
Enter a project name of up to 10 characters:777
Enter a start date-time as YYYY-MM-DD:HH:MM:1989-07-15:06:30
Enter an end date-time as YYYY-MM-DD:HH:MM:1989-10-31:23:58
Wait time for the new project is set at 0.
***** RECORD INSERTED *****
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
14> SQLCI
>>select * from =projects;
PROJECT_NAME
920
134
START_DATE
1988-02-21:20:30
1970-01-01:00:00
END_DATE
1989-03-21:20:30
1978-03-21:20:30
WAIT_TIME
30
30
>>exit;
- - - 2 row(s) selected.
VSTB02.vsd