CODEWITHSUNDEEP
sqlsap-ase
Jedi.za
Jedi.za

Reputation: 120

What does the SQL "Select 42" do and how to turn it off in Sybase?

We are using Sybase ASE as our DBMS. I've noticed that every query to the DB server is preceded by a "Select 42" call. What exactly does this do?

It seems that it is just a test/ping, is this correct, where does it originate from and how can we turn it off?

Can't seem to find any real documentation on this.

Upvotes: 2

Views: 1194

Answers (1)

RUDY
RUDY

Reputation: 21

it is just a simple test, most likely to check if the connection to the DB is still active. Using Sybase ASE you can SELECT on nothing really and just create a "test function". Like so: SELECT 1 + 1

Upvotes: 2

Related Questions