AS / 400 'SELECT 1' Equivalent

Question

I am trying to help a friend fix problems connecting to the AS / 400. He would like to run a query against AS / 400, which will always return a record (similar to SELECT 1 in MSSQL).

He tried to run SELECT 1 but no luck ... I assume AS / 400 is expecting FROM TableName ...

Can anyone help? Is there a system table / file in which it always exists that it can run SELECT TOP 1 (or its equivalent)? I never interacted with AS / 400, so I'm a bit out of my element ... hoping SO could give me a quick answer ...

Thanks in advance!

Answer 1

, DB2 (, iSeries), :

select * from sysibm.sysdummy1

. IBMREQD, Y.