Reading XML file from RPGLE program by using XML-INTO opcode
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
Error -2147467259 in Visual Basic 6.0 while sending XML to Web Service
Hi, I am using Web Service for Payment Gateway. I have written below code. It is working in Windows XP Operating System. But when I am running this application in “Windows Embedded System (Operating System)”, it is showing as “System Error -2147467259″. I am unable to trace the error. Please help me. Here is the [...]
Answer Question
| January 14, 2013 12:33 PM
Visual Basic 6.0, XML
Hi, I am using Web Service for Payment Gateway. I have written below code. It is working in Windows XP Operating System. But when I am running this application in “Windows Embedded System (Operating System)”, it is showing as “System Error -2147467259″. I am unable to trace the error. Please help me. Here is the [...]
Answer Question
| January 14, 2013 12:33 PM
Visual Basic 6.0, XML
How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype [...]
Answer Question
| September 10, 2012 5:36 PM
SQL Server 2008, XML
I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype [...]
Answer Question
| September 10, 2012 5:36 PM
SQL Server 2008, XML
How to convert XML to AS400 PF with V5R2?
Hi All, How do I convert XML into as400 PF by using V5R2? As I know, XML-INTO and XML-SAX command only applicable for V5R4 and above. My XML file not in one-by-one tag (I open it from note pad). Thanks a lot.
Answer Question
| June 5, 2012 1:18 AM
XML
Hi All, How do I convert XML into as400 PF by using V5R2? As I know, XML-INTO and XML-SAX command only applicable for V5R4 and above. My XML file not in one-by-one tag (I open it from note pad). Thanks a lot.
Answer Question
| June 5, 2012 1:18 AM
XML
Problems exporting Access table to XML file
I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata"" generated=""2012-05-17T08:57:06"">[/dataroot]
Answer Question
| May 17, 2012 2:50 PM
Access, XML
I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata"" generated=""2012-05-17T08:57:06"">[/dataroot]
Answer Question
| May 17, 2012 2:50 PM
Access, XML
error in grid xml: each dimension must be used once and only once
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]
Answer Question
| April 19, 2012 1:52 PM
Hyperion, Microsoft Excel, XML
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]
Answer Question
| April 19, 2012 1:52 PM
Hyperion, Microsoft Excel, XML
How to use “OR” condition in IF ELSE statement
Hi, How to compare multiple element values in if else condition of XML? Is there any syntax like “OR” example if the element is “NAME” and it has values as (‘RAMA’,'SHAYAM’,'SUNNY’,'DAVID’)? Is there anything like <?if:NAME=’RAMA’ OR ‘SHAYAM’ OR ‘SUNNY’?> I want to use this in if else statement ..for every value like ‘RAMA’, ‘SHYAM’ [...]
Answer Question
| September 17, 2012 1:52 PM
Microsoft Word 2007, XML
Hi, How to compare multiple element values in if else condition of XML? Is there any syntax like “OR” example if the element is “NAME” and it has values as (‘RAMA’,'SHAYAM’,'SUNNY’,'DAVID’)? Is there anything like <?if:NAME=’RAMA’ OR ‘SHAYAM’ OR ‘SUNNY’?> I want to use this in if else statement ..for every value like ‘RAMA’, ‘SHYAM’ [...]
Answer Question
| September 17, 2012 1:52 PM
Microsoft Word 2007, XML
Infopath XML List
What if I have multiple data to be connected to a single category e.g. Category = “Family” and Data = ”Father”, “Mother”, ”Brother” and ”Sister”? *Note – I am using xml file. When I pull out the category, “Family”, I want to either reflect the first data only or just one of them or to reflect them all [...]
Answer Question
| March 1, 2012 5:48 AM
Infopath, XML
What if I have multiple data to be connected to a single category e.g. Category = “Family” and Data = ”Father”, “Mother”, ”Brother” and ”Sister”? *Note – I am using xml file. When I pull out the category, “Family”, I want to either reflect the first data only or just one of them or to reflect them all [...]
Answer Question
| March 1, 2012 5:48 AM
Infopath, XML
export xml file of new stored data into a folder through trigger in sql server!
Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put [...]
Answer Question
| October 24, 2011 12:08 PM
SQL, XML
Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put [...]
Answer Question
| October 24, 2011 12:08 PM
SQL, XML
Parsing a XML file with Chinese Characters in AS/400
I am working on a project which require to parse a XML file (in UTF-8 encoding) and put the value into a AS/400 physical file by using JAVA. However, one of the tags in XML may contain both Traditional Chinese and Simplified Chinese characters. The field in the physical file has already defined as DBCS [...]
Answer Question
| March 31, 2012 4:33 AM
AS/400, CCSID, Java, UTF-8, XML, XML development, XML File Creation
I am working on a project which require to parse a XML file (in UTF-8 encoding) and put the value into a AS/400 physical file by using JAVA. However, one of the tags in XML may contain both Traditional Chinese and Simplified Chinese characters. The field in the physical file has already defined as DBCS [...]
Answer Question
| March 31, 2012 4:33 AM
AS/400, CCSID, Java, UTF-8, XML, XML development, XML File Creation
UTC Date/Time formatting using Javascript
Hello Everyone, I’m having trouble figuring out how to format a date and time for display. I’m using the Google Stock Quote API to generate XML and processing that XML for display. Here’s the link to the XML: http://www.google.com/ig/api?stock=GOOG When processing that XML, you get a trade date and time: <trade_date_utc data="20110927"/> <trade_time_utc data="184233"/> <exchange_timezone [...]
Answer Question
| March 31, 2012 6:50 PM
Date format, Google API, JavaScript, jquery, XML
Hello Everyone, I’m having trouble figuring out how to format a date and time for display. I’m using the Google Stock Quote API to generate XML and processing that XML for display. Here’s the link to the XML: http://www.google.com/ig/api?stock=GOOG When processing that XML, you get a trade date and time: <trade_date_utc data="20110927"/> <trade_time_utc data="184233"/> <exchange_timezone [...]
Answer Question
| March 31, 2012 6:50 PM
Date format, Google API, JavaScript, jquery, XML
Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
XML type in Oracle Form Developer 10g
hi, i am using oracle form devloper 10g, i have a xmltype column in a table(oracle database), i am not able to access value of that xmltype in oracle form developer 10g. how to acces can anyone suggest?
Answer Question
| June 7, 2011 11:48 AM
Oracle Developer, Oracle Developer 10g, Oracle Forms, Oracle Forms 10g, XML, XML development
hi, i am using oracle form devloper 10g, i have a xmltype column in a table(oracle database), i am not able to access value of that xmltype in oracle form developer 10g. how to acces can anyone suggest?
Answer Question
| June 7, 2011 11:48 AM
Oracle Developer, Oracle Developer 10g, Oracle Forms, Oracle Forms 10g, XML, XML development
CISCO UCS Manager related.
Hi, This is Manoj Wadile. I have one doubt related to UCS manager xml API. When we subsribe any event using even subscription api using java code and if we modified any properties of chassis/blades via UCS manager, currently i am not gettting response from UCS manager but when i checked .ucs log file that [...]
Answer Question
| May 2, 2011 5:43 AM
Cisco Unified Communications, Unified Communications, XML
Hi, This is Manoj Wadile. I have one doubt related to UCS manager xml API. When we subsribe any event using even subscription api using java code and if we modified any properties of chassis/blades via UCS manager, currently i am not gettting response from UCS manager but when i checked .ucs log file that [...]
Answer Question
| May 2, 2011 5:43 AM
Cisco Unified Communications, Unified Communications, XML
Save high volume xml transactions to db
I’m not a DB developer, I know basic select statements but that’s about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that’s about 400k transactional xmls per day to save. Each request xml is anywhere from 20k to 80k [...]
Answer Question
| May 2, 2011 12:43 AM
SQL Server, SQL Server 2008, XML
I’m not a DB developer, I know basic select statements but that’s about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that’s about 400k transactional xmls per day to save. Each request xml is anywhere from 20k to 80k [...]
Answer Question
| May 2, 2011 12:43 AM
SQL Server, SQL Server 2008, XML
How to convert XML data into tabular form in SQL Server 2005
Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!
Answer Question
| November 29, 2010 12:02 PM
SQL Server, SQL Server 2005, XML, XML development, XML File Creation
Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!
Answer Question
| November 29, 2010 12:02 PM
SQL Server, SQL Server 2005, XML, XML development, XML File Creation
Write Record to table as XML from RecordSet destination
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Generate .XML file in Visual Basic 6
how to generate .xml file through vb6
Answer Question
| October 19, 2010 6:46 AM
VB Code, VB6, Visual Basic 6, XML, XML File Creation
how to generate .xml file through vb6
Answer Question
| October 19, 2010 6:46 AM
VB Code, VB6, Visual Basic 6, XML, XML File Creation
In Virtual Directory In IIS
how to Hendel Error like following The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. ——————————————————————————– A name was started with an invalid character. Error processing resource ‘http://localhost/College_BIPS/Admin/Default.aspx’….
Answer Question
| November 10, 2010 12:17 PM
C# .NET, IIS, IIS Virtual Directories, Virtual directory, XML
how to Hendel Error like following The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. ——————————————————————————– A name was started with an invalid character. Error processing resource ‘http://localhost/College_BIPS/Admin/Default.aspx’….
Answer Question
| November 10, 2010 12:17 PM
C# .NET, IIS, IIS Virtual Directories, Virtual directory, XML
Serving web pages from the ILE
In ILE Cobol I can create and XML document using the built in XML generate (and XML parse) statements. How do I go from there to serve this to a browser? I would like to use a web page IDE tool that I hope can output XSL and then merge the XML and XSL to [...]
Answer Question
| September 28, 2010 1:37 PM
COBOL, HTML, V5R4, XML, XSLT
In ILE Cobol I can create and XML document using the built in XML generate (and XML parse) statements. How do I go from there to serve this to a browser? I would like to use a web page IDE tool that I hope can output XSL and then merge the XML and XSL to [...]
Answer Question
| September 28, 2010 1:37 PM
COBOL, HTML, V5R4, XML, XSLT
