4GL report
Posted in 1997
I am writing a 4GL program to print out documentation of all the tables in a database. I would like to print the following info for each table: Table Name: Type: Table ID: Owner: Dbspace Name: Created Date: ......... Columns Name Type Default ... .. ... basically all the info associated with a table. Then print out all the indexes info for this table, INDEXES Name: type: levels: Leaves: Columns idx_1 U 2 20 col1 col2 .... idx_02 .... Then constraints CONTRAINTS: Name type delete parent table index name columns TRIGGERS: Name event owner ....... I have defined RECORD for table, index,constraints, trigger and REPORT function for each of this RECORD. My problem is I can't put all these report in one file ordered by table. I am new to 4GL programming. Any help will be greatly appreciated. Thanks in advance!