|
-----Original Message-----[Michael Quigley]
message: 5
date: Tue, 22 Jun 2021 09:16:56 -0400
from: <dfreinkel@xxxxxxxxxxxxxxxxx>
subject: RE: SQL7905 Error
SQL7905 is not really an error of the critical/severe type.
This message will always be generated for every table you create in a
standard library.
The only way that I know where it is not created is if you[Michael Quigley]
create the table in a Schema. A schema is a library in SQL terms but when
you create a schema on the IBM i, the schema/library is created with
additional objects which provide for functionality used in SQL. The Journals
are created automatically within these objects and when I tested this a long
time ago, the SQL7905 message does not get sent.
I do not see a way to create a table with a keyword to not create journals.
But I could have missed that.
You can happily ignore that message.
Darryl Freinkel
A4G
Telephone: 770.321.8562 Mobile: 678.355.8562
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.