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
Discussion (5)1
Comments
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.SCHEMATAYES, of course!
Great Cemper! thanks!
SELECT 1