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

book

Article ID: 108611

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server 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.