• I want to load XML to a table in SQL Server 2005

    i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

    Mitha10 pointsBadges:
  • 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 as text into my sql table.  My...

    Rscheinberg595 pointsBadges:
  • Exporting stored procedure results into an XML file in SQL Server

    I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • naming column returned from FOR XML EXPLICIT query in SQL Server 2005

    Is there a way to name the column returned from a query that includes a for xml explicit? I get a column named XML_F52E2B61-18A1-11d1-B105-00805F49916B. I'd like to name it something more appropriate for ORM software The code I currently have is: Declare @RoleIDs table (RoleID int) insert into...

    Cramhead15 pointsBadges:
  • shredding xml in sql server 2005

    In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row>...

    Skidancer5 pointsBadges:
  • Loading an XML file’s dataset into an existing SQL Server 2005 table

    I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?

    SQL Server Ask the Experts2,585 pointsBadges:
  • GMT timestamp

    I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries?  Thank you.

    DStaats25 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • Receiving an XML file to RPG

    Hi, I need to receive XML files (of fixed format) to my RPGLE program (not free format RPG) and do some calculations. Can I do this without purchasing any tools (free tools can be used)? Please let me know if anyone has done something similar. Regards, Kiron

    Kiron5 pointsBadges:
  • XML to Physical file

    We will be receiving a file in XML format. Is there a way that I can convert file to a physical file on the 400.

    Dman465 pointsBadges:
  • Import XML files and run RPG ILE

    I do not have the XML toolkit package on my i5 525. We are running V5R4. Is there still a way for me to import XML files and run in RPG ILE? I have a customer that wants to send us orders via email and XML is one of the formats they could provide for us.

    Fraser5 pointsBadges:
  • RPG program: XML command error

    I received an XML-document via mail, I detached it and placed it into the IFS. Then I wrote an RPG-program where I used the XML-INTO command to read the XML-document. But, when I run my program I always get the error "The XML parser detected error code 302" I think there's something wrong with the...

    Guygeb45 pointsBadges:
  • Style error while opening

    I have a program (RPGLE, iSeries) which creates XML Excel. This program is running fine on almost 20 LPARS but on one LPAR, we are getting style error while opening Excel. When saw the XML code in notepad generated by program in color(XML code), # is replace by Ä. It should be (ss:Color="#0000FF")...

    Rajeev singh Chandel5 pointsBadges:
  • Career change for my life

    Hello to all and to all a hello. I am looking for everyone's opinions and knowledge. So please fill free to feed me your opinions and knowledge. First off I have a degree as a network Engineer and a degree in MIS. I of coarse have my MCSE and MY CNA Net + and etc. I have been involved in networking...

    Dgriggs0 pointsBadges:
  • 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...

    Vgnadeau15 pointsBadges:
  • 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...

    harith170 pointsBadges:
  • 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...

    ak47disco5 pointsBadges:
  • Problems with Expat in RPGLE

    Posted on behalf of MelissaG: I have an RPGLE program that receives an XML character string generated using CGIDEV2, and it is supposed to parse this XML in order to print those values in a spool file. My problem is that the RPGLE program that parses the XML sends an error message like 'Parse error...

    Margaret Rouse1,775 pointsBadges:
  • API Calls to UPS Connectship from iSeries

    Hi i have to integrate ups connectship with iseries WMS app. what i am reading is it requires XML calls to APIs from iseries, how can this be done from iseries? regards krishna

    ceva1125 pointsBadges:
  • 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...

    Sinha205 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following