Re: SQL7905 Error

"Schemas" are libraries. Try DSPFD on your created table; you'll be able
to see all the attributes of the table, including its journaling status.

On my V7R3 box, I just journaled a library, created a table, and updated it
with DFU, all without errors. The DSPFD shows it's journaled.

It seems that the library journaling might be sideways or there might be
some funky Aldon compile parameter you've missed.

Do wrkobj (your_library) *lib and take option 8 to check the journal
attributes.

Finally, I'd try your process without Aldon--just use STRSQL or iACS to
create the table and then STRJRNPF.

\reeve

On Mon, Jun 21, 2021 at 8:06 PM Elizabeth Heritage <wgheritage@xxxxxxxxx>
wrote:

I'm creating my first SQL table. We use Aldon as our change
management/transfer tool. I've checked with our iSeries folks and they say
that my development library IS being journaled. I've been able to resolve
all errors except for one, SQL7905. When I Google the error, it just says
that the table has to be journaled but I can't find anything on how to
resolve this. I also see references to schemas. I'm familiar with XML
schemas but what are schemas on the iSeries for DB2 tables?

Error: SQL7905 20 1 Position 1 Table FDOCINM01P in $$PD4452 created but
was not journaled.

I've been trying for 3 days to get this table to compile (I've been told
that I must use Aldon's compile option for this, so I am).

Any thoughts?

Regards,
Whizzy Heritage
--
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