offsets of the various fields/Tables and other tables and I believe a DSECT would provide that information

Article Id: 108611
Status: Published
Updated On: 31-07-2018 07:07
Products:
CA Datacom , CA CIS , CA Common Services for z/OS , CA 90s Services , CA Database Management Solutions for DB2 for z/OS , CA Common Product Services Component , CA Common Services , CA Datacom/AD , CA ecoMeter Server Component FOC , CA Easytrieve Report Generator for Common Services , CA Infocai Maintenance , CA IPC , Unicenter CA-JCLCheck Common Component , CA Mainframe VM Product Manager , CA Chorus Software Manager , CA On Demand Portal , CA Service Desk Manager - Unified Self Service , CA PAM Client for Linux for zSeries , CA Mainframe Connector for Linux on System z , CA Graphical Management Interface , CA Web Administrator for Top Secret , CA CA- Xpertware
Issue/Introduction:



However I would like to know more about the offsets of the various fields in that Table PERSON  and other tables and I believe a DSECT would provide that information. Perhaps you know of another way to get this type of information. ?

Environment:

Release:
Component: DB

Resolution:

You may find something close to what you are asking for by using DDUTILTY: 
https://docops.ca.com/ca-datacom/15-1/en/using/ca-datacom-datadictionary-batch-facilities/ddutilty-producing-reports-and-source-language-statements/ddutilty-sample-job-streams-and-output 

For example, for our Table PERSON: 
//SYSIN DD * 
+USR DATACOM-INSTALL,NEWUSER 
-UTL LIBRARY,OS 
-UTL LANGUAGE,COBOL,DESCRIPTION 
-UTL COPY,TABLE,PERSON(PROD),PER-TBL 
-END 

However the above does not give the offsets. But gives a full copybook layout. 
Replace DESCRIPTION by NONE to get a easier output to read, 

But using DR instead of COBOL will give the offsets. 
Offset starting at 301, see docops for further information. 
Several language are supported. 

Additional Information:

Language ALC will give you the assembler equivalent. 
More like the DSECT you were asking.