Thanks to you both Dean and Harjo - it is possible to restore a Sybase .db database if you have a complete (from birth) .log file
This is accomplished by going into Interactive SQL and performing Translate Log File - this creates a huge SQL statement which you then perform on an identical-but-completely-empty version of your original database file.
My challenge now is that both Sybase Central and Interactive SQL run out of Java heap space memory before they can execute the SQL file. Does anyone know how to increase the Java heap space for Sybase ? (as it runs its own Java Runtime Application aside from Windows)
I have to say that while this is causing a little difficulty at the moment, the ability to add, delete or modify ANY previous transaction in the databases’ history is a credit to the Servoy-Sybase environment and a life saver too
Still struggling here and not helped by Sybase UK much either - was told by UK Support that “…as the Account Manager for Servoy was in Holland, it was not in his (Sybase UK’s) interest to help me’” - well at least he was honest
Does anyone know how to increase java heap space on Interactive SQL for Sybase?