O'Reilly logo

The Programmer’s Guide to iSeries Navigator by Paul Touhy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

B. Make the Database

For your own reference, this Appendix contains the SQL Scripts to generate all the samples used in the book. The scripts were generated by selecting Generate SQL from the context menus of the NEWSCHEMA and FUNCLIB schemas (libraries).

The only change that was made to the generated scripts was to remove the schema qualifiers on all the names and insert a SET SCHEMA statement at the start of each script.

Figure B.1 shows the SQL script to generate the NEWSCHEMA schema and Figure B.2 show the script to generate the FUNCLIB schema.

Figure B.1. SQL script to generate the contents of the NEWSCHEMA schema.
--  GENERATE SQL

--  VERSION:                          V5R3M0 040528
--  GENERATED ON:                      09/07/05 16:09:14
--  RELATIONAL DATABASE:                S655D66B
--  STANDARDS O ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required