Translate

Tuesday, 21 January 2014

how to run AE from SQR

Here is the piece of code to call app engine program from SQR: 

begin-procedure uCall-Unix-Script 
show 'started ucall-unix-script' 
let $vUNXque = 'psae -CT INFORMIX -CS hrdevsoc -CD HRDEV -CO SKAPIRED -CP saisuni20 -R test1 -I 909340 -AI AZ_JOB_0322' 
show $vUNXque 
call system using $vUNXque #unix-stat[NOWAIT] 
if #unix-stat 0 
show 'UNIX call error [' $vUNXque ']' 
end-if 
end-procedure 

2 comments:

  1. hi Suryaprakash,
    I'm getting error on below line.
    if #unix-stat 0
    thanks ,
    sara

    ReplyDelete
  2. I have used your code exactly. Please find below the code i have used.
    begin-procedure uCall-Unix-Script
    show 'started ucall-unix-script'
    let $vUNXque = 'psae-Oracle-appserver name-DB name–sqrname–$prcs_process_instance-$prcs_run_cntl_id-$prcs_oprid-pwd-my ae name'
    show $vUNXque
    call system using $vUNXque #unix-stat[WAIT]
    !if #unix-stat 0
    !show 'UNIX call error [' $vUNXque ']'
    !end-if
    end-procedure !uCall-Unix-Script.
    i would be great if u can give me your number or email id
    Need urgent help
    thanks ,
    Sara

    ReplyDelete