Re: SQL7905 Error

[Charles Wilt <charles.wilt@xxxxxxxxx>]

That's a warning message, sev 20, not really an error...

Shouldn't stop anything unless you've changed default to halt on a warning.

Aldon compiles objects into a temp library, in your example $$PD4452,
before moving to the actual library.  I don't think you can journal a table
in the temp library.

Are you using distribution/deployments(?) to move from a dev LPAR/library
to a prod LPAR/library?  Or are you running Aldon all on one box over the
actual prod libraries?

I've never had an issue moving SQL tables, but I've also always ran Aldon
with deployments to the actual prod library.  The PDN environment was
pointed to an Aldon created library, not the actual production library.

HTH,
Charles


On Mon, Jun 21, 2021 at 9: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