when are tables updated

[kevinluebb]

I've created a new table that I will populate with data from two other tables based upon some pretty basic selection criteria.

I've let it (the query) run for over half an hour and when I stop it and check the input table there are no records.

My question is this.....does sql update/input into the new table at the end or does it update/input when it finds a match?

 

[RickCole]

SQL Server will update the table at the end i.e. when the transaction is complete. You will not be able too your records till this point in time.

Rick.

 

[kevinluebb]

I kind of suspected that. RATS!!! Reckon I need to let the little bugger run.

Thanks!!!

 

[JohnBates]

Kevin - This is a little off the subject but just wanted to say that it is good to see other AS400 folks moving over
to the client-server world.

As for me, it has been a struggle, after many years of
programming in RPG and CL.

Good luck. John Nashville TN