sql - 为什么我的 As400 无法从新创建的成员别名中进行选择？

Question

我已经按照 question 中的描述设置了代码.

创建别名和删除它一样有效。

对于我自己创建的成员，这工作正常，但对于现有成员，我在从别名中选择时遇到以下错误:

SQL State: 42704
Vendor Code: -204
Message: [SQL0204] MyMemberName in MyLib type *FILE not found.

Cause . . . . . : MyMemberName in TPLWHS type *FILE was not found. If the member name is *ALL, the table is not partitioned. If this is an ALTER TABLE statement and the type is *N, a constraint or partition was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, trigger or sequence object was not found. If a function was not found, MyMemberName is the service program that contains the function. The function will not be found unless the external name and usage name match exactly. Examine the job log for a message that gives more details on which function name is being searched for and the name that did not match.

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. If an external function was not found, be sure that the case of the EXTERNAL NAME on the CREATE FUNCTION statement exactly matches the case of the name exported by the service program.

非常感谢您提供的任何帮助。谢谢!

编辑:这是我的代码:

create alias MyLib.MyAlias for MyLib.MyLogicalFile(MyMember);

select * from MyLib.MyAlias;

drop alias MyLib.MyAlias;

当我直接创建物理和逻辑成员时，Lib.Alias 的格式对我有用。也许逻辑文件丢失了？我会仔细检查...

Answer 1

此错误消息可能表明文件/逻辑文件/成员不存在。