f



Getting all nodes and node details from xml using xquery

Hi,

I haev the following code:

DECLARE @x xml
SET @x='
<Root>
    <row id="1"><name>Larry</name><oflw>some text</oflw></row>
    <row id="2"><name>Joe</name></row>
    <row id="3" />
</Root>
'
exec sp_xml_preparedocument @idoc OUTPUT, @x
SELECT * FROM OPENXML(@idoc, '/Root')

This gives the following details
id
parentid
nodetype    localname

prefix

namespaceuri
                                                       datatype

                                         prev                  text



I want to get the same details using XQuery, please let me know how to
go about it.

Regards,
Shilpa

0
4/6/2006 10:42:48 AM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

2 Replies
562 Views

Similar Articles

[PageSpeed] 32

Shilpa (shilpa.nagavara@unisys.com) writes:
> I haev the following code:
> 
> DECLARE @x xml
> SET @x='
><Root>
>     <row id="1"><name>Larry</name><oflw>some text</oflw></row>
>     <row id="2"><name>Joe</name></row>
>     <row id="3" />
></Root>
> '
> exec sp_xml_preparedocument @idoc OUTPUT, @x
> SELECT * FROM OPENXML(@idoc, '/Root')
>... 
> I want to get the same details using XQuery, please let me know how to
> go about it.

I am not sure that you can to this easily. You use a very special form
of OPENXML, the one without a WITH clause, that gives you an edge table.
I have never found any use for edge tables, but maybe I've overlooked 
something. 

Since I'm no specialist in XML, I've consulted my MVP colleagues who know
this topic better, so hopefully I will be able to return with a more 
definitive answer.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
0
esquel (7068)
4/8/2006 9:47:06 AM
"Shilpa" <shilpa.nagavara@unisys.com> writes:
>I haev the following code:
>
>DECLARE @x xml
>SET @x='
><Root>
>    <row id="1"><name>Larry</name><oflw>some text</oflw></row>
>    <row id="2"><name>Joe</name></row>
>    <row id="3" />
></Root>
>'
>exec sp_xml_preparedocument @idoc OUTPUT, @x
>SELECT * FROM OPENXML(@idoc, '/Root')
>
>This gives the following details
>id
>parentid
>nodetype    localname
>
>prefix
>
>namespaceuri
>                                                       datatype
>
>                                         prev                  text


I inquired about this, and you can only get localname, namespace URI
and the node's value with XQuery. You cannot get the positional node
information or node ids or prefixes.

For an example, look up the newsgroup microsoft.public.sqlserver.xml.
Michael Rys, who is the Program Manager for XML in SQL Server, and
whom I got this information from, says he recently posted an example
to that group.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

0
esquel (7068)
4/11/2006 9:10:13 PM
Reply:

Similar Artilces:

Get XML values from nodes and child nodes
Hi everybody. My XML file is: <Locatore> <NumeroProgressivo>001</NumeroProgressivo> <CodiceFiscale>CSTNDA69P90H523R</CodiceFiscale> <PersoneFisiche> <Cognome>CAST</Cognome> <Nome>NADIR</Nome> <Sesso>F</Sesso> <DataNascita>10091979</DataNascita> <ComuneNascita>RONCA</ComuneNascita> <ProvinciaNascita>BL</ProvinciaNascita> </PersoneFisiche> </Locatore> <Locatore> <NumeroProgressivo>002</NumeroProgressivo> <CodiceFiscale>PRSGRI74L29F443L</CodiceFiscale> <PersoneFisiche> <Cognome>PERISSI</Cognome> <Nome>IGOR</Nome> <Sesso>M</Sesso> <DataNascita>29071970</DataNascita> <ComuneNascita>MONTE</ComuneNascita> <ProvinciaNascita>SA</ProvinciaNascita> </PersoneFisiche> </Locatore> I need to get in ONE RECORD, both node value and his child nodes values, like this 001 | CSTNDA69P90H523R | CAST | NADIR | F | 10091979 | RONCA | BL 002 | PRSGRI74L29F443L | PERISSI | IGOR | M | 29071970 | MONTE | SA ..... With this: SELECT X.valore.query('NumeroProgressivo').value('.', 'VARCHAR(20)') as NumeroProgressivo, X.valore.query('CodiceFiscale').value('.', 'VARCHAR(16)') as CodiceFiscale FROM Tbulk CROSS APPLY Tbulk.nodes('Fornitura/Documento/S...

Reality check: Is it sensible to link XML nodes to other XML nodes in the same file?
I've got a whole list of descriptions of stages in a production process, which are organised as a sequence of steps, with some branching (i.e. a sort of flow chart)... and thought I'd try and get with the times and model the data using XML! I'm hoping I'll eventually be able to display each 'step' (node) on it's own Web page, and show what link comes next. Is this a sensible thing to attempt to do? If so, how do I link to other nodes in the XML file? Should the <link> be to another node's <id>? And will each node need a 'friendly' <name>, too? (As you've probably gathered, this is all quite new to me...) Any advice or examples would be gratefully received. Gavnosis ...

get a xml node as-it-is
i hve a xml like this: <Students> <Student name = "arun1" number="6"> <Student name = "arun2" number="7"> <Student name = "arun3" number="8"> <Student name = "arun4" number="9"> .... .... .... </Students> i need to build a new xml or a string from this with few student nodes.... some thing like this.. <Student> <Student name = "arun2" number="7"> <Student name = "arun3" number="8"> </Student> by selecting only the two nodes......... is there any api which should return some thing like this ???? "<Student name = "arun2" number="7">" Thanks ArunDhaJ ArunDhaJ wrote: > i hve a xml like this: > <Students> > <Student name = "arun1" number="6"> That is not well-formed, you need e.g. <Student name = "arun1" number="6"></Student> > <Student name = "arun2" number="7"> > <Student name = "arun3" number="8"> > <Student name = "arun4" number="9"> > ... > ... > ... > </Students> > > i need to build a new xml or a string from this with few student > nodes.... some thing like this.. > > <Student> > <Student name = "arun2" number="...

Retrieving XML attribute using XML::XPath::Node::Attribute
Hi I am trying to retrieve an attribute of a particular node from my XML using "XML::XPath::Node::Attribute", but couldn't come across on how to successfully use it in my code. For example, if my xml is: <?xml version="1.0" ?> <data> <server_address port="40">10.0.0.1</server_address> </data> How do I go about fetching the "port" attribute from "server_address" element? Vikrant vikrant wrote: > > <?xml version="1.0" ?> > <data> > <server_address port="40&q...

Selecting Nodes Using Subtotal of Child Nodes
I'm having difficulty finding the correct syntax that will allow me to select a group of invoices based on the total of an amount column located in its line items. Below are simplified examples of my XML and XSLT files: XML FILE <?xml version="1.0" standalone="yes"?> <?xml-stylesheet type="text/xsl" href="OutstandingInvoiceBalances.xslt"?> <ProgramData> <Invoices> <InvoiceID>1</InvoiceID> <InvoiceNumber>100</InvoiceNumber> <Amount>1000.00</Amount> </Invoices> <Invoices> <InvoiceID>2</InvoiceID> <InvoiceNumber>101</InvoiceNumber> <Amount>2000.00</Amount> </Invoices> <Invoices> <InvoiceID>3</InvoiceID> <InvoiceNumber>102</InvoiceNumber> <Amount>3000.00</Amount> </Invoices> <InvoiceLineItems> <InvoiceLineItemID>1</InvoiceLineItemID> <InvoiceID>1</InvoiceID> <AmountToPay>0</AmountToPay> </InvoiceLineItems> <InvoiceLineItems> <InvoiceLineItemID>2</InvoiceLineItemID> <InvoiceID>2</InvoiceID> <AmountToPay>100</AmountToPay> </InvoiceLineItems> <InvoiceLineItems> <InvoiceLineItemID>3</InvoiceLineItemID> <InvoiceID>2</InvoiceID> <AmountToPay>200</AmountToP...

Select Node Using position or value of another node.
Hi, I'm trying to get the value of another node using the position of another node or the name of the tag. Such that the current node is one of the contacts child nodes sec or prim and doing <xsl:value-of select="//cust[seq = position()]/name"/> Should return jon for the prim tag and peter for the sec tag, but fails as position() appears to resolve to the position of cust not the contacts node alternatively I would like to do something like <xsl:value-of select="//cust[seq = [name()='prim' then 0 else 1]]/name"/> <custs> <cust> <seq>0</seq> <name>jon</seq> </cust> <cust> <seq>1</seq> <name>peter</seq> </cust> <contacts> <prim> <message>hello</message> </prim> <sec> <message>hello</message> </sec> </contacts> </custs> Eddy C wrote: > Hi, > > I'm trying to get the value of another node using the position of > another node or the name of the tag. For the difference between tags and elements, see the XML FAQ at http://xml.silmaril.ie/authors/makeup/ > Such that the current node is one of the contacts child nodes sec or > prim > and doing > <xsl:value-of select="//cust[seq = position()]/name"/> > > > Should return jon for the prim tag and peter fo...

Inserting Nodes between Nodes
Hi, XML novice here with another question. I need to add a XML node like, [code] <child01> <child02> <text></text> <image>image 1</image> <image>image 2</image> </child02> </child01> [/code] into this node between the ending </child01> and beginning <child01> of the [code] <child01> <child02> <text></text> <image>image 1</image> <image>image 2</image> </child02> </child01> <child01> <child02> <text></text> <image>image 1</image> <image>image 2</image> </child02> </child01> [/code] Does this make sense? I guess im looking for a way to say/do... make a new node with the following values and place it between these other two nodes. I still am learning XML but i think this can be done. On Jan 21, 12:34 am, cesarcesar <ce...@empiresolutions.net> wrote: > Hi, > > XML novice here with another question. I need to add a XML node like, > > [code] > <child01> > <child02> > <text></text> > <image>image 1</image> > <image>image 2</image> > </child02> > </child...

[HELP] Create a DOM using a node from another node
Hi, I'm posting an answer for people looking about the same thing. private Document createNewDOM(Document srcDocument) { try { //Create the resulting DOM Document resultDocument = DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument(); //import an element (here, it is the root element) from first DOM DocumentFragment df = srcDocument.createDocumentFragment(); documentFragment.appendChild(srcDocument.getDocumentElement()); //Create the Node to append to the new DOM Node importNode = resultDocument.importNode(documentFragment, true); resul...

select nodes with child node A and child node B
I have an XML document that has multiple childe nodes like the one at the end of this message What syntax would I use with selectNodes to select all viewentry nodes that have an entrydata child node with a name attribute equal to "CourseOrMeetingName" that has a text childe node with the text Course ABC AND that also have an entrydata child with a name attribute equal to Start Date that has a datetime child node with the text 20070110 I was trying something like //viewentry[ (entrydata[@name='CourseOrMeetingName'][text='Course ABC']) and (entrydata[@name='StartDate'][datetime='20070110'])]" <viewentry position="1" unid="E5FE575692CAB4CD852572140052F751" noteid="893A" siblings="24"> <entrydata columnnumber="0" name="CourseOrMeetingName"> <text>Course ABC</text></entrydata> <entrydata columnnumber="1" name="StartDate"> <datetime>20070110</datetime></entrydata> <entrydata columnnumber="2" name="City"> <text>West chester</text></entrydata> <entrydata columnnumber="3" name="FirstName"> <text>Joe</text></entrydata> <entrydata columnnumber="4" name="MiddleName"> <text></text></entrydata> <entrydata columnnumber="5" name="LastName"> <text>...

node-node adjacency matrix to a node-arc adjacency matrix
I have been trying to figure out how to create a arc-node adjacency matrix from a node-node adjacency matrix, for example: node-node adj A = [0 1 0 1 1; 0 0 1 1 0; 0 0 0 1 1; 0 0 0 0 1; 0 0 0 0 0]; looking for the following links: 1-2,1-4,1-5,2-3,2-4,3-4,3-5,4-5 arc-node adj B =[ 1 1 1 0 0 0 0 0 -1 0 0 1 1 0 0 0 0 0 0 -1 0 1 1 0 0 -1 0 0 -1 -1 0 1 0 0 -1 0 0 0 -1 -1]; Any help will be greatly appreciated: I have tried to develop a for loop using "A" and assigning -1 to the tail end of the link but with no succes...

How to get the value of an attribute in an XML node?
Hello, This is the url http://eutils.ncbi.nlm.nih.gov/entrez/eutils/esearch.fcgi?db=gene&retmax=10000&term=cmyc of an xml file that I am trying to read and get the values of the <IdList> node in the - <IdList> <Id>30686</Id> <Id>4609</Id> <Id>17869</Id> <Id>5728</Id> <Id>6598</Id> <Id>9111</Id> </IdList> Here is the program that I am trying to read the values of the Id in the XML file ******************************program**************************** public class EUtilParseExample { private static final String urlSearch = "http://eutils.ncbi.nlm.nih.gov/entrez/eutils/esearch.fcgi?"; private static final String urlFetch = "http://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?"; public static void main(String[] args) { InputStream input = null; try { URL u = new URL (urlSearch + "db=gene&retmax=10000&term=cmyc"); input = u.openStream(); System.out.println(u.toString()); XMLInputFactory factory = null; System.setProperty("javax.xml.stream.XMLInputFactory", "com.bea.xml.stream.MXParserFactory"); String filename = ""; //XMLInputFactory factory = XMLInputFactory.newInstance(); factory = XMLInputFactory.newInstance(); XMLEventReader r = factory.createXMLEventReader(filename, input); //iterate as long as there are more events on the input stream while(r...

getting parent node using XLST
Hello, I am having trouble getting the parent node of an xml document using xslt. I am trying to return the node wine, but this does not return wine but the element values under wine. I thouht this would work. I am looking for the prices context and then ask for the parent node right? What am I doing wrong? Thanks in advance for your help. <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"> <xsl:template match="prices"> parent is: <xsl:value-of select="parent::node"/> </xsl:template> </xsl:stylesheet> <wine> <winery>Los Vascos</winery> <year>1998</year> <prices> <list>13.99</list> <discounted>11.99</discounted> <case>143.50</case> </prices> </wine> john smith (princetonharvard@charter.net) wrote: : Hello, : I am having trouble getting the parent node of an xml document using xslt. : I am trying to return the node wine, but this does not return wine but the : element values under wine. : I thouht this would work. I am looking for the prices context and then ask : for the parent node right? : What am I doing wrong? Thanks in advance for your help. : <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" : version="2.0"> : <xsl:template match="prices"> : parent is: <xsl:value-of select=&qu...

Use variables to get unique nodes
Dear Experts, I got stuck with the following problem and need your help. What I wnat to do is to get a set of distinct nodes. Before the distinct I have selected the multiple occourences already sucsessfully. However , the rest does not work as expected. Hope someone can help on that. Rolf ############################### DATA ################################ My XML DATA: <?xml version="1.0" encoding="UTF-8"?> <Root> <TEST> <Pin PinName="A" /> <Pin PinName="B" /> <Pin PinName="B" /> <Pin PinName="C" /> <Pin PinName="X" /> </TEST> <TEST> <Pin PinName="A" /> <Pin PinName="D" /> <Pin PinName="C" /> <Pin PinName="X" /> <Pin PinName="A" /> </TEST> </Root> My Test XSLT: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format"> <xsl:output method="text"/> <xsl:variable name="NewLine" select="'&#x0d;&#x0a;'"/> <xsl:variable name="TestNodes" select="Root/TEST"/> <xsl:variable name="MultiplePins" select="$TestNodes/Pin[@PinName = preceding::Pin/@PinName]&q...

Use of following to get unique nodes???
In the below example I am using the following to try to match only the unique MechanismText nodes within each Subscription node: select="DeliveryPreferences/DeliveryPreference[not(MechanismText=following:: MechanismText)]" Right now, the 2nd select populates correctly, but the 1st select is empty. I know what is going on, but I don't know how to correct it. I would appreciate any ideas, solutions or pointers you can give me. Thanks, John After the transformation, I should have two select lists...one for each Subscription node. 1st Select: <select> <option>Email</option> <option>Fax</option> </select> 2nd Select: <select> <option>Email</option> <option>Fax</option> </select> XSL TEMPLATES <xsl:template mode="standard" match="/myRoot/Response/Subscriptions/Subscription"> <select> <xsl:apply-templates mode="optionbuilder" select="DeliveryPreferences/DeliveryPreference[not(MechanismText=following:: MechanismText)]" /> </select> </xsl:template> <xsl:template mode="optionbuilder" match="DeliveryPreferences/DeliveryPreference[not(MechanismText=following::M echanismText)]"> <xsl:element name="option"> <xsl:choose> <xsl:when test="..//UserPreferenceFlag = 'Y'"> <xsl:if test="UserPreferenceFlag = 'Y'...

Getting to the root node of an xml document
Hello there!I'm trying to get to an xml document root node (named dataroot), I'vetried different things, like :Node node = doc.getFirstChild();Node node = doc.getDocumentElement();Node node = doc.getElementsByTagName("dataroot").item(0);None of them seem to work, the "node" variable is NULL everytime.Here's the start of the XML file, I somebody has an idea, it's be veryhelpful :) Cheers!XML Document :<?xml version="1.0" encoding="UTF-8"?><dataroot xmlns:od="urn:schemas-microsoft-com:officedata"generated="2007-05-25...

XSL HOWDOI use attribute of current node to select a different node?
I know I can select a node by attribute value using something like <xsl:apply-templates select="//*[@Name='Joe']"/> How can I replace Joe with an attribute from the current node? I.e., the current node has an attribute Manager="Fred". I want a select expression something like "//*[@Name='"<xsl:value-of select="@Manager"/>"']" This gives me the text I want, but I can't figure out how to embed it into the xsl:apply-templates' select. I.e., the following won't work; <xsl:apply-templates select="//*[@Name='"<xsl:value-of select="@Manager"/>"']"/> I assume it's a notational nuance I don't know yet, but which will be immediately obvious once someone shows me what it is. Thanks. CB wrote: > I know I can select a node by attribute value using something like > > <xsl:apply-templates select="//*[@Name='Joe']"/> > > How can I replace Joe with an attribute from the current node? I.e., > the current node has an attribute Manager="Fred". Use current()/@Manager instead of 'Joe'. -- Johannes Koch In te domine speravi; non confundar in aeternum. (Te Deum, 4th cent.) ...

XML::LibXML and getting data from elements/nodes
With the code below, I get the following output: Use of uninitialized value in concatenation (.) or string at /home/durrett/proto line 36. Use of uninitialized value in concatenation (.) or string at /home/durrett/proto line 36. Use of uninitialized value in concatenation (.) or string at /home/durrett/proto line 36. Use of uninitialized value in concatenation (.) or string at /home/durrett/proto line 36. (yes, that's literally 14 empty lines, though some have spaces) I would expect, based on my (very simplistic) understanding of perldoc XML::LibXML::Node's...

How to get to XML node from an Xpath expressed in string
Hi mates, I have the following problem in XSLT. I have following variables: ref-file = <path of XML document> eg "xmlDoc.xml" repeatpath = <a repeat path expressed in Xpath like /root/person > eg "/root/person" node = <name of a child node in repeat path> eg" "name" Now, I want to get to the 'node' in XSLT using Xpath. Suppose, the following is the XML document. <?xml version="1.0" encoding="UTF-8"?> <root> <person> <name>Murtaza</name> </person> <person> <name>Rishit</name> </person> <person> <name>Nilesh</name> </person> <person> <name>Chirag</name> </person> </root> I can get the XML document into a variable using document() function. Now, my problem is I have Xpath expressions in string form. I cannot use them where we have to use XSLT patterns and Xpath expressions. How to solve this problem? Murtaza Tinwala. Murtaza Tinwala wrote: > I have the following problem in XSLT. I have following variables: > ref-file = <path of XML document> eg "xmlDoc.xml" > repeatpath = <a repeat path expressed in Xpath like /root/person > eg > "/root/person" > node = <name of a child node in repeat path> eg" "name" > > Now, I want to get to the 'node' in XSLT using Xpath. > > Suppose...

Help. Using a variable to get the position of a node.
I have the following: <xsl:variable name="position"><xsl:value-of select="position()"/></xsl:variable> <xsl:attribute name='style'><xsl:value-of select="//ExportData/Definition/Column[$position]/Style"/></xsl:attribute> However, //ExportData/Definition/Column[$position]/Style always seem to return //ExportData/Definition/Column[1]/Style. Any ideas? ...

Getting to the root node of an xml document #2
(Cross posting, sorry...) Hello there! I'm trying to get to an xml document root node (named dataroot), I've tried different things, like : Node node = doc.getFirstChild(); Node node = doc.getDocumentElement(); Node node = doc.getElementsByTagName("dataroot").item(0); None of them seem to work, the "node" variable is NULL everytime. Here's the start of the XML file, I somebody has an idea, it's be very helpful :) Cheers! XML Document : <?xml version="1.0" encoding="UTF-8"?> <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2007-05-25T20:41:06"> <SITES> <FECD_ID>18</FECD_ID> <LATITUDE>55.53</LATITUDE> <LONGITUDE>-98.41</LONGITUDE> <SITE_INFORMATION> <FECD_ID>18</FECD_ID> <ORIGINAL_SOURCE>Halliwell &amp; Apps, 1997</ORIGINAL_SOURCE> <ORIGINAL_SOURCE_ID>MAN TE-OA (1)</ORIGINAL_SOURCE_ID> <ESTABLISHMENT_DATE>1994</ESTABLISHMENT_DATE> <PROVINCE>MB</PROVINCE> <TERRESTRIAL_ECOZONE>Boreal Shield</TERRESTRIAL_ECOZONE> <TERRESTRIAL_ECOREGION_TEXT>Churchill River Upland</ TERRESTRIAL_ECOREGION_TEXT> <ORDER>Brunisolic</ORDER> <SUB_GROUP_GREAT_GROUP>Gleyed Melanic</SUB_GROUP_GREAT_GROUP> <DRAINAGE_CLASS_ID>Imperfectly</DRAINAGE_CLASS_ID> <FEATURE_DEPTH>33</FEATURE_DEPTH> <SOIL_FEATURE>Carbo...

changing the values of xml nodes using PHP
Hi there, Is it possible to use PHP to change the values of XML nodes in an XML file witout having to extract all the node values, change the variable I want, use PHP to generate the node structure and then save it as an new XML file? For example, say I have the following XML structure in an XML file: <xml... <settings> <width>400</width> <hieght>500</hieght> <color>blue</color> . . . </settings> Is it possible to just use PHP to find the node 'width', change it to 600 and then resave the XML file? Cheers Burnsy &quo...

[podcast] Expert panel discussion of XQuery, native XML databases, SQL/XML databases
WebServicesSummit.com has released two podcasts of a panel discussion with Ron Bourret, Dana Florescu, Michael Kay, Jonathan Robie and Michael Rys. The discussion topics include XQuery, native XML databases, SQL/XML databases, XSLT and related topics. The part 1 podcast (MP3 audio) focuses primarily on XQuery (running time: 34:03). The part 2 podcast covers native XML databases and XML-enabled SQL databases. Running time is 22:46. http://www.webservicessummit.com/People/XQueryGuruPanel.htm Or podcast RSS feeds: XML, SOA and web services podcasts http://www.WebServicesSummit.com/Channels/XMLWebServicesTechTalk.xml SQL/XML and database podcasts http://www.SQLSummit.com/Channels/SQLSummitTechTalkAudio.xml ...

Expert panel podcast (MP3) about XQuery, native XML databases, SQL/XML databases
WebServicesSummit.com has released two podcasts of a panel discussion with Ron Bourret (XML-DBMS), Dana Florescu (Oracle), Michael Kay (Saxonica), Jonathan Robie (DataDirect) and Michael Rys (Microsoft). The discussion include XQuery, native XML databases, SQL/XML databases and related topics. If you don't have an iPod, you can listen with any program that plays MP3 audio (e.g., QuickTime Player, Windows Media Player). The part 1 podcast focuses primarily on XQuery (running time: 34:03). The part 2 podcast covers native XML databases and XML-enabled SQL databases. Running time is 22:46. http://www.webservicessummit.com/People/XQueryGuruPanel.htm Or podcast RSS feeds: XML, SOA and web services podcasts http://www.WebServicesSummit.com/Channels/XMLWebServicesTechTalk.xml SQL/XML and database podcasts http://www.SQLSummit.com/Channels/SQLSummitTechTalkAudio.xml ...

PCT and DCS: How can I reserve nodes in a cluster only once, and use the nodes to run my batch jobs as needed?
Hi, I have Matlab R2009a on a cluster with DCS and LSF. I use the cluster to run large matlab programs that require multiple batch (non-interactive) jobs to compute a final result. My problem is that all the queues in the cluster have long waits, so I'd strongly prefer to avoid having my batch scripts waiting for free slots from LSF every time I need to run a batch job. Is there a way of reserving nodes ahead in the cluster and just once, and then use the nodes to run my batch scripts as required? In case it is useful, I have been using the following sequence of statements every time I need to run a batch job. 1) findResource 2) createJob 3) createTask 4) submit 5) waitForState Thank you "AMVR " <ribonucleico@gmail.com> writes: > I have Matlab R2009a on a cluster with DCS and LSF. I use the cluster to run > large matlab programs that require multiple batch (non-interactive) jobs to > compute a final result. > > My problem is that all the queues in the cluster have long waits, so I'd > strongly prefer to avoid having my batch scripts waiting for free slots from > LSF every time I need to run a batch job. > > Is there a way of reserving nodes ahead in the cluster and just once, and then > use the nodes to run my batch scripts as required? I don't know of any way to do this - but I'm not an expert in using LSF. One alternative approach might be to start up a MATLABPOOL on your LSF workers (which keeps the...

Web resources about - Getting all nodes and node details from xml using xquery - comp.databases.ms-sqlserver

Apple Continues To Deny The FBI From Hacking iPhone, Tech Giant Now Up Against U.S. Justice Department ...
Apple, the world’s most profitable company, will face the Justice Department in a federal court hearing at Riverside, California. The meeting ...

Inside Twitter's 10th birthday party
Twitter celebrated its 10th birthday on Monday. Although the company has had its share of troubles — user growth has stalled and the company ...

Witness, funeral helped lead police to Paris attacks suspect
BRUSSELS (AP) — A keen-eyed witness who spotted a pale, slender figure fleeing an apartment near a Brussels auto plant one week ago set in motion ...

Hulk Hogan gets $140 mn in sex tape case
Jurors awarded wrestling star Hulk Hogan a total of $140 million $25 million more than he was granted last week over a sex tape posted by entertainment ...

Ben Affleck Fights Himself in 'Batman v Superman' Parody Trailer
Visual editor Todd Spence cut a special version of the Batman v Superman: Dawn of Justice trailer to put Ben Affleck against Ben Affleck ! Todd ...

County Donegal, Ireland: Family Of Five Killed As Car Slips Into Sea, Only An Infant Survives
A tragic scene unfolded in County Donegal, Ireland this weekend as a family of five was killed when their car slipped into the sea from a pier. ...

Ex-Intel CEO Andy Grove dies at age 79
SANTA CLARA, California — Andy Grove, the former Intel Corp. chief executive whose youth under Nazi occupation and escape from the Iron Curtain ...

FanDuel, DraftKings shut down daily fantasy sports games in New York
By Michael Erman and Karen Freifeld NEW YORK (Reuters) - Top daily fantasy sports companies FanDuel and DraftKings agreed to halt their business ...

Search Engines and Social Media Sites Led Comscore’s Top 50 Digital Properties in February
Search engines, social media platforms and the digital sites for broadcast media companies grabbed the most traffic in February, according to ...

‘Supergirl’ Episode 17 Recap — Martian Manhunter Origins; Jeremiah Danvers Lives; Silver Banshee Revealed ...
The Flash will make his Supergirl debut next week just as Kara Danvers and friends all begin a new chapter in their National City stories. As ...

Resources last updated: 3/22/2016 4:15:18 AM