Given a server and filename or server and replica ID, indicates if the specified database is backed by DB2 or not.

Note This @function is new with Release 7.

Syntax

@IsDB2(server : file)

@IsDB2(server ; replicaID)

Parameters

server

Text. The name of the server. Use an empty string ("") to indicate the local computer.

Text. The path and file name of the database. Specify the database path and file name using the appropriate format for the operating system.

Text. The replica ID of the database.

flag

Boolean
• 1 (True) indicates that the specified database is backed by DB2
• 0 (False) indicates that the specified database is not backed by DB2

• The server cannot be reached
• The database specified in file or replicaID cannot be found

This function works in all contexts where @function use is supported, including view selection formulas, column formulas, and from the Web.

If the database has been replicated to a local replica, and an empty string is specified for the server parameter, @IsDB2 will produce an error on the replica. For this reason, it is extremely important to use @Error processing with @IsDB2 when using relative paths.

Example
See Also

@DB2Schema

Glossary