I am can only direct you to the KBA - I guess it requires a s-account to access. In summary, the KBA is listing CVEs that scanners will report as issues with the SQL Anywhere shipped JRE. SQL Anywhere use of the JRE are not at risk to those CVEs. But...
I do not think there is a direct way, but you could construct the query and then run it. You can use the LIST method to create the select list. Here is an example (rough implementation but shows the idea).create or replace table t (
id bigint not ...
You glossed over the details of the "a_restore" error. As I noted, this is a temporary connection that is used during the restore. It may be related to some of the usage issues for the RESTORE. I do not think it is critical in explaining the issue.D...