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 <res09...@verizon.net> 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<ron5...@gmail.com> 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
