Create Or Replace Your Way to Improved DB2 for i Object Management

摘要

Every recent IBM i release has included improvements, enhancements, and extensions to all the major SQL categories, and IBM i 7.1 is no exception. Version 7.1 brings you the OR REPLACE clause, which IBM has added to many of the DDL CREATE statements. You can use the OR REPLACE syntax on SQL views, triggers, functions, procedures, global variables, sequences, and aliases.