Using the Catalog Synchronization Utility › Specifying Control Statements for CADB2SY2 › Specifying Synchronization Control Statements › Syntax

Syntax

Begin each control statement anywhere in columns 1 through 72. You can use columns 73 through 80 for sequence numbers because these columns are ignored. Specify at least one blank between keywords. Specify comments between /* and */ anywhere in columns 2 through 71. Do not continue control statements to a second line, instead, begin again with the control statement on the next line to specify additional user or resource information in a batch.

Here is the format of the SYNC, VIEW, INCLUDE|EXCLUDE, and GO statements:

SYNC SYSTEM(subsystemid) [OPTIONS([REVOKEALL] [,TRACE] [,NOPRIVCHECK])
VIEW ACTION([WARN][,DROP][,REVOKEADMIN])]
INCLUDE|EXCLUDE { USER(logonidmask                          }
                { UID(uidmask                               }
                { IF(logonidfield)                          }
                { BPL(bufferpool|bufferpoolmask             }
                { COL(collection|collectionmask             }
                { DBS(database|databasemask                 }
                { FNC(function|functionmask)                }
                { JAR(jarfile|jarfilemask)                  }
                { PKG(package|packagemask)                  }
                { PLN(plan|planmask)                        }
                { PRC(procedure|proceduremask)              }
                { SCH(schema|schemamask)                    }
                { SEQ(sequence|sequencemask)                }
                { STG(storagegroup|storagegroupmask)        }
                { SYS(systemprivilege|systemprivilegemask)  }
                { TBL(table|tablemask)                      }
                { TSP(tablespace|tablespacemask)            }
                { TYP(distincttype|distinctypemask)         }
[GO]