RE: XML Shredding / parsing – SQLServerCentral

SSC Guru

Points: 182882

September 16, 2014 at 10:14 pm

Here is a quick exsample of node shredding based on your XML sample, if the structure of the XML is not changing then this could be the right direction.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = N'<EssRoot>

<T.6.03.0>

<eventTS>2014-09-10T23:51:53.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59981481481482" posTS="2014-09-10T23:51:48.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>loadAtTerminal</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="sortId" value="100" />

<datum name="destSortId" value="1" />

<datum name="msgType" value="loadAtTerminal" />

<datum name="planId" value="TE00098" />

<datum name="destId" value="P12345" />

<data id="48611F45E900000000000000D046">

<datum name="type" value="loadAtTerminal" />

<datum name="trailerId" value="TR-1234" />

<data id="48611F45E900000000000000D049">

<datum name="type" value="evansDedicatedCommodityList" />

<data id="48611F45E900000000000000D051">

<datum name="commodityName" value="87 Octane Gasoline" />

<datum name="bolNo" value="BOL1" />

<datum name="grossGallons" value="1000" />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="netGallons" value="900" />

<datum name="orderedGallons" value="1000" />

</data>

<data id="48611F45F800000000000000D052">

<datum name="commodityName" value="Regular Grade Gasoline" />

<datum name="bolNo" value="BOL2" />

<datum name="grossGallons" value="2000" />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="netGallons" value="800" />

<datum name="orderedGallons" value="2000" />

</data>

<data id="48611F45F800000000000000D053">

<datum name="commodityName" value="Premium Grade Gasoline" />

<datum name="bolNo" value="BOL3" />

<datum name="grossGallons" value="3000" />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="netGallons" value="700" />

<datum name="orderedGallons" value="3000" />

</data>

<data id="48611F45F800000000000000D054">

<datum name="commodityName" value="Regular Grade Gasoline" />

<datum name="bolNo" value="BOL4" />

<datum name="grossGallons" value="4000" />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="netGallons" value="600" />

<datum name="orderedGallons" value="4000" />

</data>

<data id="48611F45F800000000000000D055">

<datum name="commodityName" value="87 Octane Gasoline" />

<datum name="bolNo" value="BOL5" />

<datum name="grossGallons" value="5000" />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="netGallons" value="500" />

<datum name="orderedGallons" value="5000" />

</data>

<data id="48611F461800000000000000D056">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-10T23:53:57.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59986111111111" posTS="2014-09-10T23:53:52.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>unloadAtCustomer</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="sortId" value="200" />

<datum name="destSortId" value="1" />

<datum name="msgType" value="unloadAtCustomer" />

<datum name="planId" value="TE00098" />

<datum name="destId" value="P12345" />

<data id="4861212C6C00000000000000D084">

<datum name="beginInv" value="1000" />

<datum name="type" value="unloadAtCustomer" />

<datum name="reconcilliationComplete" value="true" />

<datum name="endInv" value="899" />

<data id="4861212C6C00000000000000D087">

<datum name="type" value="evansDedicatedCommodityList" />

<data id="4861212C6C00000000000000D089">

<datum name="open2" value="2000 " />

<datum name="close1" value="4000 " />

<datum name="water2" value="5000 " />

<datum name="type" value="evansDedicatedCommodityItem" />

<datum name="commodityName" value="87 Octane Gasoline" />

<datum name="water1" value="5000 " />

<datum name="grossGallons" value="2000" />

<datum name="open1" value="1000 " />

<datum name="netGallons" value="2000 " />

<datum name="open3" value="3000 " />

<datum name="orderedGallons" value="2000" />

<datum name="close2" value="4000 " />

<datum name="water3" value="5000 " />

<datum name="close3" value="4000 " />

</data>

<data id="4861212C8B00000000000000D090">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:09:39.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59981481481482" posTS="2014-09-11T00:09:34.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>startDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="startDelay" />

<data id="48612F89CA00000000000000D100">

<datum name="delayReason" value="Early" />

<datum name="type" value="delayTaskType" />

</data>

<data id="48612F89DA00000000000000D101">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:09:48.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59981481481482" posTS="2014-09-11T00:09:43.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>loadingDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="loadingDelay" />

<data id="48612FABC900000000000000D109">

<datum name="delayReason" value="Closed" />

<datum name="type" value="delayTaskType" />

</data>

<data id="48612FABD900000000000000D110">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:09:57.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59981481481482" posTS="2014-09-11T00:09:52.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>unloadingDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="unloadingDelay" />

<data id="48612FD08700000000000000D118">

<datum name="delayReason" value="Customer Not Ready" />

<datum name="type" value="delayTaskType" />

</data>

<data id="48612FD09700000000000000D119">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:10:06.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.768240740740744" lon="-78.59986111111111" posTS="2014-09-11T00:10:01.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>otherDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="otherDelay" />

<data id="48612FF69D00000000000000D127">

<datum name="delayReason" value="Missed Appointment" />

<datum name="type" value="delayTaskType" />

</data>

<data id="48612FF6AD00000000000000D128">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:10:17.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59986111111111" posTS="2014-09-11T00:10:12.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>otherDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="otherDelay" />

<data id="4861301FEF00000000000000D136">

<datum name="delayReason" value="Other" />

<datum name="type" value="delayTaskType" />

</data>

<data id="4861301FFF00000000000000D137">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:10:30.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.768240740740744" lon="-78.59981481481482" posTS="2014-09-11T00:10:25.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>endDelay</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="endDelay" />

<data id="48613051FC00000000000000D145">

<datum name="delayReason" value="Early" />

<datum name="type" value="delayTaskType" />

</data>

<data id="486130522B00000000000000D146">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:10:38.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.768240740740744" lon="-78.59981481481482" posTS="2014-09-11T00:10:33.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>startEndEvent</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="startEndEvent" />

<data id="48613073EB00000000000000D148">

<datum name="mins" value="" />

<datum name="cityState" value="" />

<datum name="reason" value="" />

<datum name="gallons" value="" />

<datum name="type" value="startEndEventTaskType" />

<datum name="hrs" value="" />

<datum name="startEndEventReason" value="Start PRE Trip" />

</data>

<data id="48613073EB00000000000000D149">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:11:13.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.768240740740744" lon="-78.59981481481482" posTS="2014-09-11T00:11:08.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>startEndEvent</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="startEndEvent" />

<data id="486130FBE800000000000000D151">

<datum name="mins" value="" />

<datum name="cityState" value="Cleveland OH" />

<datum name="reason" value="" />

<datum name="gallons" value="1000 " />

<datum name="type" value="startEndEventTaskType" />

<datum name="hrs" value="" />

<datum name="startEndEventReason" value="End Fuel" />

</data>

<data id="486130FBF800000000000000D152">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

<T.6.03.0>

<eventTS>2014-09-11T00:11:34.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.768240740740744" lon="-78.59981481481482" posTS="2014-09-11T00:11:29.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>startEndEvent</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="destTZOffset" value="-04:00" />

<datum name="msgType" value="startEndEvent" />

<data id="4861314CC700000000000000D154">

<datum name="mins" value="15 " />

<datum name="cityState" value="" />

<datum name="reason" value="Test" />

<datum name="gallons" value="" />

<datum name="type" value="startEndEventTaskType" />

<datum name="hrs" value="8 " />

<datum name="startEndEventReason" value="Wait Time" />

</data>

<data id="4861314CD700000000000000D155">

<datum name="ignition" value="true" />

<datum name="lifeToDateDistanceDisplayValue" value="0000000.0 MI" />

<datum name="ptoFuel" value="0" />

<datum name="type" value="vehicleServiceInfo" />

<datum name="isMoving" value="false" />

<datum name="currentDriver" value="" />

<datum name="returnAirSensor" value="00000000000000" />

<datum name="lifeToDateDistance" value="0000000.0" />

<datum name="inMotionUIEnabled" value="true" />

<datum name="odometer" value="0000000.0" />

<datum name="totalFuel" value="0" />

<datum name="parkedIdleFuel" value="0" />

<datum name="trailerID" value="" />

</data>

</T.6.03.0>

</EssRoot>';

SELECT

DENSE_RANK() OVER

(

ORDER BY T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME')

) AS EVENT_RID

,T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME') AS eventTS

,EQUIPMENT.DATA.value('@unitAddress' ,'BIGINT') AS EQPM_unitAddress

,EQUIPMENT.DATA.value('@equipType' ,'VARCHAR(25)') AS EQPM_equipType

,EQUIPMENT.DATA.value('@alias' ,'VARCHAR(25)') AS EQPM_alias

,EQUIPMENT.DATA.value('@ID' ,'VARCHAR(25)') AS EQPM_ID

,POSITION.DATA.value('@lat' ,'FLOAT') AS POS_lat

,POSITION.DATA.value('@lon' ,'FLOAT') AS POS_lon

,POSITION.DATA.value('@posTS' ,'DATETIME') AS POS_posTS

,T_6_03_0.DATA.value('posType[1]' ,'INT') AS posType

,T_6_03_0.DATA.value('ignitionStatus[1]' ,'INT') AS ignitionStatus

,T_6_03_0.DATA.value('tripStatus[1]' ,'CHAR(1)') AS tripStatus

,T_6_03_0.DATA.value('ltdDistance[1]' ,'FLOAT') AS ltdDistance

,T_6_03_0.DATA.value('speed[1]' ,'FLOAT') AS speed

,T_6_03_0.DATA.value('heading[1]' ,'FLOAT') AS heading

,T_6_03_0.DATA.value('workflowEventType[1]' ,'VARCHAR(25)') AS workflowEventType

FROM @TXML.nodes('EssRoot/T.6.03.0') AS T_6_03_0(DATA)

OUTER APPLY T_6_03_0.DATA.nodes('equipment') AS EQUIPMENT(DATA)

OUTER APPLY T_6_03_0.DATA.nodes('position') AS POSITION(DATA);

SELECT

DENSE_RANK() OVER

(

ORDER BY T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME')

) AS EVENT_RID

,ROW_NUMBER() OVER

(

PARTITION BY T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME')

ORDER BY (SELECT NULL)

) AS T001_RID

,T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME') AS eventTS

,T001.DATA.value('@id','NVARCHAR(24)')

,T002.DATA.value('@name','NVARCHAR(24)')

,T002.DATA.value('@value','NVARCHAR(24)')

FROM @TXML.nodes('EssRoot/T.6.03.0') AS T_6_03_0(DATA)

OUTER APPLY T_6_03_0.DATA.nodes('data') AS T001(DATA)

OUTER APPLY T001.DATA.nodes('datum') AS T002(DATA);

SELECT

DENSE_RANK() OVER

(

ORDER BY T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME')

) AS EVENT_RID

,ROW_NUMBER() OVER

(

PARTITION BY T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME')

ORDER BY (SELECT NULL)

) AS T001_RID

,T_6_03_0.DATA.value('eventTS[1]' ,'DATETIME') AS eventTS

,T001.DATA.value('@id','NVARCHAR(24)')

,D002.DATA.value('@id','NVARCHAR(34)')

FROM @TXML.nodes('EssRoot/T.6.03.0') AS T_6_03_0(DATA)

OUTER APPLY T_6_03_0.DATA.nodes('data') AS T001(DATA)

OUTER APPLY T001.DATA.nodes('data') AS D002(DATA);