![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Developer’s workbench Type tablespec <Enter> Type PT tablespec <Enter>
• If you supply a value for tablespec, the table is sent to the printer.
• If you do not supply a value for tablespec, the Table Print screen appears when TABLEPRINT is executed. An example of this screen is illustrated here:
• The print arguments are set at the top of the screen. The defaults are Page Length 60, Page Width 132 (which is the only supported width for a printed page), and PRT. The normal values for SCR are Page Length 25 and Page Width 80.
• To print a table, enter its name in the TABLE field and press PF3.
• To print two or more tables successively, enter the name of one table and press PF13. The table is printed and the screen appears again. Another table name can be entered, the print arguments can be changed, and the process can be repeated.
• A parameter value must be supplied for a parameterized table. For example: TABLE: EMPLOYEE_DEPT(10).
• Such a table can be included in a join where the selection is based on its parameter values. In this case, the parameter is specified in the form t.f on the JOIN TABLE field.
• Each value of the field f is used, so that several instances of the table can be printed immediately.
•
• When several tables are joined for printing, both matching of fields and matching of parameters can be used in the same join.
• The statement: EX TABLEPRINT('EMPLOYEE') prints the contents of the table EMPLOYEE.
• The statement: EX TABLEPRINT() displays the TABLEPRINT screen.The following example demonstrates the use of joins when printing tables. The table DEPARTMENT contains the department number in a field called DEPTNO. The table EMPLOYEE contains the department number for each employee in a field also called DEPTNO.To join these tables for printing, type the name of one table, and then press PF6 to be able to enter the name of the second table and the fields to compare, in a screen like this:
TABLEPRINT automatically fills in the first table in the WITH (T.F) field.Fill in the information about the table you want to join (for example, the EMPLOYEE table), as shown in this screen:
• At least one of the two fields that are being compared must be a primary key. In this example, DEPTNO is the primary key of departments.
• The table named in the field WITH(T.F) must already be named in the TABLE field or it must be named in a JOIN TABLE field above the one that names the table currently being added to the join.
• The table EMPLOYEE_DEPT, parameterized by DEPTNO, contains a listing of all the employees.
• A list of all the department numbers is contained in the DEPARTMENT table in the field DEPTNO.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |