SQR Development Guide
The purpose of this document is to define practical standard procedures and guidelines to be followed during the course of all projects taken on by the Banner Support Group within Management Information Systems (MIS) at The University of North Carolina at Greensboro. This document augments the existing MIS Policies and Procedures manual. This document frequently references that manual.
At one time, logic was inserted into the SQR processes that would execute if the program was run directly from the VMS operating system. This logic is no longer necessary. We will only allow SQR processes to be executed through Banner job submission.
- SQR: Create szrftsi.sqr in the SQR development directory on athena.
- Oracle ugdev1
Set def uncg$sqr
- Oracle ugdev1
- SQR: For every SQR program you will need a .COM file of the same name. Example:
szrftsi.sqr will need a com file called szrftsi.com. This .COM file will go in the
uncg$com directory. In this directory there is a sqr_shell.com file. If you are creating a
new SQR program called szrftsi.sqr then copy sqr_shell.com to szrftsi.com
- $ SQR UNCG$SQT:'JOB 'UIPW -RT -F'TEMP'.LIS 'SEQ
- SQR: To create a run-time version of your SQR program:
- $ oracle ugdev1
$ sqr szrftsi -rs
Move this szrftsi.sqt to the uncg$sqt directory.
- $ oracle ugdev1
- SQR: Add szrftsi to ugdev1 banner job submission forms (SEE 'Defining New Jobs to Job
Submission' for more details):
- Gjajobs -- Process Maintenance Form
- Type SZR% for the job name and press F8. To insert your new record select record menu option from menu bar and then insert.
- Gjapdef -- Parameter Definition Form
Gjapval -- Parameter Value Validation Form
Gjapdef (go back to this form if there are system level defaults)
- ALL Batch: Run szrftsi from banner by using the gjapctl form. SEE 'Running BANNER Reports' for more details
- (Maintenance or Query access) Run UNCG$PLUS:GZANOBJ sql script.
Parameters are 1) object name, 2) security class, 3) version #. 4) system indicator (R,S,G,T) 5) security class