Export (0) Print
Expand All

SQL Replication with DB2 for MVS

When used with DB2 for MVS, run the following commands:

exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'bit', 
    'SMALLINT', 1,  0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'char', 'CHAR', 254, 4, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'datetime', 
    'TIMESTAMP', 26, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'decimal', 
    'DECIMAL', 31, 3, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'double precision',
    'DOUBLE', 53, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'float', 'FLOAT', 53, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'int', 
    'INT', 10, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'money', 
    'DECIMAL', 19, 3, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'numeric', 
    'NUMERIC', 31, 3, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'real', 'REAL', 24, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'smalldatetime',
    'TIMESTAMP', 26, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'smallint', 
    'SMALLINT', 5, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'smallmoney', 
   'DECIMAL', 10, 3, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'text', 
   'VARCHAR', 4045, 4, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'tinyint', 
    'SMALLINT', 1, 0, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'uniqueidentifier',
    'CHAR', 38, 4, 1
exec dbo.sp_add_datatype_mapping 'DB2/MVS', 'varchar', 
    'VARCHAR', 4045, 4, 1
Show:
© 2014 Microsoft