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

SQL REPLACE with pointer
I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field… My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of the string to be replaced, which is done using the [...]

Answer Question   |  March 31, 2012  11:32 AM
AS/400 SQL, RPG ILE, SQL, SQL Server, XML File Creation

How I can automated process load xml file to SQL server 2008?
Hello!

Answer Question   |  March 3, 2011  8:28 PM
Automation, SQL Server, SQL Server 2008, XML File Creation

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

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

XML Publisher Report
I made Matrix report in XML Publisher in that there are two parameter for Date (From Date & To Date)when i run report for one day it is working fine when i run for a month it givs worning i.e Beginning post-processing of request 76437793 on node TAJORN3 at 30-SEP-2010 12:02:15. Post-processing of request 76437793 [...]

Answer Question   |  October 1, 2010  10:16 AM
Parameters, XML development, XML File Creation, XML Publisher

Identifying special characters when creating XML output
Hi Everyone, I’m in the process of creating xml files (using RPGLE) to send order details to our clients. One requirement is the need to replace (encode) special characters such as < > ‘”& No problem there, my scan can identify and replace where necessary. The problem arises with characters not native to IBM such [...]

Answer Question   |  September 23, 2010  11:30 AM
iSeries, RPGLE Program, XML, XML development, XML File Creation

XML Schema Problem
hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID> </UserRoleConsumer> … …. … </UserRoleConsumers> while creating a schema for this CREATE XML SCHEMA COLLECTION UserRoleConsumerSchema AS ‘ <schema xmlns=”http://www.w3.org/2001/XMLSchema”> <element name=”UserRoleConsumers”> <complexType> <element name=”UserRoleConsumer”> <complexType> <sequence> <element name=”ConsumerID” minOccurs=”1″ maxOccurs=”1″ /> <element name=”RoleConsumerID” minOccurs=”1″ maxOccurs=”1″ /> </sequence> </complexType> </element> </complexType> [...]

Answer Question   |  September 3, 2010  10:37 AM
SQL, SQL Server, SQL Server 2008, XML and XML schema, XML File Creation

I need to send an XML file every 5 min to another site.
I need to send an XML file every 5 min to another site. Someone suggested “ASYNC” what would that mean?

Answer Question   |  July 16, 2010  9:12 PM
Asynchronous Transfer Mode, iSeries, XML development, XML File Creation

Find and replace text in text file using MS Access VBA
Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text. Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim [...]

Answer Question   |  May 8, 2013  11:46 PM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation

XML file create from as/400
Dear Friends, i have some data in PF and i want to that data in XML format how can i do that please tell about step by step becasue i am new in XML thanks

Answer Question   |  June 30, 2010  12:11 PM
AS/400, AS/400 data transfer, XML File Creation