topic Re: database updates in Application Development and Automation Discussions

database updates

Former Member — Tue, 24 Apr 2007 12:51:17 GMT

what r database updates?could u plzz tell me

Re: database updates

Former Member — Tue, 24 Apr 2007 12:53:09 GMT

Open SQL consists of a set of ABAP statements that perform operations on the central database in the R/3 System. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. ABAP programs that only use Open SQL statements will work in any R/3 System, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP Dictionary.

and the statements are

INSERT

Adds lines to database tables

UPDATE

Changes the contents of lines of database tables

MODIFY

Inserts lines into database tables or changes the contents of existing lines

DELETE

Deletes lines from database tables

reward if it helps u

vijay pawar

Re: database updates

Former Member — Tue, 24 Apr 2007 12:53:22 GMT

Database updates are the changes that are done to the database tables.

The changes may be adding new records, changing existing records and deleteing existing records.

Regards,

Ravi

Re: database updates

Former Member — Tue, 24 Apr 2007 12:56:55 GMT

Hi,

you can Update, Modify, Insert, and delete the records in the Database.

Regards,

Suresh