Answer / malli.gontla

suppose u have one table which is in database. The table
contains some records. U want to modify one record of table.
after modification, u don't want that new values for
the record. just u use rollback command. previous values are
placed in database.

Example:
Case 1: Roll Back
sno name palce
1 abc hyderabad
2 xyz bangalore.

This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.

After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.

Suppose if u want old values, means u don't want new
values. At that time u use roll back command

After useing rollback:
sno name palce
1 abc hyderabad
2 xyz bangalore.
after using roll back, the records are comes like
above(original records)

Case 2: Commit
sno name palce
1 abc hyderabad
2 xyz bangalore.

This is the table and it contains some records.
Suppose if u want change the 2nd record, means palce
is changed to chennai.

After modification:
sno name palce
1 abc hyderabad
2 xyz Chennai.

After useing commit:
sno name palce
1 abc hyderabad
2 xyz Chennai.
after using commit, the table is finilased.u can't get
old values by uisng roll back.

Once if u use commit,u can't get old values for using of
rollback. Before commit, u can get old values for rollback.

Answer / prasad

Commit mean if change the values after commit u cont replace
old values.

Rollback mean if u r not given commit u will get previous
values.

Answer / kaushal

Using commit, It saves any modification made within objects of database. We can not undo our transaction which done within commit.
Rollback is similar to undo button of any s/w browser. That is, when we make any changes in recodes of table, we can came back to previous form of that table by using rollback.

Answer / priyanka

COMMIT:Save Record Permanently in database
Syntax :COMMIT;
ROLLBACK: This is like undo
Syntax: ROLLBACK

Answer / ashish kumar

If transaction manager not found any unchecked exception then record is committed.If transaction manager found any unchecked exception then rollback.

any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?

0 Answers   KPIT,

How collect statement is different from append?

0 Answers  

What is modularization and its benefits?

0 Answers  

Explain the disadvantages of logical databases?

0 Answers  

What are roles and authorization objects?

0 Answers   Infosys,

I have two internal tables itab1 and itab2 and I had move the content of the itab1 to itab2 and then itab1 had to deleted

4 Answers   Accenture,

Explain the different types of view?

0 Answers  

BAPI IS EFFICIENT THAN BDC?

2 Answers   IBM, Thomson Reuters,

What does import and export do?

1 Answers   TCS,

25) Can we create more than one main window in smartforms?

1 Answers   IBM,

What is the difference between function group and function module?

0 Answers  

what are the events in sap script print progam.

3 Answers