Re: SQL7905 Error

[Randy Cayton <randy_cayton@xxxxxxxxxxx>]

good deal , crete had a similar issue after they installed the ibm ptf but
we can't recreate it .

On Tue, Jun 22, 2021 at 8:14 AM <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

> 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
> 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
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com