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

[Peter Bateman]

I would try after calling my procedure
COMMIT UPDATE

Regards,
Peter


>
>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.


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen 
Technology  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.