Section 6

This section issues select requests that isolate rows based on the XML data, using the text index.

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
select
	t1.id
from
	ti_address_tbl t1,
	address_tbl 2
where
	t1.id = t2.id and
	t1.index_any = 'USA <in> address'
go
quickpass disabled, reason: local table
SELECT
	id
FROM

	xml_db.dbo.ti_address_tbl
WHERE
	(
		index_any = 'USA <in> address'
	)
id
--------------
1
2
(2 rows affected)
quit

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db	
select 
    t1.id 
from 
    ti_address_tbl t1, 
    address_tbl t2 
where 
	t1.id=t2.id and 
	t1.index_any ='USA <in> country'
go
quickpass disabled, reason: local
table
SELECT
	id
FROM
	xml_db.dbo.ti_address_tbl
WHERE
	(
		t1.index_any = 'USA <in> country'
	)
id
-----------------
1
2
(2 rows affected)
quit

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
select 
	t1.id 
from 
	ti_address_tbl t1, 
	address_tbl t2 
where 
	t1.id=t2.id and
	t1.index_any='USA'
go
quickpass disabled, reason: local table
SELECT
	id
FROM
	xml_db.dbo_ti_address_tbl
WHERE
	(
		t1.index_any ='USA'
	)
id
---------------
1
2
(2 rows affected))
quit

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
select 
	t1.id 
from 
	ti_address_tbl t1, 
	address_tbl t2 
where
	(
	t1.id=t2.id and
	t1.index_any='mailstop <in> address <and>
	MA <in>		state'
go
quickpass disabled, reason: local table
SELECT
	id
FROM
	xml_db.dbo_ti_address_tbl
WHERE
	(
		index_any ='mailstop <in> address <and> MA
	<in> state'
	)
id
---------------
1
(1 row affected))
quit

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
select
	t1.id
from
	to_address_tbl t1
	address_tbl t2
where
	t1.id=t2.id and
	t1.index_any =
	'sy <in> filepath <and>
	asesunbox <in> filepath <and> 
	EFTS-15_0 <in> filepath 
	<and> collections <in> filepath <and> 
	made_using_mkvdk <in> filepath <and> 
	xml_data <in> filepath <and> ro* <in> filepath'
go
quickpass disabled, reason: local table
SELECT
	id
FROM

	xml_db.dbo.ti_address_tbl
WHERE
	(
		index_any = 'sy <in> filepath <and>
		ase1501sunbox <in> filepath <and> 
		EFTS-15_0 <in> filepath 
		<and> collections <in> filepath <and> 
		made_using_mkvdk <in> filepath <and> 
		xml_data <in> filepath <and> ro* <in> filepath'
id	)
----------
1
2
(2 rows affected)
quit

isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
select
	t1.id
from
	ti_address_tbl t1,
	address_tbl 2
where
	t1.id = t2.id and
	t1.index_any =
		'sy <in> filepath <and>
		ase1501sunbox <in> filepath <and> 
		EFTS-15_0 <in> filepath 
		<and> collections <in> filepath <and> 
		made_using_mkvdk <in> filepath <and> 
		xml_data <in> filepath <and> row2* <in> filepath'
go
quickpass disabled, reason: local table
SELECT
	id
FROM

	xml_db.dbo.ti_address_tbl
WHERE
	(
		index_any = 'sy <in> filepath <and>
		ase1501sunbox <in> filepath <and>
		EFTS-15_0 <in> filepath <and>
		collections <in> filepath <and>
	   	made_using_mkvdk <in>

		filepath <and>
		row2* <in> filepath')
id
----------
2
(1 row affected)
quit