Question
YURI MARX GOMES · Mar 17, 2021

SQL sentence to test connection

It is common to test a connection sending a general SQL instruction to the database, in Oracle we send select 1 from dual, for example, and in IRIS what the best option?

Product version: IRIS 2020.4
00
1 0 5 71
Log in or sign up to continue

Replies

Just any Select.   e.g. 
          SELECT 17+4 as BlackJack, NOW() as TimeToWin
no table required
or
          SELECT Top 5 *  FROM %TSQL_sys.types

Could be a select into InformationSchema (all namespaces have informationschema tables right?) table? Like:

SELECT count(*) FROM INFORMATION_SCHEMA.SCHEMATA