Lotus Domino Designer 8 Help - Examples: @DB2Schema

FORMULA LANGUAGE

Examples: @DB2Schema
This function can be used in field, column or selection formulas.

1. This formula returns the schema name FRITES if a database exists and is DB2 backed or "" if it is not DB2 backed.

@DB2Schema( "Belgium" : "mail\\frites.nsf" )

2. This formula returns DB2 information about a database using its replica ID instead of its file name:

@DB2Schema("Cheshire";"852556DO:00576146")

3. These formulas both return DB2 information about the current database:

@DB2Schema(@DbName)

4. This example uses @DB2Schema in a query to pull firstname and lastname information from the dav1 table in the same schema as the current database:

"SELECT firstname, lastname FROM " + @DB2Schema( @DbName ) + ".dav1"

5. This example uses @DB2Schema with error handling in a column formula to return the schema of the local db2nsf database referenced in the dbname field of the document:

@IfError(@DB2Schema(@DBName);"Error")

6. This example first uses @IsDB2 to find out if a connection to DB2 is available, and if the local database referenced in the dbname field of the document is a DB2 database, so that a more meaningful error message may be displayed from @DB2Schema:

result1 := @IsDB2("":dbname); result2 := @DB2Schema(@DBName) @If(@IsError(result1);"Unable to find database or lost server connection"; result1;@If(@IsError(result2); "Unable to find database or lost server connection";result2); "Not a DB2 database");

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary