Subject RE: [IBO] Detecting shadow file
Author Thomas Steinmaurer
Hi Yagi,

have a look in the Language Reference Guide. System table 'RDB$FILES' should
be your choice. There is a field called RDB$SHADOW_NUMER (SMALLINT) with
following explanation:

"indicates to which shadow set the file
belongs; if the value of this column is 0 or missing,
InterBase assumes the file being defined is a
secondary file, not a shadow file"

"select * from rdb$files where (rdb$shadow_number is not null) or
(rdb$shadow_number > 0)" (without quotes) should give all shadow files for a
given database.

Thomas

> -----Original Message-----
> From: YAGI - Jarosław Gilewski [mailto:yagi@...]
> Sent: Friday, June 22, 2001 6:59 PM
> To: IBObjects
> Subject: [IBO] Detecting shadow file
>
>
> Hi to all,
>
> Is there any way to check if a database has a shadow file and to
> create one
> from IBO?
>
> Yagi
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>