Specifies the SQL statement or stored procedure that the connector executes to check database connectivity.
The following is an example of an SQL statement used as a ping query:
SELECT 1 FROM <tablename>
The following is an example of a stored procedure call (sampleSP) used as a ping query with an Oracle or DB2 database:
call sampleSP( )
Note that stored procedure calls cannot have output parameters. If an input parameter is required by the database, the input value must be specified as part of the ping query. For example:
Call checkproc(2)
Default value: None
Possible values:
SELECT 1 FROM <tablename>