//-----------------DTC_Source-------------------//

GRANT CONNECT TO [DTC_Source] IDENTIFIED BY 'j-interop'
GO
GRANT DBA TO [DTC_Source]
GO
GRANT RESOURCE TO [DTC_Source]
GO
GRANT MEMBERSHIP IN GROUP [dbo] TO [DTC_Source]
GO

//-----------------DTC_Target-------------------//

GRANT CONNECT TO [DTC_Target] IDENTIFIED BY 'j-interop'
GO
GRANT DBA TO [DTC_Target]
GO
GRANT RESOURCE TO [DTC_Target]
GO
GRANT MEMBERSHIP IN GROUP [dbo] TO [DTC_Target]
GO

/*------------DTC_Source (Pattern 1.a)------------*/

CREATE TABLE DTC_Source.P1A_S01_03_bit_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_13_int_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_14_integer_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_19_smallint_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_26_tinyint_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_32_unsigned_int_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S01_33_unsigned_integer_to_bigint  ( 
    clm_1	bigint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S02_03_bit_to_binary  ( 
    clm_1	binary(1) NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S02_26_tinyint_to_binary  ( 
    clm_1	binary(1) NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Source.P1A_S04_06_char_to_clob  ( 
    clm_1	CLOB NULL 
    )
IN iq_main
GO

/*------------DTC_Target (Pattern 1.a)------------*/

CREATE TABLE DTC_Target.P1A_S01_03_bit_to_bigint  ( 
    clm_1	bit NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_13_int_to_bigint  ( 
    clm_1	integer NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_14_integer_to_bigint  ( 
    clm_1	integer NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_19_smallint_to_bigint  ( 
    clm_1	smallint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_26_tinyint_to_bigint  ( 
    clm_1	tinyint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_32_unsigned_int_to_bigint  ( 
    clm_1	UNSIGNED int NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S01_33_unsigned_integer_to_bigint  ( 
    clm_1	UNSIGNED int NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S02_03_bit_to_binary  ( 
    clm_1	bit NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S02_26_tinyint_to_binary  ( 
    clm_1	tinyint NULL 
    )
IN iq_main
GO
CREATE TABLE DTC_Target.P1A_S04_06_char_to_clob  ( 
    clm_1	char(25) NULL 
    )
IN iq_main
GO