英文:
meta data on As400 (IBM i) SQL table QSYS2.SYSTABLES
问题
I am looking at meta data on As400 (IBM i) SQL table QSYS2.SYSTABLES.
Table text (description) seems to be encrypted. Any way to read this column?
SELECT substr(TABLE_NAME,1,10) TABLE_NAME, TABLE_TEXT FROM QSYS2.SYSTABLES
TABLE_NAME TABLE_TEXT
DSPUSRPRF 缂栬緫 缁撴潫 缁濆 缁忕粯 鍗椾緥 鍗椾緥 鍚夊弬 & 鍙峰叓 缃戠粯 & 缃戠粯 鏀垮崄 缀垮崄 缀垮崄
GROUPEPRF 缂栬緫 缁撴潫 缁濆 缁忕粯 鍗椾緥 鍗椾緥 鍚夊弬 & 鍙峰叓 缃戠粯 & 缃戠粯 鏀垮崄 缀垮崄 缀垮崄
LOGIN2 缂栬緫 缁撴潫 缁濆 缁忕粯 鍗椾緥 鍗椾緥 鍚夊弬 & 鍙峰叓 缃戠粯 & 缃戠粯 鏀垮崄 缀垮崄 缀垮崄
英文:
I am looking at meta data on As400 (IBM i) SQL table QSYS2.SYSTABLES.
Table text (description) seems to be encrypted. Any way to read this column?
SELECT substr(TABLE_NAME,1,10) TABLE_NAME, TABLE_TEXT FROM QSYS2.SYSTABLES
TABLE_NAME TABLE_TEXT
DSPUSRPRF ë ? Ê È Ñ Á À Á à ë & í ë ê & ê ã
GROUPEPRF ë ? Ê È Ñ Á À Á à ë & í ë ê & ê ã
LOGIN2 ë ? Ê È Ñ Á À Á à ë & í ë ê & ê ã
答案1
得分: 4
TABLE_TEXT是NVARCHAR。
将其转换为您的语言：
SELECT substr(TABLE_NAME,1,10) TABLE_NAME,
cast(TABLE_TEXT as varchar(50))
FROM QSYS2.SYSTABLES
英文:
TABLE_TEXT is NVARCHAR.
cast to VARCHAR to have in your language :
SELECT substr(TABLE_NAME,1,10) TABLE_NAME,
cast(TABLE_TEXT as varchar(50))
FROM QSYS2.SYSTABLES
答案2
得分: 0
你正在使用什么仿真器？
IBM的Access Client Solutions应该可以很好地处理NVARCHAR...
还提供了运行SQL脚本的选项，这比STRSQL更好。
旧版的Client Access for Windows不支持NVARCHAR。
如果使用第三方仿真器，请与供应商确认。
英文:
What emulator are you using?
IBM's Access Client Solutions should handle NVARCHAR just fine...
And also provides a Run SQL Scripts which is a better option than STRSQL.
The old Client Access for Windows does not handle NVARCHAR.
If using a third party emulation, check with your vendor.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论