AS400多成员集成文件 [英] AS400 Multi-Member Integrated File

问题描述

我正在尝试从AS400上的多成员文件中提取数据.该成员位于集成文件系统内的/qsys.lib/aplus7fts.lib/rcw@@.file(rcwxx.mbr)中.

最好的情况是，我想通过SQL检索此数据.我已阅读有关为 mylib/myfile(member)创建别名 mylib/myfile 的文章. 我尝试失败了.我试图从命令行运行导航别名，并通过导航器运行SQL.

有没有人对此情况有更深入的了解?请帮忙.

I''m trying to extract data from a multi-member file on an AS400. The member resides in /qsys.lib/aplus7fts.lib/rcw@@.file(rcwxx.mbr) within the Integrated File System.

Best case scenerio, I would like to retrieve this data via SQL. I have read articles on doing a create alias mylib/myfile for mylib/myfile(member). I tried this unsuccessfully. I have tried to run the create alias from the command line and the SQL through the navigator.

Does anyone have anymore insight into this situation? Please help.

推荐答案

我不确定AS400上的多成员对象，但是我确实从SQL连接到AS400以提取数据.不确定这是否有帮助，但值得一试

1)使用提供程序IBM DB2 for i5/OS创建链接服务器...
2)在提供程序下，找到IBMDA400，允许进行中，设置为true
3)在您要链接对象的数据库中，添加一个指向您要从中提取数据的对象的新同义词.
4)要测试，请运行同义词

希望这对您有帮助，如果您没有特定的错误消息?

I am not sure about mulit-member objects on the AS400, but I do connect to an AS400 from SQL to extract data. Not sure if this will help but worth a try

1) Create linked server, using provider IBM DB2 for i5/OS...
2) Under providers, locate the IBMDA400, allow inprocess, set to true
3) In the database you want the object linked to, add a new Synonym pointing to the object you want to extract data from.
4) To test, run a select of the synonym

Hope this helps, if not do you have a specific error message?

这篇关于AS400多成员集成文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！