Page 1 of 1

Can DFSORT pick out the SMF data with different offset?

PostPosted: Tue Dec 04, 2007 9:01 am
by j2422tw
Hi:

I need help to pick out SMF data with different offset within header section.

In SMF type 72, subtype 3, I want to get the value of R723CSRV ( 8 byte floating, 24 offset
in Service/Report Class Period Data Section).

The position of 'Service/Report Class Period Data Section' is depend on the value content in
SMF header section.

For example, the SMF type 72,:

6----+----7
           
0000B040000
00014200100
-----------
    Y     
0000E040000
10018200100
-----------
           
0000B040000
00014200100


In the first record, the 61 to 64 byte, the value is x'000001B4' (436), so the R723CSRV is in
offset 436 + 24 = 460. Then I can take the 8 byte and count the value.


The second record, the 61 to 64 byte, the value is x'000001E8' (488), so the R723CSRV is in
offset 488 + 24 = 512.

Then, the third record, the 61 to 64 byte, the value is x'000001B4' (436), so the R723CSRV is in
offset 436 + 24 = 460.

Can DFSORT help me to pick out the data?

TIA.

Re: Can DFSORT pick out the SMF data with different offset?

PostPosted: Wed Dec 05, 2007 12:22 am
by Frank Yaeger
You show two different values for bytes 61-64. If practical for the number of unique values in 61-64, you can set up an IFTHEN clause for each unique value. Here's a simple example with a DFSORT INREC statement. Of course, you have to get the starting positions right for the VB file (including the RDW).

   OPTION COPY
   INREC IFTHEN=(WHEN=(61,4,BI,EQ,+436),
      BUILD=(460,8)),
    IFTHEN=(WHEN=(61,4,BI,EQ,+488),
      BUILD=(512,8))

Re: Can DFSORT pick out the SMF data with different offset?

PostPosted: Wed Dec 05, 2007 7:21 am
by j2422tw
Frank, thanks for your reply.

It can get the result by using IFTHEN clause.

Thanks again.
Jerry