Re: I have come across an interesting SQL issue

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.


???