DB2.Database

This function retrieves a list of all SQL tables and views from a Db2 database located on a specific server and database instance. The port can also be specified, if necessary, by appending it with a ...

Syntax

DB2.Database(server as text, database as text, optional options as nullable record) as table.

About

This function retrieves a list of all SQL tables and views from a Db2 database located on a specific server and database instance. The port can also be specified, if necessary, by appending it with a colon to the server address. There is an optional parameter called options, which allows for customization of certain features: - CreateNavigationProperties: This setting (true/false) determines whether to include navigation properties in the returned data. The default value is true. - NavigationPropertyNameGenerator: This function provides a way to create names for navigation properties as needed. - Query: If specified, this native SQL query is used to fetch data from the database. Only the first result set will be returned if the query produces multiple results. - CommandTimeout: This duration specifies how long the server-side query is allowed to run before being cancelled. The default setting is ten minutes. - ConnectionTimeout: This duration specifies how long to wait before giving up on establishing a c

Explanation

The record parameter should be defined with a list of options and their corresponding values, such as [option1 = value1, option2 = value2...], or with a specific query like [Query = "select ..."].