Re: SQL7905 Error

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Randy

Help me here - which PTF and for what issue? Message SQL7905 is not 
anything that needed a PTF that I know of. The issue, to my mind, would 
have to be with Aldon, which I doubt.

So I'm very interested in learning more, if you please!!

Vern

On 6/22/2021 9:09 AM, Randy Cayton wrote:
> 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