Previous Topic: The READTBL and WRITETBL OPS/REXX ProgramsNext Topic: Storing Data in and Requesting Data From Relational Tables


The OPCRTBDF Subroutine

The OPS/REXX subroutine, OPCRTBDF, is provided for user programs that may want to copy or save the definition of an existing table in the format of an SQL CREATE TABLE statement. OPCRTBDF analyzes the structure and defaults of an existing table and returns a return code and an SQL CREATE TABLE statement with the original table name or a new table name. The CREATE TABLE statement may be executed or saved as required. The keyword syntax for this program is contained in the comment section at the beginning of the program.