Assorted IBM i hints and tips #1: CREATE TABLE authority setting #ibmi

This one caught me out recently:

If you do an SQL CREATE TABLE using JDBC with the default *SQL ('.' separator) naming convention, the system always sets AUT(*EXCLUDE); the normal object creation default of AUT(*LIBCRTAUT) is ignored.

To force AUT(*LIBCRTAUT), use the *SYSTEM ('/' separator) naming convention, by adding ;naming=system to the end of the JDBC URL.