Ansicht
Dokumentation

RADIN001 - Ad hoc program for SQL scripts from incremental table conversion

PERFORM Short Reference Addresses (Business Address Services)
This documentation is copyright by SAP AG.

Purpose

Utility Program for IMIG for Creating Special SQL Scripts

When the IMIG is edited, deletion SQL scripts and scripts for counting table records in IMIG tables are created for consultants in the source and target systems (for temporary target tables).

This utility program can be used to call the corresponding function modules for creating the scripts directly, without running an IMIG process state check. Any existing scripts are overwritten.

Integration

Prerequisites

Features

The following SQL scripts can be created:

- Temporary DROP scripts (ending with #)

- Drop scripts (as modified copies of the corresponding temporary files) as created by RADCLMIG

- Count scripts (select count (*)) for IMIG tables in the source system

- Count scripts (select count (*)) for temporary IMIG target tables in the target system,,

The database schema of the source and target systems can also be displayed.

Selection

Standard Variants

Output

SQL files in the installation directory on the source server (for example in 'instdir_src')

Activities

Example

Example of a drop script (in directory.../instdir_src/)

DRPBASIS.SQL,,,,Standard drop file for a DB2 database

DROP DATABASE A000X990; COMMIT WORK;
DROP DATABASE A040X99Q; COMMIT WORK;
DROP DATABASE A040X99R; COMMIT WORK;
DROP DATABASE A040X99S; COMMIT WORK;
DROP DATABASE A040X99T; COMMIT WORK;
.......
.......
DROP DATABASE SY00X78D; COMMIT WORK;
DROP DATABASE U000X999; COMMIT WORK;
DROP TABLESPACE A070X999 . RSSTATMA; COMMIT WORK;
DROP TABLESPACE A070X999 . SLLSXTMS; COMMIT WORK;
DROP TABLESPACE A070XAAA . RSSTATMA; COMMIT WORK;
DROP TABLESPACE A170X998 . CRMDXMKT; COMMIT WORK;
DROP TABLESPACE A170X999 . CRMDXMKT; COMMIT WORK;
DROP TABLESPACE A170X999 . CRMDXTMX; COMMIT WORK;
DROP TABLESPACE A170X999 . ECTDXTEX; COMMIT WORK;
DROP TABLESPACE A170X999 . RSECXOMI; COMMIT WORK;
DROP TABLESPACE A170XAAA . CRMDXMKT; COMMIT WORK;
DROP TABLESPACE A170XAAA . CRMDXTMX; COMMIT WORK;

DRPBAS56.SQL,,,,Drop for QCM5/QCM6 files

DROP TABLE "QCM6ZHJ_TA" ; commit work ;
DROP TABLE "QCM6ZHJ_TB" ; commit work ;
DROP TABLE "QCM6ZHJ_TC" ; commit work ;
DROP TABLE "QCM6ZHJ_TD" ; commit work ;
DROP TABLE "QCM6ZHJ_TE" ; commit work ;
DROP TABLE "QCM6ZHJ_TF" ; commit work
DROP TABLE "QCM6ZHJ_TL" ; commit work ;
DROP TABLE "QCM6ZHJ_TM" ; commit work ;
DROP TABLE "QCM6ZHJ_TN" ; commit work ;
DROP TABLE "QCM6ZHJ_TO" ; commit work ;

Example of count scripts (in directory.../instdir_src/)

TBLCOUNT_TRG.SQL ,,Full scripts
TBLCOUNT_SRC.SQL

TBLCOU_1_TRG.SQL Commands are split into five parts
TBLCOU_1_SRC.SQL
TBLCOU_2_TRG.SQL
TBLCOU_2_SRC.SQL
TBLCOU_3_TRG.SQL
TBLCOU_3_SRC.SQL
TBLCOU_4_TRG.SQL
TBLCOU_4_SRC.SQL
TBLCOU_5_TRG.SQL
TBLCOU_5_SRC.SQL

TBLCOU_1_SRC.SQL:

-- SELECT COUNT (*) FROM "IMIG table 01" ;
-- SELECT COUNT (*) FROM "IMIG table 02" ;
.............