Can RDF Tables be rebuilt despite losing the SQL CREATE statements for them?

Products

• OPS/MVS Event Management & Automation

Issue/Introduction

How to rebuild some RDF tables, having lost the original SQL CREATE statements for them?
 

Environment

 OPS/MVS 

Resolution

Insert a NEW table, and use the OLD table as the model table in order to reference the structure of the table.  Panel =2.6 

If there is a MSF connection, the same thing can be done:
Put the MSFID in front of the table name to be used for the MODEL: MSFID>modeltablename

-----------------------------------------------------------------------------------------------------------------------------------------------------

With the above,  the table structure editor can be used to see the definition of the table for future reference.
The easiest way to recreate the tables would be to run the sample REXX program WRITETBL on the system it is on, then run READTBL on the other system.
It will automatically generate the READTBL table and populate it with the data from the WRITETBL.
Or, create a copy of WRITETBL and modify it to only generate the table itself with no data.
Or, do that in a copy of READTBL.