How to declare TSQL variable over JDBC connection?

Question

Question

Scott Beeson · Nov 18, 2016

I'm trying to use the standard TSQL DECLARE syntax but I get the following error:

[%msg: < IDENTIFIER expected, @ found^ DECLARE @>]

How do I declare a variable? For instance:

DECLARE @numrecords int = 10;
SELECT TOP @numrecords FROM mytable;

Discussion (3)0

Log in or sign up to continue

Dmitry Maslennikov · Nov 22, 2016

JDBC doesn't have any directives in this case, but I think if you ask InterSystems via WRC, about this feature, they may add it in new versions.

0 0

score 0 · Answer 1 · 2016-11-18T14:14:12-05:00

We can use TSQL from Caché side, with changing dialect to MSSQL, and this statement will work. But not sure how it would be possible with JDBC.

score 0 · Answer 2 · 2016-11-21T09:38:14-05:00

Scott Beeson · Nov 21, 2016

Why is it different? This is very inconvenient :(

0 0