英語 での Database component の使用例とその 日本語 への翻訳
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
-
Programming
KOffice Database Component.
An overview of low-level and high-level database components.
The database component is now added to the mapping.
Further targets are the creation of a good debugger and a database component.
In this example, the database component has only one table.
The tracing settingswill be inherited by all table actions on this database component.
After you enable tracing, the database component changes its structure on the mapping.
Ask your administrator to upgrade the client components, the database components, or both.
Doing this encloses all changes done by the database component inside a transaction that will be rolled back in case of error.
Creating SELECT Statements You cancreate SELECT statements on any mapping which contains a database component.
As an alternative, select the database component, and then select the menu command Component| Add/Remove/Edit Database Objects.
Refresh Reloads the structure of the currently active database component from the database. .
This opens the Database Component Settings dialog box.2. Select the Use Transactions check box, and choose rollback top transaction and stop.
Adding Stored Procedures to the Mapping On the mapping area,stored procedures are shown as part of the database component where they belong.
The SELECT statement is also displayed on the database component, and you can map data from any of the fields returned by the SELECT query.
When the mapping is configured as shown above,any encountered exception will cause the top-level transaction at database component level to be rolled back.
Only the selected tables, views, etc. will appear on the database component, and you can draw mapping connections to or from them in the standard MapForce way.
Database Component Settings After you add a database component to the mapping area, you can configure the settings applicable to it from the Component Settings dialog box.
To create a local relation:1. Right-click the title bar of a database component and select Add/Remove/Edit Database Objects from the context menu.
When database objects are referenced in a relative way, it becomes possible to switch the mapping to a new database or schema without losing the mapping connections,as follows:•Open the database component settings and click Change.
To open again the"Add/Edit Relations" dialog box,right-click the database component, and select Add/Remove/Edit Database Objects from the context menu.
For example, in the database component illustrated below, a local relation was defined between a recordset column(RS1. Department) and a table column Department. Name.
To treat database objects names as relative to the default schema:1. Right-click the title bar of the database component on the mapping, and select Add/Remove/Edit Database Objects from the context menu.2.
If your mapping does not include any database component, or if you want to connect to a new database, click Quick Connect() and follow the wizard steps to create a new database connection see Examples.
Step 2: Configure error logging To enable tracing, do the following:1. Right-click the title bar of the database component, and select Properties from the context menu Alternatively, double-click the title bar of the database component.
Tracing at database component level To enable tracing at database component level: 1. Right-click the database component, and select Properties from the context menu Alternatively, double-click the title bar of the database component. .
If your mapping already includes a database component, you can select the existing database connection from the upper area of the DB Query pane(by default, the connection is"Offline") and start exploring the database objects and run queries.
Switching Databases and Schemas To change a database component on the mapping so that it uses a new database connection, open the database component settings, click Change, and follow the wizard steps to connect to the new database. .
Trace File Structure When tracing is enabled for a database component, a tracing structure becomes available in the lower half of the component, for example: As illustrated above, the top node in the tracing structure indicates the name of the trace file that will be written when the mapping runs.
Transactions at database component level To enable transactions at database component level, do the following:1. Right-click the database component, and select Properties from the context menu Alternatively, double-click the title bar of the database component. .