« SFTP public key gotcha | Main | SWRRSC2 »

September 6, 2012

SWBRDT* reports

There's several reports used by the business office that are named SWBRDT*. A lot of these had different spool file names or used an underscore followed by a number. I updated all of these scripts so that they used the name of the report as the spool file.
swbrdt2 -> spool $swbrdt2
All sql scripts that spool should follow this pattern because job submission automatically creates a variable in linux that points to the spool directory/user_job_oneupno.lis1 file.

Posted by soukupm at September 6, 2012 4:54 PM

Comments

Post a comment

Thanks for signing in, . Now you can comment. (sign out)

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)


Remember me?