<div>Thank you Peter for your suggestion.</div>
<div> </div>
<div>It didn't solve the issue.</div>
<div>However, when I commented out some code from the sql stored procedure, the problem seems to have disappeared. I'll do some research in the sp. </div>
<div> </div>
<div>In the meanwhile if you can think of some tips, I'll appreciate.</div>
<div> </div>
<div>Regards,</div>
<div>SYED.</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 1/19/06, <b class="gmail_sendername">Peter Bateman</b> <<a href="mailto:pfbcs@hotmail.com">pfbcs@hotmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I would try after calling my procedure<br>COMMIT UPDATE<br><br>Regards,<br>Peter<br><br><br>><br>>Dear Gurus,
<br>><br>> >From a SCREEN of Axiant 4GL/ PH 4GL/ WINDOWS, I am calling a SQL SERVER<br>>2000<br>>stored procedures to create sql jobs.<br>>Even though the procedure execution completes successfully, the tables that
<br>>are updated by the procedure, gets locked and doesn't get released until I<br>>quit the screen that call the sp and also the previous screen.<br>>In fact the SQL server process that is created for executing the stored
<br>>procedure doesn't end.<br>>It is blocking the other processes that try to read the locked tables.<br>>I'm calling the procedure from the update procedure.<br>><br>>The procedure call code is as follows
<br>><br>> sql in cwdb transaction update &<br>> call CreateJob (JNAME, JOBDESC, QZNAME , STEPEXECSEQ, PROGTYPE &<br>> PHDICT, QZPROG, QZPARMFILE, OKTOSTREAM, RUNATONCE,USEPARMFILE,
<br>>USERID, SQLSPMESSAGE OUT ) &<br>> ON ERROR CONTINUE<br>><br>>I'd appreciate any help at the earliest in solving this issue.<br>><br>>Regards,<br>>SYED.<br><br><br>>--<br>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<br>>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br>>Unsubscribe: "unsubscribe <password>" in message body to<br>><a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>>This list is closed, thus to post to the list you must be a subscriber.<br><br>_________________________________________________________________<br>Take charge with a pop-up guard built on patented Microsoft® SmartScreen
<br>Technology<br><a href="http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines">http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
</a><br>Start enjoying all the benefits of MSN® Premium right now and get the<br>first two months FREE*.<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">
powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: "unsubscribe <password>" in message body to
<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.
<br></blockquote></div><br>