blocks|key|1458637|text|为成员创建SQL别名并查询别名，有关示例，请参阅this+page。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1458638|entityMap|0|LINK|mutability|MUTABLE|url|http://searchdatamanagement.techtarget.com/tip/0,289483,sid91_gci1228049,00.html#6.%2520Accessing%2520an%2520explicit%2520file%2520member%2520using%2520SQL^0|O|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Create an SQL alias for the member and query the alias, see <a href="http://searchdatamanagement.techtarget.com/tip/0,289483,sid91_gci1228049,00.html#6.%20Accessing%20an%20explicit%20file%20member%20using%20SQL" rel="noreferrer">this page</a> for an example.

blocks|key|1458694|text|您可以使用create+alias命令创建别名：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1458695|CREATE+ALIAS+myLibrary/myAlias+FOR+memberLibrary/memberFile(memberName)|code-block|syntax|javascript|1458696|这将允许您使用别名对该成员运行sql，就像对任何其他文件一样：|1458697|SELECT+*+FROM+myLibrary/myAlias|1458698|只需记住，别名将在您的会话后保留，它们不是临时的。因此，如果完成后不需要别名，可以在QTEMP中创建别名，或者在完成后显式删除别名：|1458699|DROP+ALIAS+myLibrary/myAlias|1458700|HTH|1458701|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You can create an alias using the create alias command:

<pre><code>CREATE ALIAS myLibrary/myAlias FOR memberLibrary/memberFile(memberName)
</code></pre>

This will allow you to run sql against that member using the alias like you would any other file:

<pre><code>SELECT * FROM myLibrary/myAlias
</code></pre>

Just remember that the alias will stick around after your session, they are not temporary. So if you wont need the alias when you are done, either create the alias in QTEMP or explicitly drop the alias once you are done with it:

<pre><code>DROP ALIAS myLibrary/myAlias
</code></pre>

HTH

blocks|key|1673798|text|SQL别名|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1673799|OS/400+R430和更高版本支持SQL别名语句。为必须访问的每个成员创建别名，然后从应用程序引用该别名。别名是一个持久对象--它只能创建一次。创建ALIAS时，CREATE+ALIAS中引用的成员不必存在。任何SQL工具(如OS/400、i5/OS+interactive+SQL+(STRSQL)或iSeries+Navigator's+Run+SQL+Scripts+)都可用于创建别名，例如：|offset|length|style|CODE|1673800|CREATE+ALIAS+MYLIB.FILE1MBR1+FOR+MYLIB.MYFILE(MBR1)+
CREATE+ALIAS+MYLIB.FILE1MBR2+FOR+MYLIB.MYFILE(MBR2)|code-block|syntax|javascript|1673801|http://www-01.ibm.com/support/docview.wss?uid=nas1f1eaeecc0af19cc38625669100569213|1673802|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|B|I|3|23|5|2A|C|2Z|3|36|6|3D|U|48|Z|0|0|0|2A|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@$D|X|E|Y|F|G]|$D|Z|E|10|F|G]|$D|11|E|12|F|G]|$D|13|E|14|F|G]|$D|15|E|16|F|G]|$D|17|E|18|F|G]|$D|19|E|1A|F|G]|$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1D|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1E|8|@]|9|@$D|1F|E|1G|1|1H]]|A|$]]|$1|O|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|N]]]]

SQL Alias 

<code>OS/400 R430</code> and later support an <code>SQL</code> alias statement. Create an alias for each member that must be accessed, then reference the alias from the application. The alias is a persistent object -- it must be created only once. The member referenced in the <code>CREATE ALIAS</code> does not have to exist when the <code>ALIAS</code> is created. Any <code>SQL</code> tool, such as <code>OS/400</code> or <code>i5/OS interactive SQL (STRSQL)</code> or <code>iSeries Navigator's Run SQL Scripts</code>, can be used to create the alias, for example:

<pre><code>CREATE ALIAS MYLIB.FILE1MBR1 FOR MYLIB.MYFILE(MBR1) 
CREATE ALIAS MYLIB.FILE1MBR2 FOR MYLIB.MYFILE(MBR2)
</code></pre>

<a href="http://www-01.ibm.com/support/docview.wss?uid=nas1f1eaeecc0af19cc38625669100569213" rel="nofollow">http://www-01.ibm.com/support/docview.wss?uid=nas1f1eaeecc0af19cc38625669100569213</a>

blocks|key|1673841|text|这是一个老帖子，仍然是搜索结果列表中的第一个，我想加强之前的回复：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1673842|有时您只需要创建别名作为一次性数据库分析，然后您希望创建别名并在查询后立即删除它；您还有一个包含许多表的数据库库，并且不希望在每个查询中限定该库，因此您使用SET+SCHEMA；我喜欢使用QTEMP库创建别名，因为在IBM+AS400服务器上QTEMP本质上是用于临时对象的：|1673843|set+schema=mylibrary;

create+alias+qtemp.aliasx+for+table1(membera);
create+alias+qtemp.aliasy+for+table2(memberb);

select++*+from+qtemp.aliasx;
select++*+from+qtemp.aliasy;

drop+alias+qtemp.aliasx;
drop+alias+qtemp.aliasy;|code-block|syntax|javascript|1673844|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is an old thread and still the first on the search results list, I would like to enhance the previous responses:

Sometimes you only need to create the alias as a one time Database analysis, then you want to create the alias and drop it off immediately after your query; you also have a Data Base library with many tables and don't want to qualify the library in every query so you use SET SCHEMA; I love to use the QTEMP library to create alias since QTEMP by nature on IBM i AS400 servers is for temporary objects:

<pre><code>set schema=mylibrary;

create alias qtemp.aliasx for table1(membera);
create alias qtemp.aliasy for table2(memberb);

select * from qtemp.aliasx;
select * from qtemp.aliasy;

drop alias qtemp.aliasx;
drop alias qtemp.aliasy;
</code></pre>

On AS400 in interactive SQL in a 5250 session,

<pre><code>select * from myfile
</code></pre>

returns rows from one member only when myfile has more than one member.

How can I get rows from a specific member?

Important: in the end I'd like to do this over JDBC with jt400 so really I want a solution that'll work there.

Thanks.

SQL query of multi-member file on AS400

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在5250会话的interactive SQL中的AS400上，select * from myfile仅当myfile有多个成员时，才从一个成员返回行。如何从特定成员获取行？重要提示:最后，我想用jt400在JDBC上做这件事，所以我真的想要一个能在那里工作的解决方案。谢谢。

问AS400上多成员文件的SQL查询
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问AS400上多成员文件的SQL查询EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问AS400上多成员文件的SQL查询
EN