Question: Currently my Xquery module is running in DataBase 1, I want to fetch the file from fruits.xml from DataBase 2 and the DataBase doesn't have

Currently my Xquery module is running in DataBase 1, I want to fetch the file from fruits.xml from DataBase 2 and the DataBase doesn't have any http/web/dav/xdbc server. And the DataBase 2 exists in same cluster. How can I get file from DataBase 2. My Xquery language is MARKLOGIC. Please answer if are very sure about MARKLOGIC.

Currently my fruits.xml file:

1000

Apple

4

133

1001

Apricot

5

175

1002

Avocado

5

182

1003

Banana

5

187

1004

Bilberry

5

160

1005

Blackberry

4

178

1006

Blackcurrant

5

102

1007

Blueberry

6

156

1008

Currant

5

194

1009

Cherry

5

182

1010

Cherimoya

3

169

1011

Clementine

3

165

1012

Date

6

112

1013

Damson

1

164

1014

Durian

2

157

1015

Eggplant

6

189

1016

Elderberry

3

189

1017

Feijoa

2

198

1018

Gooseberry

2

141

1019

Grape

2

101

1020

Grapefruit

5

199

1021

Guava

1

160

1022

Huckleberry

6

197

1023

Jackfruit

6

181

1024

Jambul

6

117

1025

Kiwi fruit

1

123

1026

Kumquat

2

198

1027

Legume

6

199

1028

Lemon

3

120

1029

Lime

3

165

1030

Lychee

6

120

1031

Mango

6

131

1032

Mangostine

1

181

1033

Melon

4

159

1034

Cantaloupe

4

138

1035

Honeydew melon

4

155

1036

Watermelon

5

176

1037

Rock melon

2

180

1038

Nectarine

1

128

1039

Orange

6

142

1040

Peach

6

179

1041

Pear

3

102

1042

Williams pear or Bartlett pear

1

164

1043

Pitaya

2

170

1044

Physalis

5

166

1045

Plum/prune (dried plum)

4

103

1046

Pineapple

3

120

1047

Pomegranate

5

112

1048

Raisin

4

111

1049

Raspberry

5

156

1050

Western raspberry (blackcap)

6

173

1051

Rambutan

6

145

1052

Redcurrant

3

190

1053

Salal berry

3

137

1054

Satsuma

1

197

1055

Star fruit

4

142

1056

Strawberry

6

178

1057

Tangerine

4

119

1058

Tomato

6

167

1059

Ugli fruit

4

179

1060

Watermelon

6

149

1061

Ziziphus mauritiana

5

180

and the database connection be like:

Currently my Xquery module is running in DataBase 1, I want to

database1 database2 system objects system objects data data database1 database2 system objects system objects data data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!