Skip to main content

Questions tagged [xml]

Short for 'eXtensible Markup Language.' A textual markup language for transferring structured data.

35 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
2k views

Ways to process XML into a relational structure in Postgres

I have a database that is comprised of ~10 tables, most of which have many-to-many relationships with each other (and an associated join table). I am inserting of the order 100k XML files into a raw ...
Sam's user avatar
  • 141
4 votes
0 answers
736 views

SQL Server 2012 Error when creating Selective XML Index on XML Query Plan

I'm trying to create a database solution that will enable me to optimise high CPU/IO/Duration queries to improve overall performance of the database. Part of the optimisation requires persisting ...
Mark Sinkinson's user avatar
3 votes
0 answers
498 views

Why does sql server consider a function that extracts a value from an xml parameter non-deterministic?

I want to add a computed field that extracts a value from another xml column. The function looks like this: create or alter function extractValue(@val xml) returns varchar(14) as begin return @val....
boggy's user avatar
  • 427
2 votes
0 answers
66 views

Insert records from output 1 to every record of output 2 from the same XML file in SSIS

I am using an XML document as a source in SSIS as below <?xml version="1.0" encoding="utf-8"?> <Doc> <Header> <ShipmentCode>ABC-EFG-123</ShipmentCode> <...
default_noob_network's user avatar
2 votes
0 answers
219 views

XML parsing failed

I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
paweloque's user avatar
  • 1,089
2 votes
0 answers
413 views

going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?

Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like <allData> <product1> <...
fa1c0n3r's user avatar
  • 617
1 vote
0 answers
124 views

SQL Error 6304 - XML parsing: An unexpected error has occurred in the XML parser

I'm running SQL Server 2019 and not sure if it's related to this, but on SQL Server 2014 if I create a table as follows CREATE TABLE MyTable ( FieldA smallint NOT NULL, FieldB xml NOT NULL ) And ...
vaskitup's user avatar
1 vote
0 answers
1k views

IBM db2 FOR XML equivalent

I've been trying to Query an item with its sublist all in one go and one way is to use for xml and subquery. I've been using this strategy with sql server and works fine. The relationship is Order ...
Carl's user avatar
  • 43
1 vote
0 answers
104 views

PostgreSQL FTS for quoted xml tags - is it possible?

I use Pg FTS to text-search database containing some technical descriptions/comments. Which in particular happen to contain XML snippets. Those are amazingly difficult to find by XML tags. I found ...
Mekk's user avatar
  • 111
1 vote
0 answers
229 views

Converting an XML field to nvarchar causes warning on main SELECT in explain plan

I'm getting a warning on my main SELECT on one field in the explain/execution plan of my query on the following: SELECT ISNULL(CAST(p.loadDiagnostic as nvarchar(4000)),'''') FROM myTable p This ...
shawnyshawny's user avatar
1 vote
0 answers
119 views

Referencing a value of a prior column in a default expression in xmltable()

I'm trying to reference a preceding column c1 in a default value of another column c2 in the xmltable() function, but I get an error: column c1 does not exist. SELECT * FROM xmltable( '.' PASSING ...
Ivan Ustûžanin's user avatar
1 vote
1 answer
200 views

SQL Server 2014 - UPSERT XML Multiple rows

We have an input like this <?xml version="1.0" encoding="UTF-8"?> <Orders xmlns:jjsales:api:sales> <Order> <OrderID>334</OrderID> ...
Joe's user avatar
  • 359
1 vote
0 answers
60 views

Finding and replacing non-specific text to lowercase variant

I've been cracking my brain on a problem that I had at work. In one of my tables is a bunch of rows, with a certain column that contains XML data that has several properties like this: (simplified) &...
Nick's user avatar
  • 111
1 vote
0 answers
528 views

Convert XML data into table in mysql

I have a XML data like this <Root> <Data> <Heading>Time Management</Heading> <Field> <Description>Prioritizing work</Description> <...
Nikesh Kedlaya's user avatar
1 vote
0 answers
145 views

xmlforest() omits any fields that are null entirely, instead of creating an "empty" element

I'm know I can use an empty string, but I don't want to lose the null functionality in the database. In some cases null is appropriate and I can't use empty strings. Other than a empty string, how ...
E.E's user avatar
  • 111
1 vote
0 answers
866 views

export data to xml by the use of query to xml then importing it using xpath

i have use QUERY_TO_XML function in order to export data to xml , after that i want to export this data. this data might contain reserved chars in the xml tags like "' & ..." ex electrical ' ...
Mohammed Falha's user avatar
1 vote
0 answers
623 views

Register XML schema using dbms_xmlschema in Oracle 11g

I have a xsd file located at C:\temp\test.xsd I need to register this schema to create a XMLType table for Object Relational XML Storage. How do I register the schema for relational storage? I do ...
user32262's user avatar
  • 131
1 vote
0 answers
147 views

DB2 crashes when XML columns used in Cursors inside a SP

This is the Stored Procedure code written in DB2 V9.7 LUW FP5 **CREATE OR REPLACE PROCEDURE USP_TEST ( IN LOC_LIST XML) P1: BEGIN ATOMIC DECLARE IV_SOV_LOC_ID BIGINT; DECLARE ...
Senthil's user avatar
  • 159
1 vote
0 answers
188 views

Can XML columns in Oracle/MS SQL Server replace document oriented databases to some extent?

Just a strategic question: I am currently working with frequently changing data schemas and it takes a lot to keep track of versions and specific content. I do, however, have a classic OLTP ...
Erik Hart's user avatar
  • 510
1 vote
0 answers
623 views

XML Data convert to SQL database,

I have an XML feed that i need to parse daily, i want to store all of the data from the XML feed in a SQL table so then that data can be queried and manipulated by my clients. I can currently parse ...
user1714133's user avatar
1 vote
0 answers
324 views

FOR XML EXPLICIT problems in SQL Server 2005 Express

SQL Server 2005 Express Service Pack 2 w/Advanced Services Windows 2003 R2 I recently migrated a database from MSDE 2000 to MSSQL 2005 that is used for a tourist website that can be displayed in one ...
Craig Efrein's user avatar
  • 9,650
0 votes
0 answers
34 views

Export query result to Oracle Server

I have written PL/SQL code to store XML into cursor. Refer the below code Requirement: As of line at line 83, I am inserting the result into another table (XML_GEN) as XMLTYPE datatype. Line: insert ...
user3792741's user avatar
0 votes
0 answers
56 views

How should I deal with sub attributes of xml data when loading onto mysql?

I have some xml files (example below). As you can see in the xml, id 4 has 3 entries for tax. When I load it right now, only the last entry gets inserted into the table. How can I include all 3 of ...
scientific_explorer's user avatar
0 votes
0 answers
282 views

How to open .bin SQL database?

I'm stuck and not sure if somebody had a similar issue. I have an old database stored as .bin files. It dates back to 2012. I can see an xml catalogue file which indicates to me that it is some kind ...
Ali Nato's user avatar
0 votes
1 answer
253 views

Get the last ID from Multiple Stored Procedures Executed

So I have an XML file , to take data from it and insert into tables. For this I’ve created 3 procedures(INSERTXMLMultipleTables,INSERTXMLNIAC,INSERTNIACFORCOMPONENTS). The logic of these procedure is ...
dan morcov's user avatar
0 votes
1 answer
244 views

vertica/postgres copy text to binary column

Until now I used Oracle to store xml file in blob data type column. Is there any option in Vertica to copy xml file into binary column? I saw there is varbinary data type but, I haven't succeeded to ...
NoamiA's user avatar
  • 103
0 votes
0 answers
411 views

Stored procedure or Table Function doesn't return value when parsing XML

Script to create table and function at the bottom of the post: We have lately ran into problem that sometimes our stored procedures or Multi-statement table value that include sql statement parsing ...
Zikato's user avatar
  • 5,062
0 votes
0 answers
358 views

Importing XML Data into SQL Server Table

So after searching on here, I couldn't find an answer to this problem I am having. I am trying to import StackExchange's DB Dump into SQL Server to do some testing and learning overall. However, they ...
Chessbrain's user avatar
  • 1,213
0 votes
1 answer
39 views

how to Upload xml data to db Table by check primary key in oracle

i want to upload xml file data to db table by checking the primary key and wants update the each row data.Here trid getting as a primary key.example OFF 1133 2388977 is their any solution ...
Randula Salgado's user avatar
0 votes
1 answer
140 views

SQL to XML with multiple values

Hello I'm new to converting SQL to XML. I have been trying to get this to work for the past few days. SELECT Item.foldername AS "foldername", Item.status, Item.vhrid, Item.firstname, Item....
James's user avatar
  • 1
0 votes
0 answers
60 views

How to deploy XSD from SQLCLR?

I have few SQLCLR functions implementing business logic that return SqlXml data. I would also like to make the Xml Schema Definitions in the dll available in Sql Server. It's not a '...
Jeff Sacksteder's user avatar
0 votes
0 answers
495 views

XML Serialization in SQL Server 2005 CLR

I know this question has been asked before, but none of the answers I've tried seem to work for me. I'm trying to execute a CLR Stored Procedure in Sql Server 2005. The CLR generates a file, sends it ...
jlasarte's user avatar
  • 101
-1 votes
1 answer
174 views

XML Reader Performance

I am trying to optimize a query and it seems that this code, specifically the XML Reader is causing the issue. insert into #temp1 (Items, ApplicationId) select distinct convert(varchar(2000),z.query('....
A_Arnold's user avatar
  • 115
-1 votes
1 answer
5k views

want to import exported xml file in wamp phpmyadmin

I have exported single table from wamp phpmyadmin as xml file for data verification and want to import it again into database as mysql table. Please give me guidance, how its possible?
Eric D' Silva's user avatar
-2 votes
1 answer
4k views

Example creating a PostgreSQL XML data type

I am looking for an SQL example where a table is created in PostgreSQL which has a field with data type XML.
CW Holeman II's user avatar