| |
| | Steve Rea's Oracle and SunGard SCT Banner Tips, Tricks, and Scripts |
 | | Another Banner-specific unix script, formcalls.shl, recursively finds all forms which are called by the given form, showing the list of all forms, a pruned tree of called forms, and the complete list of forms with their subforms, including access switches (query only, etc.). |
 | | The resulting recursive script, payroll_voucher_adjs.sql, prompts for the year first, and, if no year is entered, skips the rest of the script. |
 | | For example, suppose you are creating a shell script to run an sql script using runsqlplus, but want to use a printer entered in the first parameter of the job submission screen instead of the printer specified in the Printer environment variable set by the job submission screen. |
| www.uaex.edu /srea (10949 words) |
|