Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
PC Desktops - HP Integrity NonStop H-Series (16.73 mb)
PC Desktops - HP Integrity NonStop H-Series (957.56 kb)
PC Desktops - HP Integrity NonStop H-Series (881.66 kb)
PC Desktops - HP Integrity NonStop H-Series (965.62 kb)
PC Desktops - HP Integrity NonStop H-Series (676.93 kb)
PC Desktops - HP Integrity NonStop H-Series (393.72 kb)
PC Desktops - HP Integrity NonStop H-Series (776.57 kb)
Anleitung Zusammenfassung
Contents
Components and Format of the Row Type ......................................................... 76
Defining the Column Type(s) ......................................................................... 79
Stored Procedure Type Tree Structure .................................................................. 89
Oracle8 AQ Message Type Tree Structure ............................................................... 90
Chapter 5 - Database Sources and Targets
Using a Database as a Source.............................................................................. 91
Defining a Database Source in the Map Designer ................................................. 91
Database GET > Source Settings ..................................................................... 93
Using a Database as a Target.............................................................................. 94
Defining a Database Target in the Map Designer.................................................. 94
Database PUT > Target Settings...................................................................... 96
Database Connections and Transactions................................................................. 96
Transactional Control.................................................................................. 97
Database Connection Management .................................................................. 97
Connection Example ..................................................................................100
Chapter 6 - Updating Database Tables
Using Key and Update Columns ......................................................................... 101
Defining Key and Update Columns...................................................................... 102
Specifying Update Mode .................................................................................. 103
Using the Map Designer or Integration Flow Designer...........................................103
Using an Adapter Command at Execution Time ..................................................104
Example Using Update Key Columns ................................................................... 105
Example Using Update Columns......................................................................... 107
Chapter 7 - Database Functions
Accessing Database Information in a Map Rule....................................................... 110
Using DBLOOKUP and DBQUERY ......................................................................... 110
Syntax1 - Using a Static .mdq File..................................................................111
Syntax2 - Using Dynamic Adapter Commands ....................................................112
Using Bind Values in Database Functions.............................................................. 118
Chapter 8 - Using Stored Procedures
Calling Stored Procedures................................................................................ 121
The Database-independent Syntax for Calls ......................................................122
Examples Using Stored Procedures ..................................................................... 122
Returning the Value from a Stored Function .....................................................123
Using a Stored Procedure as an Input.................................................................. 124
Using a Query to Execute a Stored Procedure....................................................126
Using a Stored Procedure as an Output................................................................ 127
Stored Procedures with Object Type Parameters.................................................... 128
Chapter 9 - Database Triggers
Database Triggers Overview ............................................................................. 130
Database Support ......................................................................................130
Installation Requirements............................................................................131
Tables Created for Triggering .......................................................................132
Maintaining Triggering Tables .......................................................................133
Table-based Triggering ...............................................................................135
Row-based Triggering .................................................................................135
D a t a b a s e I n t e r f a c e D e s i g n e r R e f e r e n c e G u i d e
4
...Dieses Handbuch ist für folgende Modelle:
PC Desktops - HP NonStop G-Series (1 mb)
PC Desktops - HP NonStop L-Series (1 mb)