AS/400“选择 1”相等的
我正在尝试帮助一位朋友解决 AS/400 的连接问题。他希望对 AS/400 运行一个查询，该查询将始终返回一条记录（类似于针对 MSSQL 的SELECT 1）。
他尝试运行SELECT 1，但没有运气......我假设 AS/400 需要 FROM TableName ...
任何人都可以提供帮助吗？是否有一个始终存在的系统表/文件可供他运行SELECT TOP 1（或等效的）？我从未与 AS/400 互动过，所以我有点不习惯...希望 SO 能给我一个快速的答案...
提前致谢！
I'm trying to help a friend troubleshoot connection problems with an AS/400. He'd like to run a query against the AS/400 that will always return a record, (similar to a SELECT 1 against MSSQL).
He's attempted running SELECT 1 but without luck ... I'm assuming that the AS/400 expects a FROM TableName ...
Can anyone provided assistance? Is there a system table/file that always exists that he can run a SELECT TOP 1 (or it's equivalent) against? I've never interacted with an AS/400 so I'm a bit out of my element ... was hoping SO could give me a quick answer ...
Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我非常确定这些机器上运行的是 DB2（顺便说一句，它们现在称为 iSeries），所以您可以尝试
一下。这应该返回单列
IBMREQD，设置为Y。I'm pretty certain it's DB2 running on those boxes (they're called iSeries now, by the way) so you can give:
a shot. This should return a single column
IBMREQD, set toY.表 QSQPTABL 也可用于此目的。
table QSQPTABL can also be used for this.