Re: SQL7905 Error

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

--
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