>Hi everybody,
>
>I want to get all table names from my database starting with some prefix. I put code like this
>
>SELECT ObjectName FROM DBC() WHERE ObjectType = 'Table' AND PROPER(ObjectName) = 'Something' ;
>ORDER BY 1 ;
>
>
>and it's returning multiple records for one table. Is it an indication that database container may be corrupted?
>
>Thanks in advance.
Try to recreate the index of the dbc. Looking at your SQL-statement and the index of a dbc, I guess that is it.
Another possibility: I hope you didn'tfall in the trap of SET DELETED OFF? In that case it's just setting it ON.
HTH,
Lennert