I have the following problem when selecting from a system table. What is a likely explanation? Permissions? (AS/400 DB2 from PC using IBM AS/400 Client Access).
SELECT TABNAME,TYPE,CREATE_TIME
FROM SYSCAT.TABLES
WHERE DEFINER =USER
[SQL0204] TABLES in SYSCAT type *FILE not found. Cause . . . . . : TABLES in SYSCAT type *FILE was not found. If this is an ALTER TABLE statement and the type is *N, a constraint was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, or trigger was not found. Recovery . . . : Change the name and try the request again. If the object is a node group, ensure that the DB2 Multisystem product is installed on your system and create a nodegroup with the CRTNODGRP CL command.
Processing ended because the highlighted statement did not complete successfully
SELECT TABNAME,TYPE,CREATE_TIME
FROM SYSCAT.TABLES
WHERE DEFINER =USER
[SQL0204] TABLES in SYSCAT type *FILE not found. Cause . . . . . : TABLES in SYSCAT type *FILE was not found. If this is an ALTER TABLE statement and the type is *N, a constraint was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, or trigger was not found. Recovery . . . : Change the name and try the request again. If the object is a node group, ensure that the DB2 Multisystem product is installed on your system and create a nodegroup with the CRTNODGRP CL command.
Processing ended because the highlighted statement did not complete successfully