- IBM DB2 9.7 Advanced Application Developer Cookbook
- Sanjay Kumar Mohankumar Saraswatipura
- 105字
- 2021-08-20 15:42:20
Chapter 2. DB2 Application Techniques
In this chapter, we will focus on the following recipes describing the common DB2 techniques for application development:
- Granting and revoking instance-level authorities
- Granting and revoking database-level authorities
- Granting and revoking object privileges
- Implementing static SQL in DB2
- Implementing dynamic SQL in DB2
- Creating Declared Global Temporary Tables (DGTTs)
- Using XML in a declared temporary table
- Improving performance by creating indexes on a DGTT
- Creating Created Global Temporary Tables (CGTT)
- Using generated columns in tables
- Creating a savepoint
- Using savepoints in JDBC
- Using savepoints in SQLJ
- Creating a sequence object
- Modifying a sequence object
- Referencing a sequence object
推薦閱讀
- Visual C++實例精通
- 深入淺出Prometheus：原理、應(yīng)用、源碼與拓展詳解
- x86匯編語言：從實模式到保護模式（第2版）
- Visual C++串口通信技術(shù)詳解（第2版）
- 信息安全技術(shù)
- The DevOps 2.4 Toolkit
- Mastering Linux Security and Hardening
- LabVIEW虛擬儀器入門與測控應(yīng)用100例
- FPGA嵌入式項目開發(fā)實戰(zhàn)
- 超好玩的Scratch 3.5少兒編程
- Python網(wǎng)絡(luò)爬蟲實例教程（視頻講解版）
- 計算機組裝與維護（第二版）
- Mastering OpenStack
- 3D Printing Designs：The Sun Puzzle
- MySQL核心技術(shù)與最佳實踐