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

问题描述

我已按照此问题.

创建别名和删除别名一样有效.

Creating an alias works, as well as dropping it.

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

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.

原因.....: 我的会员名在未找到 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;

当我直接创建物理和逻辑成员时，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屋！