Re: XML tools with WDSC 6 Generate iseries data

Adam,

That is, WDSC can help with the day-to-day usage of DB2 XML Extenders,
but is not required.

Are you saying that I can use the Extenders in WDSC?  I am new to WDSC
and would rather be using it than just Green Screen.

Thanks for the summary!
Deby 

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of AGlauser@xxxxxxxxxxxx
Sent: Friday, October 20, 2006 8:33 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] XML tools with WDSC 6 Generate iseries data

Vernon Hamburg wrote on 20/10/2006 08:39:06 AM:

Debra said that the Extender is a green screen only application - that

is correct. It has nothing to do with the XML tools in WDSC. It gives 
you some ability to work with XML in SQL IIRC.

Well - I hunted down the handout from the presentation I mentioned
earlier
- "XML and the Database", presented at the Toronto User Group annual
education conference, Spring 2006.

So, just to be clear - DB2 Extenders themselves do not run on the PC or
get launched from WDSC or anything like that.  What I think they do
(from a 1000 km view) is this:

1) Allow you to store XML documents as a column in the DB (using a
special data type I think), and to query this column using normal SQL.

2) Provide tools for decomposing XML documents into DB records, or using
a DB table to produce an XML document.  This is the  "DXXSH[R]ED - XML
to
DB2 (iSeries command)" and
     "DXXGENXML - DB2 to XML"


Option 2 requires a DAD file, which tells the commands which XML
elements correspond to a particular DB field (or vice versa for
generating XML). 
WDSC can be used to help one build a DAD file.  From the slide, WDSC can
"generate a DAD file.  Use [the] DAD file with DB2 XML Extender to
retrieve data into XML files [or] store XML files to a relational
database."

That is, WDSC can help with the day-to-day usage of DB2 XML Extenders,
but is not required.

HTH,
Adam

########################################################################
#############
Attention:
The above message and/or attachment(s) is private and confidential and
is intended only for the people for which it is addressed. If you are
not named in the address fields, ignore the contents and delete all the
material. Thank you. Have a nice day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
########################################################################
#############
--
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.