为什么我的As400从新创建的成员别名中选择？ [英] Why can't my As400 select from a newly created member alias?

问题描述

我已按此问题中所述设置代码。 a>。

I have set up the code as described in this question.

创建别名并删除它。

自己，这是工作正常，但对于现有成员，我从别名中选择时得到以下错误：

For members that I have created myself, this is working correctly, but for existing members I get the following error when selecting from the alias:

SQL状态：42704

供应商代码：-204

消息：[SQL0204] MyLib类型* FILE中找不到MyMemberName。

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

原因。 。 。 。 。 ：
中的MyMemberName未找到TPLWHS类型* FILE。如果成员名为* ALL，表
不进行分区。如果这是一个ALTER TABLE语句，并且类型
是* N，则找不到约束或分区。如果这不是
ALTER TABLE语句，类型为* N，则找不到函数，过程，
触发器或序列对象。如果没有找到函数，
MyMemberName是包含该函数的服务程序。除非外部名称和使用名称
完全匹配，否则将找不到
函数。检查作业日志以获取一条消息，该消息给出了更多的
详细信息，其中正在搜索的函数名称以及
不匹配的名称。

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.

恢复。 。 。 ：更改名称并再次尝试请求
。如果对象是节点组，请确保DB2 Multisystem
产品已安装在系统上，并使用
CRTNODGRP CL命令创建节点组。如果没有找到外部函数，确保
，CREATE FUNCTION语句
上的EXTERNAL NAME的情况与服务程序导出的名称的情况完全匹配。

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.

您可以提供的任何帮助都非常感谢。非常感谢！

Any help you can offer is much appreciated. Thanks!

编辑：这是我的代码：

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

select * from MyLib.MyAlias;

drop alias MyLib.MyAlias;

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

The format of Lib.Alias has worked for me when I directly created the phyiscal and logical members. Perhaps the logical file is missing? I'll double check...

推荐答案

此错误消息可以指示文件/逻辑文件/成员不存在。

This error message can indicate that the file/logical file/member does not exist.

这篇关于为什么我的As400从新创建的成员别名中选择？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！