xml file Name

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gius
Participant
Posts: 29
Joined: Mon Mar 09, 2015 2:10 am

xml file Name

Post by Gius »

Hello, I have a job that use the XML here down ( with a XML input )
I would like to fetch the value for => Field Name="entRecno"
But when I inport the XML or XSD I can not see this field,
do you now what can I do for this ?
thank You -

Code: Select all

  <?xml version="1.0" ?> 
- <MDSBroadcast>
- <BroadcastHeader>
  <locale>English (United States)</locale> 
  <timeZone>CDT</timeZone> 
  </BroadcastHeader>
- <MDSEvent>
- <EventHeader>
  <entType>per</entType> 
  <evtType>MEMBER UPDATED</evtType> 
  <triggerEvtType>MEMBER UPDATED</triggerEvtType> 
  <triggerEvtId>U</triggerEvtId> 
  <evtCreateDateTime>2014/09/24 16:38:23</evtCreateDateTime> 
  <triggerId>2:PO426397</triggerId> 
  <triggerMemRecno>26522616</triggerMemRecno> 
  <triggerAudRecno>26580123</triggerAudRecno> 
  <triggerUserName>mdmadmin</triggerUserName> 
  <msgCheckSum>3045376419886454121</msgCheckSum> 
  </EventHeader>
- <MDSObject Type="Member">
- <ObjHeader>
  <Field Name="memType">Policy</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="entRecno">13321076</Field> 
  <Field Name="memStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
  <ObjData /> 
  </MDSObject>
- <MDSObject Type="View">
+ <ObjHeader>
  <Field Name="viewName">PEMCA</Field> 
  <Field Name="viewKind">E</Field> 
  <Field Name="memType">Policy</Field> 
  </ObjHeader>
- <ObjData>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERADDR</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">3</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="stLine1">121A TOPSHAM ROAD</Field> 
  <Field Name="stLine2">EXETER</Field> 
  <Field Name="stLine3" /> 
  <Field Name="stLine4" /> 
  <Field Name="city">EXETER</Field> 
  <Field Name="state" /> 
  <Field Name="zipCode">EA1 2PO</Field> 
  <Field Name="country">UK</Field> 
  <Field Name="geoText1" /> 
  <Field Name="geoCode1" /> 
  <Field Name="geoCode2" /> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERNAME</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">8</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="onmLast">POPE</Field> 
  <Field Name="onmFirst">JOHN</Field> 
  <Field Name="onmMiddle" /> 
  <Field Name="onmPrefix" /> 
  <Field Name="onmSuffix" /> 
  <Field Name="onmDegree" /> 
  <Field Name="onmTitle" /> 
  </ObjData>
  </MDSObject>
  </ObjData>
  </MDSObject>
  </MDSEvent>
- <MDSEvent>
- <EventHeader>
  <entType>per</entType> 
  <evtType>ENTITY UPDATED</evtType> 
  <triggerEvtType>MEMBER UPDATED</triggerEvtType> 
  <triggerEvtId>U</triggerEvtId> 
  <evtCreateDateTime>2014/09/24 16:38:23</evtCreateDateTime> 
  <triggerId>2:PO426397</triggerId> 
  <triggerMemRecno>26522616</triggerMemRecno> 
  <triggerAudRecno>26580123</triggerAudRecno> 
  <triggerUserName>mdmadmin</triggerUserName> 
  <msgCheckSum>1166946334105160712</msgCheckSum> 
  </EventHeader>
- <MDSObject Type="Entity">
- <ObjHeader>
  <Field Name="entRecno">13321076</Field> 
  <Field Name="entType">per</Field> 
  <Field Name="memCount">1</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="member">2:PO426397</Field> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="View">
- <ObjHeader>
  <Field Name="viewName">PEMCA</Field> 
  <Field Name="viewKind">E</Field> 
  <Field Name="memType">Policy</Field> 
  </ObjHeader>
- <ObjData>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERADDR</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">3</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="stLine1">121A TOPSHAM ROAD</Field> 
  <Field Name="stLine2">EXETER</Field> 
  <Field Name="stLine3" /> 
  <Field Name="stLine4" /> 
  <Field Name="city">EXETER</Field> 
  <Field Name="state" /> 
  <Field Name="zipCode">EA1 2PO</Field> 
  <Field Name="country">UK</Field> 
  <Field Name="geoText1" /> 
  <Field Name="geoCode1" /> 
  <Field Name="geoCode2" /> 
  </ObjData>
  </MDSObject>
- <MDSObject Type="Attribute">
- <ObjHeader>
  <Field Name="attrCode">PERNAME</Field> 
  <Field Name="memberId">2:PO426397</Field> 
  <Field Name="memRecno">26522616</Field> 
  <Field Name="memSeqno">8</Field> 
  <Field Name="asaIdxno">0</Field> 
  <Field Name="recStat">A</Field> 
  <Field Name="mdsCTime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="mdsMTime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  <Field Name="srcCtime">Wed Sep 24 16:35:49 CDT 2014</Field> 
  <Field Name="srcMtime">Wed Sep 24 16:38:17 CDT 2014</Field> 
  </ObjHeader>
- <ObjData>
  <Field Name="onmLast">POPE</Field> 
  <Field Name="onmFirst">JOHN</Field> 
  <Field Name="onmMiddle" /> 
  <Field Name="onmPrefix" /> 
  <Field Name="onmSuffix" /> 
  <Field Name="onmDegree" /> 
  <Field Name="onmTitle" /> 
  </ObjData>
  </MDSObject>
  </ObjData>
  </MDSObject>
  </MDSEvent>
  </MDSBroadcast>
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

This is because entRecno isn't metadata...it is a "value". Unfortunately, this xml document isn't really using the tags in a way that would be most useful. We see this often when xml is required, but the time needed to fully model the data items wasn't available.

The metadata is an attribute called "Name"....within a repeating Element called "Field".

Described correctly in xmlInput, you will get "n" rows (one for each "Field") element, and they can/will have (at least) two columns:

Name
Field

Scan the rows later in a constraint to find all of your entRecno "rows", or else perform a pivot and turn those repeating "Field" rows into columns.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
AshishDevassy
Participant
Posts: 32
Joined: Fri Nov 07, 2014 11:18 am

Post by AshishDevassy »

yea , The XML is not using the tags the way its supposed to.
If you are in UNIX or windows i would suggest just write a shell script to extract the records with entRecno. (from the look of things it looks like they are going to be on the same line)..
And use the output from that as an input.
Just a thought
that's wierd ?
Post Reply