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. Release 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. Before the OR REPLACE support was available, the CREATE statement failed if the object already existed. A common ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.