Call Unix Script from SQR

Your rating: None Average: 1 (1 vote)

Few posts back, I wrote about how to call a UNIX script from PeopleCode. In this post, I will provide a sample code to call a UNIX script from an SQR program.

! Procedure:    Run-Script                            *
! Description:  Calls a unix script from SQR *
begin-procedure Run-Script
#debug show 'Entering Run-Script'

! call script located in /ps_scripts folder
let $cmd = $PS_HOME || '/ps_scripts/script_name'
display $cmd
call system using $cmd #call_status
if #call_status <> 0
    show 'Could not call script.  Program being stopped.'
    STOP Quiet

#debug show 'Leaving Run-Script'
end-procedure !Run-Script

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!