iT邦幫忙

0

如何用SQL語法查詢AS400中MEMBER的資料

easonjuan 7 年前9139 瀏覽

各位大大好
請問是有有大大瞭解如何用 SQL 查詢出 400 裡 member的資料
目前找到的幾個網路上的方式都失敗,不知是否有前輩能開示開示^^
ex:
Library = Lib
File Name = FName
Member Name = MeName

使用過失敗的方法.
Select * From Lib/FName.MeName
Select * From Lib/FName(MeName)

2 個回答

8
enchi
iT邦新手 2 級 ‧ 7 年前
最佳解答

1.需在AS400的SQL中CREATE ALIAS
CREATE ALIAS LIB/Tname FOR LIB/FNAME (MENAME)
2.對ALIAS下SQL指令即可
Select * From Lib/Tname

4
insider
iT邦研究生 5 級 ‧ 7 年前

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#.

我要發表回答

立即登入回答