I installed the code described in this question .
Creating an alias works, as well as removing it.
For members that I created myself, this works correctly, but for existing members I get the following error when choosing from an alias:
SQL State: 42704
Supplier Code: -204
Message: [SQL0204] MyMemberName in MyLib type * FILE was not found.
Reason. ,,: MyMemberName in Type TPLWHS * FILE was not found. If the principal name is * ALL, the table is not split. If it is an ALTER TABLE statement and type * N, no constraint or section was found. If it is not ALTER TABLE and type: N, a function, procedure, trigger, or sequence object was not found. If the function is not found, MyMemberName is a service program containing this function. the function will not be found unless the external name and the use name exactly match. Examine the job log for the message, which gives more details on which to search for the function name and the name that do not match.
Recovery.,: Change the name and try the query. again. If the object is a node group, make sure that the DB2 Multisystem product is installed on your system and creates a node group with the CRTNODGRP CL command. If an external function is not found, make sure that the EXTERNAL NAME case in the CREATE FUNCTION statement exactly matches the case of the name exported by the service program.
Any help you can offer is greatly appreciated. Thanks!
EDIT: Here is my code:
create alias MyLib.MyAlias for MyLib.MyLogicalFile(MyMember); select * from MyLib.MyAlias; drop alias MyLib.MyAlias;
The Lib.Alias format worked for me when I directly created fiscal and logical elements. Perhaps a logical file is missing? I will double check ...
source share