Re: I have come across an interesting SQL issue

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Mark,

Did you look for table INLPGM?  Or just "usr_initial_program_override"?

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /

On 2/8/2024 6:36 AM, Mark Murphy wrote:
> Maybe someone can explain this.
>
> create or replace table usr_initial_program_override
>
> FOR SYSTEM name INLPGM
>
> (prefix char(2) default ' ' primary key,
>
> library char(10) default ' ' not null,
>
> name char(10) default ' ' not null
>
> );
>
>
> The above fails with SQL Error [42710]: [SQL0601]
> USR_INITIAL_PROGRAM_OVERRIDE in JMMLIB type *FILE already exists.
>
>
> It doesn't exist, I *ALLOBJ on this box, and I can't find it using WRKOBJ
> or by querying SYSTABLES. In addition:
>
>
> SELECT * FROM jmmlib.usr_initial_program_override;
>
>
> Fails with SQL Error [42704]: [SQL0204] USR_INITIAL_PROGRAM_OVERRIDE in
> JMMLIB type *FILE not found.
>
>
> If I change the SQL file name, it works. I have 2 files this happened with,
> both ended with override, and when I changed the override part of the name
> to ovrd, they started working.
>
>
> ???