Is it possible to cancel a query/process using via running sql commands. I want to achieve the same result as running `ncli query cancelprocess <processid>` but using JDBC rather than having to use ncli.
Unfortunately this is not possible. Aster Database Cluster Terminal (ACT) can be used as point of reference. If the task is not possible through ACT, then it is most likely cannot be done by other clients, including JDBC.
You an use Aster Management Console to cancel your queries.
Method 1: Hit abort button in your Tool.
Method 2: ncli
Method 3: Login to AMC > Processes. Click Cancel.