· 7 years ago · Dec 02, 2018, 02:44 PM
1 Ohai interpol document <3 @LulzSecEurope
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 --***************************************************************************
20 -- Licensed Materials - Property of IBM
21 --
22 -- Governed under the terms of the International
23 -- License Agreement for Non-Warranted Sample Code.
24 --
25 -- (C) COPYRIGHT International Business Machines Corp. 2006
26 -- All Rights Reserved.
27 --
28 -- US Government Users Restricted Rights - Use, duplication or
29 -- disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
30 --***************************************************************************
31
32
33 -- sample script for setting up a db2 database for xml on a windows 2000 system
34 -- to invoke, open a db2 command window and type "db2 -tvf tutorial.sql"
35
36 -- this script presumes the db2 "sample" database exists.
37 -- if not, uncomment the following line.
38 -- create database sample using codeset utf-8 territory us;
39
40 CONNECT TO sample;
41
42 -- the following line will fail on the first run because no "clients" table exists.
43 -- ignore the failure. or, alternately, comment out this line.
44 drop table clients;
45
46 create table clients(id int primary key not null, name varchar(50), status varchar(10), contactinfo xml);
47
48 -- insert sample data
49 insert into clients values (3227, 'Ella Kimpton', 'Gold',
50 '<Client>
51 <Address>
52 <street>5401 Julio Ave.</street>
53 <city>San Jose</city>
54 <state>CA</state>
55 <zip>95116</zip>
56 </Address>
57 <phone>
58 <work>4084630000</work>
59 <home>4081111111</home>
60 <cell>4082222222</cell>
61 </phone>
62 <fax>4087776666</fax>
63 <email>love2shop@yahoo.com</email>
64 </Client>'
65 );
66
67
68 insert into clients values (8877, 'Chris Bontempo', 'Gold',
69 '<Client>
70 <Address>
71 <street>1204 Meridian Ave.</street>
72 <apt>4A</apt>
73 <city>San Jose</city>
74 <state>CA</state>
75 <zip>95124</zip>
76 </Address>
77 <phone>
78 <work>4084440000</work>
79 </phone>
80 <fax>4085555555</fax>
81 </Client>'
82 );
83
84
85 insert into clients values (9077, 'Lisa Hansen', 'Silver',
86 '<Client>
87 <Address>
88 <street>9407 Los Gatos Blvd.</street>
89 <city>Los Gatos</city>
90 <state>CA</state>
91 <zip>95032</zip>
92 </Address>
93 <phone>
94 <home>4083332222</home>
95 </phone>
96 </Client>'
97 );
98
99
100 insert into clients values (9177, 'Rita Gomez', 'Standard',
101 '<Client>
102 <Address>
103 <street>501 N. First St.</street>
104 <city>Campbell</city>
105 <state>CA</state>
106 <zip>95041</zip>
107 </Address>
108 <phone>
109 <home>4081221331</home>
110 <cell>4087799881</cell>
111 </phone>
112 <email>golfer12@yahoo.com</email>
113 </Client>'
114 );
115
116
117 insert into clients values (5681, 'Paula Lipenski', 'Standard',
118 '<Client>
119 <Address>
120 <street>1912 Koch Lane</street>
121 <city>San Jose</city>
122 <state>CA</state>
123 <zip>95125</zip>
124 </Address>
125 <phone>
126 <cell>4085430091</cell>
127 </phone>
128 <email>beatlesfan36@hotmail.com</email>
129 <email>lennonfan36@hotmail.com</email>
130 </Client>'
131 );
132
133
134 insert into clients values (4309, 'Tina Wang', 'Standard',
135 '<Client>
136 <Address>
137 <street>4209 El Camino Real</street>
138 <city>Mountain View</city>
139 <state>CA</state>
140 <zip>95033</zip>
141 </Address>
142 <phone>
143 <home>6503310091</home>
144 </phone>
145 </Client>'
146 );