SQL Programming Manual for Pascal

Examples of Static NonStop SQL Programs
HP NonStop SQL Programming Manual for Pascal—528614-001
B-7
Date-Time Program
Figure B-1. Date-Time Program Run (page 1 of 3)
14> SQLCI
>SELECT * FROM =PROJECTS;
PROJECT_NAME START_DATE END_DATE WAIT_TIME
------------------------ --------------------- ------------------------ -----------------
920 1988-02-21:20:30 1989-03-21:20:30 30
134 1970-01-01:00:00 1978-03-21:20:30 30
--- 2 row(s) selected.
>EXIT;
End of SQLCI Session
15> RUN dtpobj
START PROJECTS UPDATE PROGRAM
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
1
Enter a project name of up to 10 characters:
777
Enter a start date-time in the format YYYY-MM-DD:HH:MM
1989-07-15:06:30
Enter an end date-time in the format 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
2
Enter a project name of up to 10 characters:
777
Enter number of days of wait time to add:
092
VSTB01.vsd