Copy schema procedure

The procedure ADMIN_COPY_SCHEMA can be used to copy a schema and its contents. The same object names will be used and placed into the target schema specification. The new tables can be created with or without data from the source. The syntax for the copy schema procedure is:

SYSPROC.ADMIN_COPY_SCHEMA
([SourceSchema], [TargetSchema], [CopyMode], [ObjectOwner],
[SourceTBSP], [TargetTBSP], [ErrorTableSchema], [ErrorTable])
CALL SYSPROC.ADMIN_COPY_SCHEMA ('ERP', 'TEST', 'COPY', NULL, '', ' ','ERROR', 'ERP_ERROR_INFO');