Category "sqlanywhere"

Why the indexes not speeding up the query?

I have the following query: SELECT TOP 1000 * FROM MyTable WHERE Status = 'N' AND Type is not null ORDER BY mytable.id MyTable has 130 million rows. I also

[Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1'

When I run $ python manage.py inspectdb --database=mssql_database I have the following error django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager

Using SELECT TOP 1 in subquery in outer SELECT list (SAP ASE 16)

I have a query that works in Sybase SQL Anywhere 11 that I need to compile in SAP Adaptive Server Enterprise 16. The code doesn't want to compile in ASE though,