Re: SQL7905 Error

[Reeve <rfritchman@xxxxxxxxx>]

"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