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
Describe the function and untility of the most difficult SAS macro that you have written.
Do you know the features of sas?
If a variable contains letters or special characters, can it be numeric data type?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How you can read the variables that you need?
how sas deals with business intelligence? : Sas-bi
Are you involved in writing the inferential analysis plan? Tables specifications?
what are some differences between proc summary and proc means? : Sas programming
What are the automatic variables for macro? : sas-macro
Give some ways by which you can define the variables to produce the summary report (using proc report)?
What do you know about sas data set?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
what has been your most common programming mistake? : Sas programming
why a stop statement is needed for the point= option on a set statement?