sapdev logo background
sapdev logo sapdev logo
Comments

SAP OPEN SQL WRITING documentation, setup help and example usage



Return to SAP documentation index


ARTICLE

Open SQL - Write Accesses
Write accesses include inserting, modifying, and deleting content in database tables. All write accesses can be made as individual accesses or as mass access. If multiple rows of a database table are to be changed, mass access using internal tables generally gives better performance than individual accesses.
  • INSERT

  • UPDATE

  • MODIFY

  • DELETE


  • Notes
  • When making write accesses, always pay attention to data consistency .

  • When making write accesses to a database table for which a database cursor is open in a SELECT loop or opened by using OPEN CURSOR , the results set is database-specific and undefined. Avoid this kind of parallel access if possible.
    Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved




  • OPEN_SQL_WA
    OPERANDS




    comments powered by Disqus