SQL sentence to test connection

Question

Question

Yuri Marx · Mar 17, 2021

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

Log in or sign up to continue

Robert Cemper · Mar 17, 2021

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

0 0

Yuri Marx · Mar 17, 2021

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

SELECT count(*) FROM INFORMATION_SCHEMA.SCHEMATA

0 0

score 0 · Answer 1 · 2021-03-17T10:59:04-04:00

Robert Cemper · Mar 17, 2021

YES, of course!

0 0

score 0 · Answer 2 · 2021-03-17T11:00:21-04:00

Yuri Marx · Mar 17, 2021

Great Cemper! thanks!

0 0

score 2 · Answer 3 · 2021-03-17T11:31:51-04:00

Eduard Lebedyuk · Mar 17, 2021

SELECT 1

2 0