Using sqlanywhere 12, we run a full dbbackup daily, with -x option to truncate the active log. The backup is run on the same server, compressed, and ftp'd to a secondary server. We want to add a continuous live backup to the secondary server, to cove...

Trying to compile the sqlanywhere php extension on ubuntu12: phpize ./configure --with-php-config=/opt/php5/bin/php-config make make install But configure fails: : not found: 2519: ./configure: : not found: 2520: ./configure: ./configure: 11467:...

Hello, Attempts to run interactive sql from a command line on a linux server are failing: > dbisql -bash: /opt/sqlanywhere12/bin32/dbisql: file not found Yet the file dbisql does exist. 'source'ing does not fix the problem. This is a fresh instal...

We have a transaction table like this: table txn ( date_created timestamp not null, date_confirmed timestamp null, ... ) Records are inserted with date_confirmed=null, using null to mean it has not been confirmed. The majority o...

We have a composite index of three columns (date, time, pk) where pk is the primary key. The pk column has its own index so why include pk in the composite index? Composite index documentation