各位大大好
請問是有有大大瞭解如何用 SQL 查詢出 400 裡 member的資料
目前找到的幾個網路上的方式都失敗,不知是否有前輩能開示開示^^
ex:
Library = Lib
File Name = FName
Member Name = MeName
使用過失敗的方法.
Select * From Lib/FName.MeName
Select * From Lib/FName(MeName)
已邀請的邦友 {{ invite_list.length }}/5
1.需在AS400的SQL中CREATE ALIAS
CREATE ALIAS LIB/Tname FOR LIB/FNAME (MENAME)
2.對ALIAS下SQL指令即可
Select * From Lib/Tname
The statement you used should be correct one:
Select * from LIBRARY/FILE(MEMBER)
Make sure the "edtlibl"-- library list, and Physical files & members are there as you pick. One more, normally, you have to override the member in Physical file. If still not work, try to call IBM Taiwan support based on iSeries serial#.
iThome鐵人賽
看影片追技術