- 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
推薦閱讀
- Android Wearable Programming
- Rust實(shí)戰(zhàn)
- Python數(shù)據(jù)分析基礎(chǔ)
- Mastering LibGDX Game Development
- 大模型RAG實(shí)戰(zhàn)：RAG原理、應(yīng)用與系統(tǒng)構(gòu)建
- INSTANT Passbook App Development for iOS How-to
- C++面向?qū)ο蟪绦蛟O(shè)計(jì)習(xí)題解答與上機(jī)指導(dǎo)（第三版）
- 微服務(wù)架構(gòu)深度解析：原理、實(shí)踐與進(jìn)階
- 編程可以很簡(jiǎn)單
- 從零開(kāi)始學(xué)Python網(wǎng)絡(luò)爬蟲(chóng)
- 從零開(kāi)始：UI圖標(biāo)設(shè)計(jì)與制作（第3版）
- Unity Character Animation with Mecanim
- Python Digital Forensics Cookbook
- Visual C++程序設(shè)計(jì)與項(xiàng)目實(shí)踐
- 深入實(shí)踐C++模板編程