This example shows the contents of the options that the command line calls in Example 8 reference. These options specify the data that the calls for OpenXml should extract, and the SQL table in which they should be stored.
-- Content of input file "depts.opt
"tablename='depts_ext'
rowpattern='//dept'
columns=
' dept_id char( 4 ) "/@dept_id"
dept_name varchar(50) "/@dept_name" '
-- Content of input options file "emps.opt"
tablename='emps_ext'
rowpattern='//dept/emps/emp'
columns=
' emp_id char( 4 ) "/emp_id/text()"
emp_name varchar(50) "/emp_name/text()"
dept_id char(4) "/../../@dept_id"
salary dec(7,2) "/salary/text()"
'-- Content of input options file "emp-phones.opt"
tablename='emp_phones_ext'
rowpattern='/sample/dept/emps/emp/phone'
columns= ' emp_id char( 4 ) "/../emp_id/text()"
phone_no varchar(20) "/@phone_no" '
--Content of input options file "projects.opt"
tablename='projects_ext'
rowpattern='//dept/projects/project'
columns=
' project_id char( 4 ) "/project_id/text()"
dept_id char(4) "/../../@dept_id"
budget dec(7,2) "/budget/text()" '
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
