RE: Help!

["Nilesh Jokhakar" <njokhakar@xxxxxxxxxxxx>]

Hi Scott,
 
  That's not the case. My VB.net web service returns real symbols such as < , > (I added breakpoint at the return statement in VB program) but when I check the value of field in RPG program , it shows &lt or &gt instead of < or >.
 
RPG gets following information
                                                         
          ....5...10...15...20...25...30...35...40...45...50...55...60  
     1   '<?xml version="1.0" encoding="utf-8"?><string xmlns="http:' 
    61   '//12345678.com/yyyyyyyyyyyyy/zz">!&lt;NewDataSet&gt;  &lt;' 
   121   'Table&gt;    &lt;Field11111&gt;2005-10-16 00:00:00&lt;/Fie' 
   181   'ld11111&gt;    &lt;Field2222222&gt;007.00&lt;/Field2222222' 
   241   '&gt;    &lt;Field333&gt;0&lt;/Field333&gt;    &lt;Field4' 
   301   '44&gt;000.75&lt;/Field444&gt;    &lt;Field5555555555&gt;007' 
   361   '5.00&lt;/Field5555555555&gt;   
 
VB.Net Returns following
 
  <?xml version="1.0" standalone="yes" ?> 
- <NewDataSet>
- <Table>
  <Field11111>2005-10-16 00:00:00</Field11111> 
  <Field2222222>007.00</Field2222222> 
  <Field333>0</Field333> 
  <Field444>000.75</Field444> 
  <Field5555555555>0075.00</Field5555555555> 
   </Table>
 
Please let me know if you need any further information.
 
Thanks,
Nilesh Jokhakar
 

	-----Original Message----- 
	From: Scott Klement [mailto:sk@xxxxxxxxxxxxxxxx] 
	Sent: Mon 10/17/2005 7:31 PM 
	To: ftpapi@xxxxxxxxxxxxx 
	Cc: 
	Subject: Re: Help!
	
	

	Sender: Scott Klement <sk@xxxxxxxxxxxxxxxx>
	
	
	I don't know why your .NET program would output &lt; and &gt; instead of
	actual less-than and greater-than signs.  It sounds like it's trying to
	escape the XML so that it can be placed in (smirk) another XML document,
	or maybe an HTML document.
	
	I imagine that any software would choke on that, since it won't know that
	there are tags in the data!
	
	I don't know of a way to map data from an XML document to a physical file
	without buying tools (such as DB2 UDB Extenders for XML from IBM) that are
	designed to do that.  There are a lot of tools available to convert XML to
	a physical file, but I don't know of any free or open source ones.
	
	HTTPAPI does have XML parsing capability built-in (see EXAMPLE16) but you
	do have to do some programming to map it to a field in your program.
	
	If you want to learn more about parsing XML from RPG, you might be
	interested in the following page, and the articles that it links to:
	http://www.scottklement.com/expat/
	
	On Mon, 17 Oct 2005, Nilesh Jokhakar wrote:
	
	> Hello,
	>
	>
	>
	>    I am using http socket APIs to call web service written in VB.net
	> from RPG program. The web service executes stored procedure on SQL
	> server and returns dataset object consist of multiple tables. These
	> multiple tables contain multiples rows and columns.
	>
	>
	>
	>
	>
	> I am getting output back as a string (I convert dataset into string by
	> doing string field = dataset.Getxml() in .net program)  from VB.net web
	> service. I want to know if there is any way I can parse XML document
	> into database without doing manual work. When I get output in RPG
	> program, I get all '<' symbol converted into &lt and ">" symbol into
	> &gt.
	>
	>
	>
	> Thanks in advance,
	>
	>
	>
	> Nilesh Jokhakar
	>
	>
	>
	>
	-----------------------------------------------------------------------
	This is the FTPAPI mailing list.  To unsubsribe from the list send mail
	to majordomo@xxxxxxxxxxxxx with the body: unsubscribe ftpapi mymailaddr
	-----------------------------------------------------------------------

<<winmail.dat>>