Another tool is Dataquery. This works against the Datadictionary. If you have this you can get a table layout view.
In DDOL, a DCB line command will build a COBOL copybook for a table or as previously stated, the batch DDUTILTY program can produce copybooks in COBOL, PL/I, ASM or EASYTRIEVE for a table. I have some REXX code that extracts the information from a CXX report and builds all the copybooks using DDUTILTY in batch... On Wed, Mar 25, 2015 at 8:33 PM, Wayne Bickerdike <[email protected]> wrote: > Ron, > > For an overview you can run a CXX report from the DBUTLTY utility. > > A TYPE=A report will give you all databases and all areas. > > A CXX report (REPORT AREA=CXX) will give everything. > > The report is based on the physical layout of tables/areas/keys/elements. > > For each table it will list the record/row length and for each key and > element the offsets and lengths. > > This can be very important in understanding the physical versus dictionary > view of things. Multiple versions of a dictionary view can exist and any > version may be catalogued including test (Tnnn) or PROD. Just make sure > your CXX report matches the dictionary version you are working from. > > Email me offline if you need more advice. > > > > > > On Wed, Mar 25, 2015 at 5:11 AM, Russell Witt <[email protected]> > wrote: > >> Ron, >> >> >> There are other utilizes outside of the online environment that would >> provide you the same information requested. There is the Batch Utility >> DDUTILTY that reports exclusively on the Dictionary. You are able to get >> all sorts of reporting via this Utility. You will be able to find further >> documentation as to the reports in this Bookshelf: >> >> >> https://supportcontent.ca.com/cadocs/0/CA%20Datacom%2014%200%20Public-ENU/Bookshelf.html >> >> There?s also a large number of users that constantly monitor the CA >> Communities and are always willing to share information: >> >> >> https://communities.ca.com/places?filterID=all~tag%5Bglobal%5D&sortKey=all~subjectAsc&sortOrder=1 >> >> Russell Witt >> CA Technologies >> >> On 03/23/15, Ron Thomas<[email protected]> wrote: >> >> Hello. I am new to datacom & in my new project the database used is >> datacom. Could some one please let me know how to get the table layout of a >> datacom table so that i can see what type each field is , and also the >> bytes it occupies? >> >> >> >> Thanks >> >> Ron T >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to [email protected] with the message: INFO IBM-MAIN >> > > > > -- > Wayne V. Bickerdike > > -- Wayne V. Bickerdike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
