“Compile” SQL objects into desired library – 1

Last Updated on 20 October 2019 by Roberto De Pedrini The SQL data definition language (DDL) allows you to create a number of objects, some of them are comparable to traditional IBM i objects (eg tables, indexes, aliases), others are instead specific to DB2 (functions, procedures , etc..). These objects are generally created from scripts stored in a source member or in IFS stream files and then processed by the RUNSQLSTM command. However, this command has no “Object Library” parameter in which to specify the destination for the object being created (as in standard compilation commands). …