Export (0) Print
Expand All

SQL Replication with DB2 UDB for AIX

When used with DB2 Universal Database for AIX, run the following commands:

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