SQL Replication with DB2 UDB for AIX
Collapse the table of content
Expand the table of content

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:
© 2016 Microsoft