Hi nice groups :)

I like to ask some basic questions about the embed firebird.

Typical embedded DB engines permit to check the consistence of the tables,
and/or verify and repair the files programmatically.

So please can someone explain:

1) which are the API commands to do a check consistency of a DB (and the
return codes) that I'll call typically when the application that embed the
DB start...
2) the command to rebuild indexes and or try to recover a DB without a
BACKUP
3) how to manage files > 2GB (under NT the limit of a file size is of
16Terabytes, if Firebird use WriteFile ReadFile API is enough to use a int64
as index and you don't have the limit of 2GB of normal signed integer;
further you can use MappedFiles to write directly in big chunks increasing
the speed; if you are interested I can send you some example classes in
Delphi)
4) does exists a document that explain all these API commands to do the
management of a DB programmatically without the manual intervention of a
human?

Very thanks for any help (please help :PPP)

Kind regards.

Roberto Della Pasqua.