DSXchange

Thanks guys wil try and let you know which one worked

From the above sample taking a record for example XML retrieve response record: <acct acct_gn_cd="0" acct_rcncl_nm_cd="3" acct_resp_ind="0" acct_resp_strt_dt="2013-04-10" acct_no="0000000" gnrc_set_nm_cd="2" man_acct_grp_ind="1" m...

Ok. below is the XML and XSD XML <retrieveResponse xmlns="****" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://***"> <xml> <acct acct_gn_cd="0" acct_rcncl_nm_cd="3" acct_resp_ind="0" acct_resp_strt_dt="...

Eostic sorry for the late reply, was away from work.

I am trying to see whether datastage can add the metadata information available in xsd to the flat file. when converting the web service response xml to flat file using any XMl/WebServices Stage

Below is the XML file -> trying to add the metadata when transforming it to a seq file <retrieveResponse xmlns="***" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="**"> <xml> <acct gn_cd="0"/> <!--Row Count: 2; Exec Time: 0.039s; Fet...

Sorry that was a general example and it not relates with XSD provided above

Thanks for the quick reply Below is the sample of our XSD - <xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" targetNamespace="***" xml:lang="EN" xmlns:xs="http://www.w3.org/2001/XMLSchema"> - <!-- 2013-04-18t17:12:15.457 e...

Hi all, Trying to transform a XML file -> sequential file using XML Input stage. I am able to transform the files successfully But my requirement is when i do the transformation of xml to seq file i need to replace the data elements code with the MetaData information using xsd Example : XML contains...