I finally figured out the missing connection property needed so that Netbeans will allow you to add, edit, and delete rows with inline editors and selected rows. In addition to showing SQL Scripts for Create,Insert,Delete and Update. It is the extended metadata property which is by default set to false and needs to be set to true. I found this out by looking the jdbc properties at http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzahh/jdbcproperties.htm and looking for properties effecting read only status, which is why those features were blocked on Netbeans.
In your connection properties add
extended metadata=true
by right clicking your connection in the database panel of netbeans while disconnected and going to properties
Click the ellipses …) next to connection properties
Click under the property column and type extended metadata. Click under Value and type true
Now run a SELECT statement and you’ll be able to Create, Update and Delete records by using the icons above the result set or by right clicking the result set area and using the context menu. Which also had the Show SQL Scripts for CrUD.