DROP PROCEDURE B1_UPDATE_DATA (VARCHAR(30), VARCHAR(30))
@
DROP PROCEDURE B1_TRUNCATE_TABLE (VARCHAR(30), VARCHAR(30))
@
DROP PROCEDURE B1_REMOVE_BASE ()
@
DROP PROCEDURE B1_QRY_TYPE_IV (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_QRY_TYPE_III (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_QRY_TYPE_II (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_QRY_TYPE_IC (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_QRY_TYPE_I (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_QRY_TYPE_IB (VARCHAR(30), VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_MANAGE_RECORDER (VARCHAR(30), INTEGER, VARCHAR(60), VARCHAR(60), VARCHAR(2000), INTEGER)
@
DROP PROCEDURE B1_LOAD_TEST (VARCHAR(30), VARCHAR(30), VARCHAR(200), VARCHAR(10))
@
DROP PROCEDURE B1_GENERATE_TEST (VARCHAR(30), VARCHAR(30), INTEGER)
@
DROP PROCEDURE B1_INDEX_TEST_4B (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_4 (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_3B (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_3 (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_2B (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_2 (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_1B (VARCHAR(30))
@
DROP PROCEDURE B1_INDEX_TEST_1 (VARCHAR(30))
@
DROP PROCEDURE B1_IMPORT_TEST (VARCHAR(30), VARCHAR(30), VARCHAR(200), VARCHAR(10))
@
DROP PROCEDURE B1_EXPORT_TEST (VARCHAR(30), VARCHAR(30), VARCHAR(200), VARCHAR(10), VARCHAR(200))
@
DROP PROCEDURE B1_EXPORT_RESULTS (VARCHAR(30))
@
DROP PROCEDURE B1_DELETE_DATA (VARCHAR(30), VARCHAR(30))
@
DROP PROCEDURE B1_CONTROL_B ()
@
DROP PROCEDURE B1_CONTROL_A ()
@
DROP PROCEDURE B1_CONTROL ()
@
DROP PROCEDURE B1_BUILD_BASE (VARCHAR(60))
@
DROP PROCEDURE B1_ADD_INDEX (VARCHAR(30), VARCHAR(100), VARCHAR(100), VARCHAR(200))
@

CREATE PROCEDURE B1_MANAGE_RECORDER (IN  IN_CASE_NO         VARCHAR(30),
IN  IN_CASE_SEQUENCE   INTEGER,
  	                                 IN  IN_STORE_PROCEDURE VARCHAR(60),
	                                 IN  IN_ACTION_VALUE    VARCHAR(60),
	                                 IN  IN_SQL_STATEMENT   VARCHAR(2000),
	                                 OUT OUT_CASE_SEQUENCE  INTEGER)
-----------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_MANAGE_RECORDER';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CUR1              CURSOR FOR S1;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;-- 
	IF IN_ACTION_VALUE = 'INSERT' THEN
		SET SQL_STATEMENT = 'INSERT INTO RECORDER '||
							'(CASE_NO, STORE_PROCEDURE, ACTION_VALUE, SQL_STATEMENT, START_TS) '||
							'VALUES '||
							'('''||IN_CASE_NO||''', '''||IN_STORE_PROCEDURE||''', '''||IN_ACTION_VALUE||''', '''||IN_SQL_STATEMENT||''', CURRENT TIMESTAMP)' ;
		EXECUTE IMMEDIATE SQL_STATEMENT;
		COMMIT;
		
		SET SQL_STATEMENT = 'SELECT '||
							'MAX(CASE_SEQUENCE) '||
							'FROM '||
							'RECORDER ';
		PREPARE S1 FROM SQL_STATEMENT;
        OPEN  CUR1;
        FETCH CUR1 INTO OUT_CASE_SEQUENCE;
        CLOSE CUR1;
		COMMIT;
	ELSE
		SET SQL_STATEMENT = 'UPDATE RECORDER '||
							'SET END_TS = CURRENT TIMESTAMP '||
							'WHERE '||
							'CASE_SEQUENCE = ' || CHAR(IN_CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;	
		COMMIT;
		
	END IF;
	
END;
END P1

@

CREATE PROCEDURE B1_UPDATE_DATA (   IN IN_CASE_NO    VARCHAR(30),
IN IN_TABLE_NAME VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_UPDATE_DATA';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'UPDATE '|| IN_TABLE_NAME ||' SET I2=-999';
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	EXECUTE IMMEDIATE SQL_STATEMENT;
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END;
END P1

@

CREATE PROCEDURE B1_TRUNCATE_TABLE (IN IN_CASE_NO    VARCHAR(30),
IN IN_TABLE_NAME VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_TRUNCATE_TABLE';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'IMPORT FROM NUL OF DEL REPLACE INTO '|| IN_TABLE_NAME;
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END;
END P1

@

CREATE PROCEDURE B1_REMOVE_BASE (  )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_REMOVE_BASE';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'DROP VIEW REPORT_TOTAL_RUNTIME' ;	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_TOTAL_RUNTIME';	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_ALL';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_PERFORMANCE';		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_SQL';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_02_GENERATE'; 	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_03_EXPORT'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_04_TRUNCATE'; 	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_05_IMPORT'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_06_DELETE'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_07_LOAD'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_08_UPDATE'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_09_QRY_I'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_10_QRY_IB'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_11_QRY_IC'; 		EXECUTE IMMEDIATE SQL_STATEMENT;	
	SET SQL_STATEMENT = 'DROP VIEW REPORT_12_QRY_II'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_13_QRY_III'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP VIEW REPORT_14_QRY_IV'; 		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_ENV_INST_INFO';		EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_SYS_INFO';			EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_ENV_SYS_RESOURCES';	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_SYSTABLES';			EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_SYSTABLESPACES';	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE REC_SYSBUFFERPOOLS';	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE RECORDER';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_100K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_200K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_300K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_400K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_500K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_600K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_700K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_800K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_900K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'DROP TABLE B1_A00K';				EXECUTE IMMEDIATE SQL_STATEMENT;
	
	COMMIT;
END;
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_IV (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                  IN IN_TABLE_NAME2 VARCHAR(30),
                                  IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_IV';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT SUM (T2.I2), AVG (T2.I3), MAX (T2.I4), MIN(T2.I5) '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 = int(1000*rand()) '||
		                    'AND   T1.I1 = T2.I2 ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_III (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                  IN IN_TABLE_NAME2 VARCHAR(30),
                                  IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_III';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT * '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 = int(100*rand()) '||
		                    'AND   T1.I2 = T2.I2 ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_II (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                 IN IN_TABLE_NAME2 VARCHAR(30),
                                 IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_II';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT * '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 > int(100*rand()) AND T1.I1 < (int(1000*rand())+200) '||
		                    'AND   T1.I1 = T2.I2 ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_IC (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                 IN IN_TABLE_NAME2 VARCHAR(30),
                                 IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_IC';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT * '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 = int(1000*rand()) '||
		                    'AND   T1.I1 = BIGINT(T2.A1) ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_I (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                IN IN_TABLE_NAME2 VARCHAR(30),
                                IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_I';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT * '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 = int(1000*rand()) '||
		                    'AND   T1.I1 = T2.I2 ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_QRY_TYPE_IB (IN IN_CASE_NO     VARCHAR(30),
IN IN_TABLE_NAME1 VARCHAR(30),
                                 IN IN_TABLE_NAME2 VARCHAR(30),
                                 IN IN_NUM_BLOCK   INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_QRY_TYPE_IB';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 'SELECT * '||
		                    'FROM ' || IN_TABLE_NAME1 ||' T1, ' || IN_TABLE_NAME2 ||' T2 '||
		                    'WHERE T1.I1 = int(1000*rand()) '||
		                    'AND   T1.A1 = T2.A2 ';
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
		SET LOOP_COUNT = LOOP_COUNT + 1;
	END WHILE;
END;	
END P1

@

CREATE PROCEDURE B1_LOAD_TEST (IN IN_CASE_NO        VARCHAR(30),
IN IN_TABLE_NAME     VARCHAR(30),
                               IN IN_FILE_NAME      VARCHAR(200),
                               IN IN_TYPE           VARCHAR(10)  )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_LOAD_TEST';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'LOAD FROM '|| IN_FILE_NAME ||' OF '|| IN_TYPE || 
   	                    ' INSERT INTO '|| IN_TABLE_NAME ||' NONRECOVERABLE ';
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END;
END P1

@

CREATE PROCEDURE B1_GENERATE_TEST (IN IN_CASE_NO    VARCHAR(30),
IN IN_TABLE_NAME VARCHAR(30),
                                   IN IN_NUM_BLOCK  INTEGER     )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_GENERATE_TEST';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE OUT_CASE_SEQUENCE INTEGER       DEFAULT 0;
DECLARE LOOP_COUNT        INTEGER       DEFAULT 0;
DECLARE START_RANGE       INTEGER       DEFAULT 1;
DECLARE END_RANGE         INTEGER       DEFAULT 100001;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	WHILE ( LOOP_COUNT < IN_NUM_BLOCK ) DO 
		SET SQL_STATEMENT = 
		'INSERT INTO ' || IN_TABLE_NAME ||'                                      '||  
		'WITH temp1 (s1, r1, r2, r3, r4, r5, r6) AS                              '||
		'(VALUES ('|| CHAR(START_RANGE) ||', RAND(2), RAND(2), RAND(2), RAND(2), RAND(2), RAND(2)) '||
		' UNION ALL                                                              '||
		' SELECT s1+1, RAND(), RAND(), RAND(), RAND(), RAND(), RAND()            '||
		' FROM temp1                                                             '||
		' WHERE s1+1 < '|| CHAR(END_RANGE) ||'                                   '||
		')                                                                       '||
		'SELECT INT(s1)  AS seq                                                  '||
		',INT(r1*100)    AS ran2                                                 '||
		',INT(r2*1000)   AS ran3                                                 '||
		',INT(r3*10000)  AS ran4                                                 '||
		',INT(r4*100000) AS ran5                                                 '||
		',CHAR(INT(r1*100))    AS ran6                                           '||
		',CHAR(INT(r2*1000))   AS ran7                                           '||
		'FROM temp1                                                              ';
	
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,OUT_CASE_SEQUENCE);
		EXECUTE IMMEDIATE SQL_STATEMENT;
		CALL B1_MANAGE_RECORDER(IN_CASE_NO,OUT_CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,OUT_CASE_SEQUENCE);
		COMMIT;
	
		SET LOOP_COUNT = LOOP_COUNT + 1;
		SET START_RANGE = END_RANGE;
		SET END_RANGE = END_RANGE + 100000;
	END WHILE;
	
END;
END P1

@

CREATE PROCEDURE B1_IMPORT_TEST (IN IN_CASE_NO        VARCHAR(30),
IN IN_TABLE_NAME     VARCHAR(30),
                                 IN IN_FILE_NAME      VARCHAR(200),
                                 IN IN_TYPE           VARCHAR(10)  )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_IMPORT_TEST';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'IMPORT FROM '|| IN_FILE_NAME ||' OF '|| IN_TYPE ||' COMMITCOUNT 100000 '||
   	                    ' INSERT INTO '|| IN_TABLE_NAME;
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END;
END P1

@

CREATE PROCEDURE B1_EXPORT_TEST (IN IN_CASE_NO        VARCHAR(30),
IN IN_TABLE_NAME     VARCHAR(30),
                                 IN IN_FILE_NAME      VARCHAR(200),
                                 IN IN_TYPE           VARCHAR(10),
                                 IN IN_SELECT_DISPLAY VARCHAR(200)  )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_EXPORT_TEST';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'EXPORT TO '|| IN_FILE_NAME ||' OF '|| IN_TYPE ||
   	                    ' SELECT '|| IN_SELECT_DISPLAY ||
       	                ' FROM '  || IN_TABLE_NAME;
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END;
END P1

@

CREATE PROCEDURE B1_DELETE_DATA (   IN IN_CASE_NO    VARCHAR(30),
IN IN_TABLE_NAME VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_DELETE_DATA';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
	SET SQL_STATEMENT = 'DELETE FROM '|| IN_TABLE_NAME;
	                       
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
	EXECUTE IMMEDIATE SQL_STATEMENT;
	CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
END P1

@

CREATE PROCEDURE B1_ADD_INDEX (IN IN_CASE_NO        VARCHAR(30),
IN IN_TABLE_NAME     VARCHAR(100),
                               IN IN_INDEX_NAME     VARCHAR(100),
                               IN IN_COL_NAME       VARCHAR(200)  )
------------------------------------------------------------------------
-- SQL Stored Procedure 
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_ADD_INDEX';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE CASE_SEQUENCE     INTEGER       DEFAULT 0;
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	SET SQL_STATEMENT = 'CREATE INDEX '||IN_INDEX_NAME||' ON '||IN_TABLE_NAME||' ('|| IN_COL_NAME ||') ';
    CALL B1_MANAGE_RECORDER(IN_CASE_NO,0,SP_NAME,'INSERT',SQL_STATEMENT,CASE_SEQUENCE);
    EXECUTE IMMEDIATE SQL_STATEMENT;
    CALL B1_MANAGE_RECORDER(IN_CASE_NO,CASE_SEQUENCE,SP_NAME,'UPDATE',SQL_STATEMENT,CASE_SEQUENCE);
    
END;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_4B (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_4B';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_601A','B1_600K','B1_600K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_701A','B1_700K','B1_700K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_801A','B1_800K','B1_800K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_901A','B1_900K','B1_900K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_A01A','B1_A00K','B1_A00K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_601A','B1_600K','B1_600K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_701A','B1_700K','B1_700K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_801A','B1_800K','B1_800K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_901A','B1_900K','B1_900K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_A01A','B1_A00K','B1_A00K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101C','B1_100K','B1_100K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201C','B1_200K','B1_200K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301C','B1_300K','B1_300K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401C','B1_400K','B1_400K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501C','B1_500K','B1_500K_A1','A1');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_602','B1_600K'  ,6 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_702','B1_700K'  ,7 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_802','B1_800K'  ,8 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_902','B1_900K'  ,9 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_A02','B1_A00K' ,10);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_603','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_703','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_803','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_903','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_A03','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_604','B1_600K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_704','B1_700K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_804','B1_800K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_904','B1_900K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_A04','B1_A00K');COMMIT;
	
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_605','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_705','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_805','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_905','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_A05','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_606','B1_600K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_706','B1_700K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_806','B1_800K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_906','B1_900K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_A06','B1_A00K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_607','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_707','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_807','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_907','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_A07','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_608','B1_600K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_708','B1_700K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_808','B1_800K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_908','B1_900K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_A08','B1_A00K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_4 (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_4';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101A','B1_100K','B1_100K_i2','I1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201A','B1_200K','B1_200K_i2','I1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301A','B1_300K','B1_300K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401A','B1_400K','B1_400K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501A','B1_500K','B1_500K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101B','B1_100K','B1_100K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201B','B1_200K','B1_200K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301B','B1_300K','B1_300K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401B','B1_400K','B1_400K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501B','B1_500K','B1_500K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101C','B1_100K','B1_100K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201C','B1_200K','B1_200K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301C','B1_300K','B1_300K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401C','B1_400K','B1_400K_A1','A1');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501C','B1_500K','B1_500K_A1','A1');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_102','B1_100K' ,1);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_202','B1_200K' ,2);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_302','B1_300K' ,3);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_402','B1_400K' ,4);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_502','B1_500K' ,5);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_103','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_203','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_303','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_403','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_503','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_104','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_204','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_304','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_404','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_504','B1_500K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_105','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_205','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_305','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_405','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_505','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_106','B1_100K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_206','B1_200K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_306','B1_300K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_406','B1_400K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_506','B1_500K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_107','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_207','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_307','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_407','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_507','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_108','B1_100K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_208','B1_200K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_308','B1_300K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_408','B1_400K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_508','B1_500K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_3B (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_3B';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_601A','B1_600K','B1_600K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_701A','B1_700K','B1_700K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_801A','B1_800K','B1_800K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_901A','B1_900K','B1_900K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_A01A','B1_A00K','B1_A00K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_601A','B1_600K','B1_600K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_701A','B1_700K','B1_700K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_801A','B1_800K','B1_800K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_901A','B1_900K','B1_900K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_A01A','B1_A00K','B1_A00K_i3','I3');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_602','B1_600K'  ,6 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_702','B1_700K'  ,7 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_802','B1_800K'  ,8 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_902','B1_900K'  ,9 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_A02','B1_A00K' ,10);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_603','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_703','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_803','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_903','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_A03','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_604','B1_600K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_704','B1_700K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_804','B1_800K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_904','B1_900K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_A04','B1_A00K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_605','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_705','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_805','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_905','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_A05','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_606','B1_600K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_706','B1_700K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_806','B1_800K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_906','B1_900K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_A06','B1_A00K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_607','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_707','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_807','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_907','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_A07','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_608','B1_600K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_708','B1_700K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_808','B1_800K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_908','B1_900K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_A08','B1_A00K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_3 (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_3';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101A','B1_100K','B1_100K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201A','B1_200K','B1_200K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301A','B1_300K','B1_300K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401A','B1_400K','B1_400K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501A','B1_500K','B1_500K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101B','B1_100K','B1_100K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201B','B1_200K','B1_200K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301B','B1_300K','B1_300K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401B','B1_400K','B1_400K_i3','I3');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501B','B1_500K','B1_500K_i3','I3');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_102','B1_100K' ,1);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_202','B1_200K' ,2);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_302','B1_300K' ,3);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_402','B1_400K' ,4);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_502','B1_500K' ,5);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_103','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_203','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_303','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_403','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_503','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_104','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_204','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_304','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_404','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_504','B1_500K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_105','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_205','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_305','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_405','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_505','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_106','B1_100K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_206','B1_200K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_306','B1_300K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_406','B1_400K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_506','B1_500K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_107','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_207','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_307','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_407','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_507','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_108','B1_100K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_208','B1_200K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_308','B1_300K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_408','B1_400K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_508','B1_500K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_2B (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_2B';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_601A','B1_600K','B1_600K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_701A','B1_700K','B1_700K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_801A','B1_800K','B1_800K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_901A','B1_900K','B1_900K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_A01A','B1_A00K','B1_A00K_i2','I2');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_602','B1_600K'  ,6 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_702','B1_700K'  ,7 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_802','B1_800K'  ,8 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_902','B1_900K'  ,9 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_A02','B1_A00K' ,10);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_603','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_703','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_803','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_903','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_A03','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_604','B1_600K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_704','B1_700K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_804','B1_800K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_904','B1_900K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_A04','B1_A00K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_605','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_705','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_805','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_905','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_A05','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_606','B1_600K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_706','B1_700K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_806','B1_800K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_906','B1_900K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_A06','B1_A00K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_607','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_707','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_807','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_907','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_A07','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_608','B1_600K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_708','B1_700K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_808','B1_800K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_908','B1_900K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_A08','B1_A00K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_2 (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_2';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_101A','B1_100K','B1_100K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_201A','B1_200K','B1_200K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_301A','B1_300K','B1_300K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_401A','B1_400K','B1_400K_i2','I2');COMMIT;
	CALL B1_ADD_INDEX(IN_CASE_NO||'_501A','B1_500K','B1_500K_i2','I2');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_102','B1_100K' ,1);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_202','B1_200K' ,2);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_302','B1_300K' ,3);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_402','B1_400K' ,4);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_502','B1_500K' ,5);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_103','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_203','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_303','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_403','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_503','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_104','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_204','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_304','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_404','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_504','B1_500K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_105','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_205','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_305','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_405','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_505','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_106','B1_100K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_206','B1_200K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_306','B1_300K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_406','B1_400K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_506','B1_500K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_107','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_207','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_307','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_407','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_507','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_108','B1_100K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_208','B1_200K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_308','B1_300K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_408','B1_400K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_508','B1_500K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_1B (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_1B';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_602','B1_600K'  ,6 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_702','B1_700K'  ,7 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_802','B1_800K'  ,8 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_902','B1_900K'  ,9 );COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_A02','B1_A00K' ,10);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_603','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_703','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_803','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_903','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_A03','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_604','B1_600K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_704','B1_700K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_804','B1_800K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_904','B1_900K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_A04','B1_A00K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_605','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_705','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_805','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_905','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_A05','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_606','B1_600K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_706','B1_700K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_806','B1_800K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_906','B1_900K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_A06','B1_A00K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_607','B1_600K' ,'C:\TEMP\B1_600K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_707','B1_700K' ,'C:\TEMP\B1_700K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_807','B1_800K' ,'C:\TEMP\B1_800K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_907','B1_900K' ,'C:\TEMP\B1_900K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_A07','B1_A00K' ,'C:\TEMP\B1_A00K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_608','B1_600K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_708','B1_700K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_808','B1_800K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_908','B1_900K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_A08','B1_A00K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_INDEX_TEST_1 (IN IN_CASE_NO VARCHAR(30) )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_INDEX_TEST_1';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_004','B1_500K');COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_102','B1_100K' ,1);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_202','B1_200K' ,2);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_302','B1_300K' ,3);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_402','B1_400K' ,4);COMMIT;
	CALL B1_GENERATE_TEST(IN_CASE_NO||'_502','B1_500K' ,5);COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_103','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_203','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_303','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_403','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF','*');COMMIT;
	CALL B1_EXPORT_TEST(IN_CASE_NO||'_503','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF','*');COMMIT;
	
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_104','B1_100K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_204','B1_200K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_304','B1_300K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_404','B1_400K');COMMIT;
	CALL B1_TRUNCATE_TABLE(IN_CASE_NO||'_504','B1_500K');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_105','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_205','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_305','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_405','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_IMPORT_TEST(IN_CASE_NO||'_505','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	
	CALL B1_DELETE_DATA(IN_CASE_NO||'_106','B1_100K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_206','B1_200K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_306','B1_300K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_406','B1_400K');COMMIT;
	CALL B1_DELETE_DATA(IN_CASE_NO||'_506','B1_500K');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_107','B1_100K' ,'C:\TEMP\B1_100K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_207','B1_200K' ,'C:\TEMP\B1_200K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_307','B1_300K' ,'C:\TEMP\B1_300K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_407','B1_400K' ,'C:\TEMP\B1_400K.IXF','IXF');COMMIT;
	CALL B1_LOAD_TEST(IN_CASE_NO||'_507','B1_500K' ,'C:\TEMP\B1_500K.IXF','IXF');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_108','B1_100K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_208','B1_200K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_308','B1_300K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_408','B1_400K');COMMIT;
	CALL B1_UPDATE_DATA(IN_CASE_NO||'_508','B1_500K');COMMIT;
	COMMIT;
END P1

@

CREATE PROCEDURE B1_EXPORT_RESULTS (IN IN_PATH    VARCHAR(30))
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_EXPORT_RESULTS';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';

BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_ENV_INST_INFO.DEL OF DEL SELECT * FROM REC_ENV_INST_INFO ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_SYS_INFO.DEL OF DEL SELECT * FROM REC_SYS_INFO ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_ENV_SYS_RESOURCES.DEL OF DEL SELECT * FROM REC_ENV_SYS_RESOURCES ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_SYSTABLES.DEL OF DEL SELECT * FROM REC_SYSTABLES ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_SYSTABLESPACES.DEL OF DEL SELECT * FROM REC_SYSTABLESPACES ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'REC_SYSBUFFERPOOLS.DEL OF DEL SELECT * FROM REC_SYSBUFFERPOOLS ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

        SET SQL_STATEMENT = 'EXPORT TO '||IN_PATH||'RECORDER.DEL OF DEL SELECT * FROM RECORDER ';
        CALL SYSPROC.ADMIN_CMD(SQL_STATEMENT);
        COMMIT;

END;            

END P1

@

CREATE PROCEDURE B1_CONTROL_B (  )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_CONTROL_B';
DECLARE CASE_NO           VARCHAR(30);
	CALL B1_INDEX_TEST_1B('I1');	COMMIT;
	CALL B1_INDEX_TEST_2B('I2');	COMMIT;
	CALL B1_INDEX_TEST_3B('I3');	COMMIT;
	CALL B1_INDEX_TEST_4B('I4');	COMMIT;
		
END P1

@

CREATE PROCEDURE B1_CONTROL_A (  )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_CONTROL_A';
DECLARE CASE_NO           VARCHAR(30);
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	CALL B1_INDEX_TEST_1('I1');	COMMIT;
	CALL B1_INDEX_TEST_2('I2');	COMMIT;
	CALL B1_INDEX_TEST_3('I3');	COMMIT;
	CALL B1_INDEX_TEST_4('I4');	COMMIT;
	
	CALL B1_QRY_TYPE_I  ('I5_109','B1_100K','B1_200K',100);COMMIT;
	CALL B1_QRY_TYPE_IB ('I5_110','B1_100K','B1_200K',100);COMMIT;
	CALL B1_QRY_TYPE_IC ('I5_111','B1_100K','B1_200K',100);COMMIT;
	CALL B1_QRY_TYPE_II ('I5_112','B1_100K','B1_200K',100);COMMIT;
	CALL B1_QRY_TYPE_III('I5_113','B1_100K','B1_200K',100);COMMIT;
	CALL B1_QRY_TYPE_IV ('I5_114','B1_100K','B1_200K',100);COMMIT;
END;		
END P1

@


CREATE PROCEDURE B1_CONTROL (  )
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_CONTROL';
DECLARE CASE_NO           VARCHAR(30);
	CALL B1_CONTROL_A();	COMMIT;
	CALL B1_CONTROL_B();	COMMIT;
		
END P1

@

CREATE PROCEDURE B1_BUILD_BASE (IN_TABLESPACE_NAME VARCHAR(60))
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SP_NAME           VARCHAR(60)   DEFAULT 'B1_BUILD_BASE';
DECLARE SQL_STATEMENT     VARCHAR(2000) DEFAULT '';
DECLARE V_TABLESPACE_NAME VARCHAR(65)   DEFAULT '';
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
        BEGIN
        END;--
	IF (IN_TABLESPACE_NAME IS NULL OR IN_TABLESPACE_NAME = '') THEN
		SET V_TABLESPACE_NAME = '';
	ELSE
		SET V_TABLESPACE_NAME = ' IN '||IN_TABLESPACE_NAME;
	END IF;
	
	SET SQL_STATEMENT = 'CREATE TABLE RECORDER '||
						'(CASE_NO         VARCHAR(30)   NOT NULL, '||
    	                ' CASE_SEQUENCE    INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH +1 INCREMENT BY +1 MINVALUE +1 MAXVALUE +2147483647 NO CYCLE CACHE 100 NO ORDER ), '||
        	            ' STORE_PROCEDURE VARCHAR(60)   NOT NULL, '||
            	        ' ACTION_VALUE    VARCHAR(60)   NOT NULL, '||
                	    ' SQL_STATEMENT   VARCHAR(2000) NOT NULL, '||
                    	' START_TS        TIMESTAMP     NOT NULL, '||
	                    ' END_TS          TIMESTAMP     ) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_100K (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_100K_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_200K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_200K_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE TABLE B1_300K  (I1 BIGINT NOT NULL , '||
					    '  I2 BIGINT NOT NULL , '||
					    '  I3 BIGINT NOT NULL , '||
					    '  I4 BIGINT NOT NULL , '||
					    '  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
					    '  CONSTRAINT B1_300K_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE TABLE B1_400K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_400K_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE TABLE B1_500K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_500M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE TABLE B1_600K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_600M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_700K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_700M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_800K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_800M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_900K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_900M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE B1_A00K  (I1 BIGINT NOT NULL , '||
						'  I2 BIGINT NOT NULL , '||
						'  I3 BIGINT NOT NULL , '||
						'  I4 BIGINT NOT NULL , '||
						'  I5 BIGINT NOT NULL , '||
						'  A1 VARCHAR(10) NOT NULL , '||
						'  A2 VARCHAR(10) NOT NULL , '||
						'  CONSTRAINT B1_A00M_PK PRIMARY KEY (I1)) ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE TABLE REC_ENV_INST_INFO          AS ( SELECT * FROM SYSIBMADM.ENV_INST_INFO EII ) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_ENV_INST_INFO          SELECT * FROM SYSIBMADM.ENV_INST_INFO EII' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE REC_SYS_INFO               AS ( SELECT * FROM SYSIBMADM.ENV_SYS_INFO ESI ) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_SYS_INFO               SELECT * FROM SYSIBMADM.ENV_SYS_INFO ESI' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE REC_ENV_SYS_RESOURCES      AS ( SELECT * FROM SYSIBMADM.ENV_SYS_RESOURCES ESR ) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_ENV_SYS_RESOURCES      SELECT * FROM SYSIBMADM.ENV_SYS_RESOURCES ESR' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE REC_SYSTABLES AS (SELECT * FROM SYSIBM.SYSTABLES ST '||
	                    'WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K'')) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_SYSTABLES SELECT * FROM SYSIBM.SYSTABLES '||
	                    'WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K'')';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE REC_SYSTABLESPACES AS (SELECT * FROM SYSIBM.SYSTABLESPACES STS WHERE TBSPACE IN ( '||
						'SELECT DISTINCT TBSPACE FROM SYSIBM.SYSTABLES WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K''))) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_SYSTABLESPACES SELECT * FROM SYSIBM.SYSTABLESPACES STS WHERE TBSPACE IN ( '||
						'SELECT DISTINCT TBSPACE FROM SYSIBM.SYSTABLES WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K''))';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE TABLE REC_SYSBUFFERPOOLS AS (SELECT * FROM SYSIBM.SYSBUFFERPOOLS SBP WHERE BUFFERPOOLID IN ( '||
						'SELECT DISTINCT BUFFERPOOLID FROM SYSIBM.SYSTABLESPACES WHERE TBSPACE IN ( '||
						'SELECT DISTINCT TBSPACE FROM SYSIBM.SYSTABLES WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K'')))) DEFINITION ONLY ' || V_TABLESPACE_NAME ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	SET SQL_STATEMENT = 'INSERT INTO  REC_SYSBUFFERPOOLS SELECT * FROM SYSIBM.SYSBUFFERPOOLS SBP WHERE BUFFERPOOLID IN ( '||
						'SELECT DISTINCT BUFFERPOOLID FROM SYSIBM.SYSTABLESPACES WHERE TBSPACE IN ( '||
						'SELECT DISTINCT TBSPACE FROM SYSIBM.SYSTABLES WHERE NAME IN (''B1_100K'',''B1_200K'',''B1_300K'',''B1_400K'',''B1_500K'')))';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_PERFORMANCE (CASE_NO, MIN_TS, MAX_TS, TS_DIFF) AS '||
						'SELECT CASE_NO, MIN_TS, MAX_TS, TIMESTAMPDIFF(2,CHAR((MAX_TS-MIN_TS))) TS_DIFF  '||
						'FROM '||
						'(SELECT CASE_NO, MIN(START_TS) MIN_TS, MAX(END_TS) MAX_TS '||
	 					'FROM RECORDER '||
	 					'GROUP BY CASE_NO ) A ';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_SQL (CASE_NO, SQL_STATEMENT) AS '||
						'SELECT CASE_NO, SQL_STATEMENT '||
						'FROM RECORDER ';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_TOTAL_RUNTIME (CASE_NO, TS_DIFF) AS '||
						'SELECT ''TOTAL'' CASE_NO, TIMESTAMPDIFF(2,CHAR((MAX_TS-MIN_TS))) TS_DIFF '||
						'FROM (SELECT MIN(START_TS) MIN_TS, MAX(END_TS) MAX_TS FROM RECORDER ) RTR ';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_02_GENERATE (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%02'' ';
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_03_EXPORT (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%03'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_04_TRUNCATE (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%04'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_05_IMPORT (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%05'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_06_DELETE (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%06'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_07_LOAD (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%07'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_08_UPDATE (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%08'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_09_QRY_I (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%09'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_09_QRY_IB(CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%10'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_09_QRY_IC(CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%11'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_10_QRY_II (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%12'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_11_QRY_III (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%13'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_12_QRY_IV (CASE_NO, TS_DIFF) AS '||
						'SELECT CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%14'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
	SET SQL_STATEMENT = 'CREATE VIEW REPORT_ALL (TYPE, CASE_NO, TS_DIFF) AS '||
						'SELECT ''TOTAL'' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_TOTAL_RUNTIME '||
						'UNION 	'||
						'SELECT ''02-GENERATE'' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%02'' '||
						'UNION '||
						'SELECT ''03-EXPORT  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%03'' '||
						'UNION '||
						'SELECT ''04-TRUNCATE'' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%04'' '||
						'UNION '||
						'SELECT ''05-IMPORT  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%05'' '||
						'UNION '||
						'SELECT ''06-DELETE  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%06'' '||
						'UNION '||
						'SELECT ''07-LOAD    '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%07'' '||
						'UNION '||
						'SELECT ''08-UPDATE  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%08'' '||
						'UNION '||
						'SELECT ''09-QRY_I   '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%09'' '||
						'UNION '||
						'SELECT ''09-QRY_IB  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%10'' '||
						'UNION '||
						'SELECT ''09-QRY_IC  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%11'' '||
						'UNION '||
						'SELECT ''10-QRY_II  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%12'' '||
						'UNION '||
						'SELECT ''11-QRY_III '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%13'' '||
						'UNION '||
						'SELECT ''12-QRY_IV  '' TYPE, CASE_NO, TS_DIFF '||
						'FROM REPORT_PERFORMANCE '||
						'WHERE CASE_NO LIKE ''I%14'' ' ;
	EXECUTE IMMEDIATE SQL_STATEMENT;
	COMMIT;
END;
		
END P1

@