No Subject

[Julie Lawton <lawton_julie@HOTMAIL.COM>]

Hi,

I would appreciate any help which anyone can offer me.  I am running SQR
scripts against a Sybase database.

I originally had a problem with an SQR script which produces flat files for
exporting, whereby there were occasions where records were being updated as
being sent when they had not been selected.  This was due to the fact that
the select and update in the SQR file were separate Sybase transactions.
This allowed other Sybase transactions (i.e. record insert) to be done
between the two hence the possibility of records being updated but not
selected.  I have attached a copy of the original SQR file.

I modified the file to call the update script from with the select.  I also
included a begin tran and commit tran and also specified a connection number
on the various begin-selects.  I have attached a copy of the modified SQR
file.

My problem is when trying to run the modified script which selects a large
number of records (around 4000).  The file gets to 106496 bytes and hangs.
I have a large amount (88) of ex_page locks  (when I do sp_Lock).  When I
run the original script, it works, in the sense that it completes, with this
volume of data.

Does anyone have any ideas what could be the cause of my problem?  I would
appreciate any advice.

Thanks

Julie
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Aimorig.sqr

Aim.sqr