mysql "Server=164.99.152.215;Database=mysql;User Id=sudha;Password=novell" N Y Y Y 3 numericTable 15 serialNo TINYINT UNSIGNED primary key unsigned_tinyInt TINYINT UNSIGNED signed_tinyInt TINYINT bit BIT bool BOOL unsigned_smallint SMALLINT UNSIGNED signed_smallint SMALLINT unsigned_mediumint MEDIUMINT UNSIGNED signed_mediumint MEDIUMINT unsigned_int INT UNSIGNED signed_int INT unsigned_integer INTEGER UNSIGNED signed_integer INTEGER unsigned_bigint BIGINT UNSIGNED signed_bigint BIGINT realNoTable 11 serialNo TINYINT UNSIGNED primary key unsigned_float FLOAT(24) UNSIGNED signed_float FLOAT(24) unsigned_double_float FLOAT(25) UNSIGNED signed_double_float FLOAT(53) unsigned_double DOUBLE UNSIGNED signed_double DOUBLE unsigned_double_precision DOUBLE PRECISION UNSIGNED signed_real REAL unsigned_decimal DECIMAL(6,3) UNSIGNED signed_numeric NUMERIC(5,3) dateTable 6 serialNo TINYINT UNSIGNED primary key dateField DATE datetimeField DATETIME timestampField TIMESTAMP timeField TIME yearField YEAR 3 numericTable 4 15 1 0 -128 -128 -128 0 -32768 0 -8388608 0 -2147483648 0 -2147483648 0 -9223372036854775808 2 100 50 100 100 3000 -300 500000 -100000 4000000 500000 4000000 500000 5000000000 -5000000000 3 255 127 127 127 65535 32767 16777215 8388607 4294967295 2147483647 4294967295 2147483647 18446744073709551615 9223372036854775807 4 null null null null null null null null null null null null null null realNoTable 6 11 1 0 0 0 0 0 0 0 0 0 0 2 1.175494351E-38 -3.402823466E+38 1.175494351E-38 -1.797693134862315E+308 1.175494351E-38 -1.797693134862315E+308 1.175494351E-38 -1.797693134862315E+308 99.999 -23.456 3 3.402823466E+38 -1.175494351E-38 3.402823466E+38 -2.2250738585072014E-308 3.402823466E+38 -2.2250738585072014E-308 3.402823466E+38 -2.2250738585072014E-308 778.123 -99.999 4 1.2345E+20 1.175494351E-38 1.2345E+20 2.2250738585072014E-308 1.2345E+20 2.2250738585072014E-308 1.2345E+20 2.2250738585072014E-308 308.90 12.345 5 3.452E-19 3.402823466E+38 4.32E-15 1.797693134862315E+308 4.32E-15 1.797693134862315E+308 4.32E-15 1.797693134862315E+308 999.999 999.999 6 null null null null null null null null null null dateTable 9 6 1 '1000-01-01' '1000-01-01 00:00:00' '1970-01-02 00:00:00' '-23:59:59' 2004 2 '1999-12-17' '1999-12-17 08:00:00' '2000-01-01 04:40:00' '-23:45:56' 1999 3 '9999-12-31' '9999-12-31 23:59:59' '2037-12-31 23:59:59' '23:59:59' 2155 4 '1999@12@31' '1999@12@31 11+30+45' '1999@12@31 11+30+45' '12:23:34' 1901 5 '9999.11.18' '9999.11.18 11*45*50' '2037.11.18 11*45*50' '23:34:34' 2069 6 '9999/11/09' '9999/11/09 12:23:34' '2037/11/09 12:23:34' '09:08:07' 1970 7 19980404 19980404083050 19980404083050 083045 0000 8 '0000-00-00' '0000-00-00 00:00:00' 00000000000000 '00:00:00' 00 9 null null null null null mssql Server=164.99.155.85;Database=mono-test;User ID=sa;Password=novell; N Y Y Y 5 numericTable 6 sNo tinyint primary key bigInteger bigint integer int smallInteger smallint tinyInt tinyint bit bit dateTimeTable 3 sNo tinyInt primary key date datetime smalldate smalldatetime realNosTable 5 sNo tinyInt primary key decimalCol decimal(8,4) numericCol numeric(6,4) floatCol float realCol real moneyTable 3 sNo tinyInt primary key money money smallmoney smallmoney charTable 5 sNo tinyInt primary key characterCol char(20) ncharacterCol nchar(20) varchar varchar(20) nvarchar nvarchar(20) 5 numericTable 4 6 1 -9223372036854775808 -2147483648 -32768 0 0 2 1244 -50 234 128 0 3 9223372036854775807 2147483647 32767 255 1 4 null null null null null dateTimeTable 3 3 1 '1/1/1753 03:04:05.234' '1/1/1970 12:24' 2 '12/31/9999 00:00:00' '6/6/2079 00:00' 3 null null realNosTable 6 5 1 -9.99E+3 -99 -1.7976931348623157E+308 -3.402823466E+38 2 -1.23E3 -12 -2.2250738585072014E-308 -3.4E-38 3 0 0 0 0 4 1.2E1 12 2.2250738585072014E-308 4.56E-3 5 9.999E3 99 1.7976931348623157E+308 3.4E+38 6 null null null null moneyTable 4 3 1 -922337203685477.5808 -214748.3648 2 5477.5808 748.3648 3 922337203685477.5807 214748.3647 4 null null charTable 2 5 1 '12345678901234567890' 'abcdefghijklmnopqrst' 'zyxwvutsrqponmlkjihg' '12345678901234567890' 2 null null null null 1 generic Select_{{TABLE}}_proc postgres Server=164.99.168.144;Database=test;User Id=sudha;Password= N Y Y Y 5 numericTable 4 serialNo smallint primary key small_int smallint int integer bigInteger bigint realNoTable 5 serialNo smallint primary key numeric_column numeric(10,6) numeric_noscale decimal(10) realNo real doubleNo double precision charTable 4 serialNo smallint primary key charColumn char(20) varcharColumn varchar(20) textColumn text dateTimeTable 5 serialNo smallint primary key timestampCol timestamp intervalCol interval dateCol date timeCol time booleanTable 2 serialNo smallint primary key bool boolean 5 numericTable 4 4 1 -32768 -2147483648 -9223372036854775808 2 123 -648 0 3 32767 2147483647 9223372036854775807 4 null null null realNoTable 6 5 1 -9999.999999 -9999999999 -9.99999E-38 -9.999999999999999E-308 2 -123.99 -1239 9.99999E-38 9.999999999999999E-308 3 0 0 0 0 4 123.99 123 -9.99999E37 -1.79769313486231E308 5 9999.999999 9999999999 9.99999E37 1.79769313486231E308 6 null null null null charTable 2 4 1 'abcdefghijklmnopqrst' '1234567890' 'This is a fixed length text' 2 null null null datetimeTable 4 5 1 '0001-01-01 00:00:00.000000' '-178000000 years +4 days' '0001-01-01' '12:23:34' 2 '2004-10-21 11:15:23' '7890 years 5 days 07:30' '2004-01-12' '00:00:00' 3 '9999-12-31 23:59:59.9999' '178000000 years 00:19:23' '9999-12-31' '23:59:59' 4 null null null null booleanTable 3 2 1 TRUE 2 FALSE 3 null oracle Data Source=testdb.com;User Id=user9i;Password=oracle9i Y Y Y Y 4 numericTable 3 serialNo number(1) primary key intCol number(6) decimalCol number(6, 3) charTable 5 serialNo number(1) primary key charCol char(10) ncharCol nchar(10) varcharCol varchar2(10) nvarcharCol nvarchar2(10) RealNoTable 2 serialNo number(1) primary key floatCol float(24) DateTimeTable 5 serialNo number(1) primary key dateCol date timestampCol timestamp Int_year interval year to month int_day interval day to second 4 numericTable 4 3 1 -999999 -999.999 2 1000 234 3 999999 999.999 4 null null charTable 2 5 1 '0123456789' 'abcdefghij' '0123456789' 'abcdefghij' 2 null null null null RealNoTable 6 2 1 9.9999999E125 2 -9.999999E-126 3 1.23E-15 4 -9.999999E-126 5 9.9999999E125 6 null DateTimeTable 3 5 1 to_date('0001-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'0001-01-01 00:00:00' '-99-11' '-99 23:59:59' 2 to_date('2004-11-23 12:34:45', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'2004-11-23 12:34:45' '34-5' '-34 20:50:00' 3 to_date('9999-12-31 23:59:59', 'yyyy-mm-dd hh24:mi:ss') TIMESTAMP'9999-12-31 23:59:59' '99-11' '00 23:59:59' 1 generic {{TABLE}}_pkg.Select_{{TABLE}}_data