Business Unit Empowerment Through Declarative Systems 1

Зарегистрируйтесь, чтобы просмотреть полный документ!

РЕГИСТРАЦИЯ

Business Unit Empowerment Through Declarative Systems 1

DISCLAIMER 2

Presentation Abstract 3

Agenda 4

Incoming! 5

A Happy Partnership 7

Strategic Consequences 8

Did you Know… 9

How did we get here? 10

In the Beginning… 11

And Codd and Date said… 12

Sir Berners-Lee Said… 13

Customers Said. . 14

And there Was Chaos… 15

The Translation “Pain Chain” 16

And the W 3 C Said… 17

A Single Line of SQL 18

Enter the Metadata Registry… 19

Demos 20

XML Schema (XMLSpy Diagram) 23

XForms User Interface (Generated) 24

Metadata Driven Apps Data Flow import 25

How About Reporting on XML data? 26

DB 2 Viper Architecture 27

XQuery 30

XQuery Structure 31

Sample XQuery 32

XSLT and XQuery 33

What I like About XQuery 34

But Can I… 35

Joins in XQuery 36

XQuery Update 37

Stored Procedures For Update CREATE PROCEDURE ECRVADMIN. INCREMENT_COUNTY_CRVID (IN COUNTY VARCHAR(255), OUT SUCESS INT) LANGUAGE SQL BEGIN SET ARG 1 = CONCAT( '<updates><update action="compute" col="1" path="//County[Code=" ' COUNTY " ]/Next. ID/text()">) CPMCALL DB 2 XMLFUNCTIONS. XMLUPDATE( ARG 1, ‘ select COUNTY from ECRVADMIN. COUNTY where id=0', 'update ECRVADMIN. COUNTY set COUNTY=? where id=0', ? ); CALL DB 2 XMLFUNCTIONS. XMLUPDATE( '<updates> <update action="compute" col="1" path="//County[Code=" ]/Next. ID/text()"> ? +1 </update> </updates>', 'select COUNTY from ECRVADMIN. COUNTY where id=0', 'update ECRVADMIN. COUNTY set COUNTY=? where id=0', ? ); CALL DB 2 XMLFUNCTIONS. XMLUPDATE( '<updates> <update action="compute" col="1" path="//County[Code=" COUNTY" ]/Next. ID/text()"> ? +1 </update> </updates>', 'select COUNTY from ECRVADMIN. COUNTY where id=0', 'update ECRVADMIN. COUNTY set COUNTY=? where id=0', ? ); END 38