gfix -mode read_only database.fdb

function ib_util_malloc(l: integer): pointer; cdecl; external 'ib_util.dll';

function ChangeMyString(const p: PChar): PChar; cdecl;
var
s: string;
begin
s := DoSomething(string(p));
Result := ib_util_malloc(Length(s) + 1);
StrPCopy(Result, s);
end;

DECLARE EXTERNAL FUNCTION ChangeMyString
CString(255)
RETURNS CString(255) FREE_IT
ENTRY_POINT 'ChangeMyString' MODULE_NAME '......'

SELECT ...liste des champs ...
FROM table t1
WHERE conditions
ORDER BY (t1.int_col + seed)*4294967291-((t1.int_col + seed)*4294967291/49157)*49157;

delete firebird.log.5
rename firebird.log.4 firebird.log.5
rename firebird.log.3 firebird.log.4
rename firebird.log.2 firebird.log.3
rename firebird.log.1 firebird.log.2
rename firebird.log firebird.log.1

# cd /opt/firebird<br/>
# rm -f firebird.log<br/>
# ln -s /dev/null firebird.log<br/>

only_from = 192.168.0.0/24

SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE RDB$VIEW_BLR IS NULL
AND (RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG = 0);

SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE RDB$VIEW_BLR IS NOT NULL
AND (RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG = 0);

SELECT f.RDB$RELATION_NAME, f.RDB$FIELD_NAME
FROM RDB$RELATION_FIELDS f
JOIN RDB$RELATIONS r ON f.RDB$RELATION_NAME = r.RDB$RELATION_NAME
AND r.RDB$VIEW_BLR IS NULL
AND (r.RDB$SYSTEM_FLAG IS NULL OR r.RDB$SYSTEM_FLAG = 0)
ORDER BY 1, f.RDB$FIELD_POSITION;

UdfAccess = None
UdfAccess = Full

UdfAccess = Restrict C:\some\directory

UdfAccess = Restrict C:\some\directory;C:\some\other\directory

UdfAccess = Restrict /some/directory

isql localhost:my_database -user sysdba -pass ******
SQL> input my_script.sql;
SQL> commit;
SQL>

isql -i my_script.sql localhost:my_database -user sysdba -pass ******

ExternalFileAccess = None
ExternalFileAccess = Full

ExternalFileAccess = Restrict C:\some\directory

ExternalFileAccess = Restrict C:\some\directory;C:\some\other\directory

ExternalFileAccess = Restrict /some/directory

ALTER TABLE nom_table ALTER nom_champ POSITION nouvelle_position;