SQL procuedure call - process doesn't terminate until I quit the screen - VERY URGENT

[Syed Shahul Hameed Mustaffa]

Dear Gurus,

>From a SCREEN of Axiant 4GL/ PH 4GL/ WINDOWS, I am calling a SQL SERVER 2000
stored procedures to create sql jobs.
Even though the procedure execution completes successfully, the tables that
are updated by the procedure, gets locked and doesn't get released until I
quit the screen that call the sp and also the previous screen.
In fact the SQL server process that is created for executing the stored
procedure doesn't end.
It is blocking the other processes that try to read the locked tables.
I'm calling the procedure from the update procedure.

The procedure call code is as follows

       sql in cwdb transaction update   &
       call CreateJob (JNAME, JOBDESC, QZNAME , STEPEXECSEQ, PROGTYPE &
       PHDICT, QZPROG, QZPARMFILE, OKTOSTREAM, RUNATONCE,USEPARMFILE,
USERID, SQLSPMESSAGE OUT )  &
       ON ERROR CONTINUE

I'd appreciate any help at the earliest in solving this issue.

Regards,
SYED.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060116/6ab2b46f/attachment.html