What is Transaction...? And what are Comment, Roll back n
Save point..?
Answer Posted / saifudheen
In computer programming, a transaction usually means a sequence of information exchange and related work (such as database updating) that is treated as a unit for the purposes of satisfying a request and for ensuring database integrity. For a transaction to be completed and database changes to made permanent, a transaction has to be completed in its entirety. A typical transaction is a catalog merchandise order phoned in by a customer and entered into a computer by a customer representative. The order transaction involves checking an inventory database, confirming that the item is available, placing the order, and confirming that the order has been placed and the expected time of shipment. If we view this as a single transaction, then all of the steps must be completed before the transaction is successful and the database is actually changed to reflect the new order. If something happens before the transaction is successfully completed, any changes to the database must be kept track of so that they can be undone.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
why is a stop statement needed for the point=option on a set statement? : Sas programming
it will become easy if uuu provide website linkssss and list of consultanciessssss
what is the use of proc sql? : Sas programming
how does sas handle missing values in sort order? : Sas programming
how to change the execute of macro
What is the basic structure of a sas program?
Briefly explain input and put function?
What are the features of base sas system?
How long can a macro variable be? A token? : sas-macro
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How do you test for missing values?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the difference between proportion and average?
how to remove duplicates using proc sql?
What are the different types of sas functions?