Relational Data Framework Reference › OPS/REXX Programs › WRITETBL Program—Create Backup RDF Table

WRITETBL Program—Create Backup RDF Table

The WRITETBL OPS/REXX program creates a sequential data set that contains a backup copy of an RDF table. WRITETBL retrieves the definition of the table and row data from SQL. The READTBL OPS/REXX program can then reconstruct the table from this backup data set using SQL on any system where the CA OPS/MVS product runs.

To invoke the WRITETBL program, issue the following command:

OI WRITETBL

{TABLE(tablename)}
[BLKSIZE(9040,blocksize)]
[CMDRESP(TERMINAL|XDQ)]
[DISP(SHR|MOD)]
[DROPCOL('columnames')]
[DSNAME(datasetname)]
[SPACE('pri,sec')]
[SUBSYS(subsystem)]
[UNIT(unitname)]
[VOLSER(volume)]

Specify these keywords when invoking the WRITETBL program:

TABLE

Defines the name of the table to be written to a backup data set. Invoking the WRITETBL program against a table does not change that table.

BLKSIZE

(Optional) Sets the z/OS block size for the backup data set. The value that you specify must be a multiple of 80. The default value is 9,040.

CMDRESP

(Optional) Possible values:

TERMINAL

Causes messages to be issued to the terminal or default destination.

XDQ

Causes messages to be placed in the REXX external data queue.

Default: TERMINAL

DISP

(Optional) Defines the initial status of the backup data set if the data set already exists. If more than one RDF table is being backed up to the same data set, DISP(MOD) must be specified for all but the first table.

Default: SHR

DROPCOL

(Optional) Defines the names of any columns to be dropped from the backup copy of the table (but not from the original table). If you want to drop more than one column, enclose the list of column names in quotation marks and separate them with at least one blank.

Note: The backup data set does not contain the column definition or the row data for dropped columns.

DSNAME

(Optional) Defines the name of the backup data set. To specify the full data set name, enclose the name within a pair of single quotes as shown in the following example. If you omit the quotes, the user ID becomes the high-level node.

DSNAME('OPS.BACKUP.STCTBL')

Note: The backup data set must have the attributes DSORG=PS, RECFM=FB, LRECL=80.

Note: If you specify no data set name, CA OPS/MVS uses the default name userid.subsys.WRITETBL.

SPACE

(Optional) Sets the primary and secondary z/OS space allocation for the backup data set, in blocks.

Default: '50,50'

SUBSYS

(Optional) Defines the subsystem name of CA OPS/MVS that contains the table to be backed up.

UNIT

(Optional) Provides the z/OS unit name for allocating the backup data set.

Default: SYSDA

VOLSER

(Optional) Defines a volume serial number for the backup data set. There is no default volume.