Database Access

Table of Contents

Index

Chapter 6: Dynamic SQL

• 6.1 Dynamic SQL Statement Types
  • 6.1.1 Execute a Statement Once
  • 6.1.2 Execute the Same Statement More than Once
  • 6.1.3 Select a Given List of Data
  • 6.1.4 Select any Amount of Data
• 6.2 Preparing Dynamic SQL Statements
  • 6.2.1 COBSQL - Oracle
    • 6.2.1.1 Place Holders
    • 6.2.1.2 Physical Location of PREPARE Statement
• 6.3 Executing Dynamic SQL Statements
  • 6.3.1 EXECUTE IMMEDIATE Statement
  • 6.3.2 FREE Statement (COBSQL Informix)
• 6.4 Dynamic SQL Statements and Cursors
  • 6.4.1 CALL Statements