Saturday, 21 April 2012

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.

No comments:

Post a Comment