官术网_书友最值得收藏!

Chapter 1. Application Development Enhancements in DB2 9.7

In this chapter, we will focus on the following recipes related to application development enhancements in DB2 9.7 that help the application developer community to use DB2 features, instead of application logic:

  • Changing column names online using the ALTER TABLE operation
  • Using the CREATE OR REPLACE clause while creating objects
  • Using the ALTER TABLE operation in a single transaction
  • Using the CREATE WITH ERROR support
  • Using the soft invalidation and automatic revalidation support
  • Using the ALTER COLUMN SET DATA TYPE extended support
  • Using the new TRUNCATE statement
  • Using the AUTONOMOUS transactions
  • Using implicit casting during application enablement
  • Using the DEFAULT values and NAMED arguments in procedures
主站蜘蛛池模板: 长乐市| 兖州市| 屏山县| 亳州市| 乌兰县| 句容市| 南溪县| 子长县| 旬邑县| 瓮安县| 和田县| 桂林市| 罗山县| 新平| 大荔县| 淮阳县| 三河市| 汉中市| 芒康县| 渝北区| 陆丰市| 韶山市| 苗栗市| 淮北市| 文山县| 宁安市| 汉寿县| 敦煌市| 偏关县| 楚雄市| 高雄县| 缙云县| 云霄县| 重庆市| 进贤县| 渭源县| 阿瓦提县| 监利县| 维西| 长泰县| 金华市|