<div>Hi Peter,</div>
<div> </div>
<div>I resolve the issue and this is just to share this knowledge.</div>
<div> </div>
<div>I was repeatedly call a SQL SERVER stored procedure. I had misplaced a BEGIN TRANSACTION.</div>
<div>So everytime I called the procedure, a transaction is started and left open.</div>
<div>I placed the commit within an 'if' structure. So after I moved the BEGIN TRANSACTION inside the 'if' sturcture, the problem went away.</div>
<div> </div>
<div>Thanks again for your tip.</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">Syed Shahul Hameed Mustaffa</b> <<a href="mailto:sshahulgm@gmail.com">sshahulgm@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<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><span class="sg">
<div>SYED.</div></span>
<div><span class="e" id="q_108e4308c389d67f_2">
<div><br><br> </div>
<div><span class="gmail_quote">On 1/19/06, <b class="gmail_sendername">Peter Bateman</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:pfbcs@hotmail.com" target="_blank">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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br>>Subscribe: "subscribe" in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com </a><br>>Unsubscribe: "unsubscribe <password>" in message body to
<br>><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">
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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines" target="_blank">
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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">
powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com
</a><br>Unsubscribe: "unsubscribe <password>" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">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></span></div></blockquote></div><br>