Chapter 3 Using Static SQL This chapter shows you how to use static SQL. Topics • Why Use Static SQL? • Task A: Log DB2 Accesses • Task B: Prepare to Generate Static SQL • Task C: Generate Static SQL Using the @STATICSQL Tool • Task D: Manage Warning and Error Messages from @STATICSQL • Task E: Assemble the Static SQL Handler • Task F: Link the Static SQL Handler • Task G: Bind the DB2 Gateway Plan with Static SQL • Task H: Update the Gateway Startup JCL • Static SQL Usage