Data exception error while reading DCOLLECT output

GOWTHAM · New User Joined: 01 Apr 2009 Posts: 4 Location: usa

I posting this after doing lot of search on our forum...:-)
I'm trying to use the DCOLLECT output that I received from my SMS team & convert that in to a report format. Unfortunatly we do not SAS with us, so I'm trying to get my reporting done by using Eazytrive ,or, DFSORT.

My final report should have "Data-set-name", "Space-Allocated" & "Space-Utilized" for all migrated as well as Active data sets (i,e, records type DCURCTYP = D or M) that are present on the DCOLLECT output.

when I run my report program..I'm getting DATA exception errors. here is the declaration that I used
DCDDSNAM -> Data set name, starts at 25th position, Alpha numeric.
DCDALLSP -> Space allocated,start at 89th position, Packed decimal (i.e. COMP-3 in cobol equivalent)
DCDUSESP -> Space utilized, starts at 93rd position, Packed decimal (i.e. COMP-3 in cobol equivalent).

Is there any otherway that I can read DCOLLECT Output & extract the above 3 fields quickly? Any valid& useful reply is highly appreciated...
Thanks in advance !!

dick scherrer · Posted: Tue Sep 22, 2009 2:44 am

Hello and welcome to the forum,

Using HEX ON post some info from these data positions from the input you are using.

If your data is variable, remember to add 4 to the starting position. . .

Frank Yaeger · Posted: Tue Sep 22, 2009 3:28 am

GOWTHAM,

The DCOLLECT symbols and DCOLLECT examples at the following links might help:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000081#sym

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000081#ex

expat · Posted: Tue Sep 22, 2009 11:18 am

When I use SAS I define those data fields as binary rather than PD. There is no sign included in the fields.

GOWTHAM · New User Joined: 01 Apr 2009 Posts: 4 Location: usa

Thanks Frank... your Fields mapping document helped.. I was able to pull my report by converting the DCOLLECT output from VB to FB file in DFSORT...
OPTION COPY,VLSHRT
OUTFIL FNAMES=FBFILE,OUTREC=(1:5,1020),CONVERT

Then pulled the fields that I required by using....
for Active DASD files...
-------------------------
SORT FIELDS=COPY
INCLUDE COND=(5,1,CH,EQ,C'D')
OUTREC FIELDS=(1:25,44,47:89,4,FI,66:93,4,FI)

And for Migrated files...
---------------------------
SORT FIELDS=COPY
INCLUDE COND=(5,1,CH,EQ,C'M')
OUTREC FIELDS=(1:25,44,47:189,4,FI,66:193,4,FI)

Thanks !!!