CODEWITHSUNDEEP
jdbcsap-ase
guru
guru

Reputation: 173

How do I get the exact Sybase ASE version using JDBC?

It turned out, that the SQL syntax for creating a trigger has changed between ASE 15.7 and 16.0. While in the former 

CREATE TRIGGER ...

must be used, the later await 

CREATE OR REPLACE TRIGGER ...

must be used.

I know, on SQL it's SELECT @@version or using sp_version, but with JDBC?

Upvotes: 0

Views: 1440

Answers (1)

Richard Crossley
Richard Crossley

Reputation: 586

Running select@@version through a JDBC connection should work and yield the same information as returned through isql.

Sample Code from SAP/Sybase documentation.

Upvotes: 1

Related Questions