decimal type data input error (-1226)

Hello, The table has a column defined as decimal (7,1) . When I look up the table, there is a record in which the value -21474840 was entered. How is this possible? If I create a new table in the same instance and insert -21474840 , I get an error -1226. Any advice would be appreciated. Thanks. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------ #Informix

Hmmm, that's an interesting problem. This value looks like a serial or interger value that has wrapped. I don't see how it could happen. Are there perhaps in-place alters on the table? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------

Hi Mike, Thanks for the comment. There were no in-place alters. (oncheck -pT) ... Version Count 0 (current) 191286 Maybe it's because the Informix version is 11.10.FC3W2? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Your number of -21474840 looks very similar to -2^31 or -2147483648. I think that this is how Informix represents a NULL value internally for a 32 bit integer, for example. In the case of a decimal type I expect something similar. So this value you see is related to a NULL I believe, although something is messed up obviously. ------------------------------ Gary McNair ------------------------------

So you're saying you can select the row, and dbaccess can display it (as -21474840 , which might just be what dbaccess makes of what's stored there)? Could you dump the page containing the row using 'oncheck -pp <db>:<table> <rowid>' and attach here, together with a table schema? (Get the rowid by adding rowid to your query's projection clause.) One way of getting 'impossible' values into the database might be ODBC bulk inserts which, as far as I remember, bypass some of the data validation checks. ------------------------------ Andreas Legner ------------------------------

@Andreas Yes, I can see the value -21474840. Below are the oncheck -pp and dbschema information. $ dbaccess dbname - > select rowid, power from stat_cm_qos_raw_800_202111291700 where power < -100;rowid power 730895 -21474840 730896 -21474840 730897 -21474840 730898 -21474840 730899 -21474840 730900 -21474840 730901 -21474840 730902 -21474840 8 row(s) retrieved. > select * from stat_cm_qos_raw_800_202111291700 where rowid = 730895;gendatetime 202111291700 socode 800 tpo_cd N01008 cmtsname WB573011 cmtsid 172.23.0.80 cellno 5 slot 2/0/1 port B cm_mac 0002.0031.AE4B cm_ip 10.92.119.245 ds_id DS2 mod QAM256 frequency 530 power -21474840 snr 44.7 power_result **** snr_result **** sysuptime 46 days, 17 hours, 10 minutes, 44 seconds. $ dbschema -d dbname -t stat_cm_qos_raw_800_202111291700DBSCHEMA Schema Utility INFORMIX-SQL Version 11.10.FC3W2 create table "hfc".stat_cm_qos_raw_800_202111291700 ( gendatetime char(12), socode char(3), tpo_cd char(6), cmtsname char(8), cmtsid varchar(15), cellno varchar(50), slot varchar(8), port varchar(4), cm_mac char(14), cm_ip char(14), ds_id char(4), mod varchar(10), frequency integer, power decimal(7,1), snr decimal(7,1), power_result varchar(10), snr_result varchar(10), sysuptime varchar(64) ); :informix>/informix]oncheck -p dbname:stat_cm_qos_raw_800_202111291700 730895 addr stamp chksum nslots flag type frptr frcnt next prev 38:1591020 -1708595576 3a72 24 801 DATA 3792 204 0 0 slot ptr len flg 1 24 157 0 2 181 157 0 3 338 157 0 4 495 157 0 5 652 157 0 6 809 157 0 7 966 157 0 8 1123 157 0 9 1280 157 0 10 1437 157 0 11 1594 157 0 12 1751 157 0 13 1908 157 0 14 2065 157 0 15 2222 157 0 16 2379 157 0 17 2536 157 0 18 2693 157 0 19 2850 157 0 20 3007 157 0 21 3164 157 0 22 3321 157 0 23 3478 157 0 24 3635 157 0 slot 1: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 33 34 5 32 2f 30 2.23.0.80.34.2/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 41 /4.B0002.0031.AA 64: 45 46 31 30 2e 39 32 2e 31 31 32 2e 31 33 32 20 EF10.92.112.132 80: 44 53 31 20 6 51 41 4d 32 35 36 0 0 2 62 3e DS1 .QAM256...b> 96: 61 46 0 0 c1 2a 14 0 0 4 be e7 c8 a3 4 be aF..A*....>gH#.> 112: e7 c8 a3 29 39 30 20 64 61 79 73 2c 20 31 34 20 gH#)90 days, 14 128: 68 6f 75 72 73 2c 20 34 39 20 6d 69 6e 75 74 65 hours, 49 minute 144: 73 2c 20 37 20 73 65 63 6f 6e 64 73 2e s, 7 seconds.... slot 2: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 31 39 5 31 2f 30 2.23.0.80.19.1/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 /4.B0002.0031.AC 64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20 9F10.92.118.59 80: 44 53 32 20 6 51 41 4d 32 35 36 0 0 2 12 3f DS2 .QAM256....? 96: 28 0 0 0 c1 2a 28 0 0 4 be e7 c8 a3 4 be (...A*(...>gH#.> 112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20 gH#)25 days, 10 128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73 hours, 3 minutes 144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e , 11 seconds.... slot 3: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 31 39 5 31 2f 30 2.23.0.80.19.1/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 /4.B0002.0031.AC 64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20 9F10.92.118.59 80: 44 53 33 20 6 51 41 4d 32 35 36 0 0 2 1a 3f DS3 .QAM256....? 96: a 0 0 0 c1 24 5a 0 0 4 be e7 c8 a3 4 be ....A$Z...>gH#.> 112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20 gH#)25 days, 10 128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73 hours, 3 minutes 144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e , 11 seconds.... slot 4: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 31 39 5 31 2f 30 2.23.0.80.19.1/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 /4.B0002.0031.AC 64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20 9F10.92.118.59 80: 44 53 34 20 6 51 41 4d 32 35 36 0 0 2 22 3f DS4 .QAM256..."? 96: 14 0 0 0 c1 2a 14 0 0 4 be e7 c8 a3 4 be ....A*....>gH#.> 112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20 gH#)25 days, 10 128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73 hours, 3 minutes 144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e , 11 seconds.... slot 5: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 31 39 5 31 2f 30 2.23.0.80.19.1/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 /4.B0002.0031.AC 64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20 9F10.92.118.59 80: 44 53 35 20 6 51 41 4d 32 35 36 0 0 2 e2 3e DS5 .QAM256...b> 96: 5e 0 0 0 c1 21 a 0 0 4 be e7 c8 a3 4 be ^...A!....>gH#.> 112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20 gH#)25 days, 10 128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73 hours, 3 minutes 144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e , 11 seconds.... slot 6: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 2 31 39 5 31 2f 30 2.23.0.80.19.1/0 48: 2f 34 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 /4.B0002.0031.AC 64: 39 46 31 30 2e 39 32 2e 31 31 38 2e 35 39 20 20 9F10.92.118.59 80: 44 53 31 20 6 51 41 4d 32 35 36 0 0 2 6a 3e DS1 .QAM256...j> 96: 5f a 0 0 c1 26 32 0 0 4 be e7 c8 a3 4 be _...A&2...>gH#.> 112: e7 c8 a3 29 32 35 20 64 61 79 73 2c 20 31 30 20 gH#)25 days, 10 128: 68 6f 75 72 73 2c 20 33 20 6d 69 6e 75 74 65 73 hours, 3 minutes 144: 2c 20 31 31 20 73 65 63 6f 6e 64 73 2e , 11 seconds.... slot 7: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 32 20 6 51 41 4d 32 35 36 0 0 2 12 c1 8 S2 .QAM256....A. 96: 0 0 0 c1 2c a 0 0 4 be e7 c8 a3 4 be e7 ...A,....>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 8: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 33 20 6 51 41 4d 32 35 36 0 0 2 1a c1 7 S3 .QAM256....A. 96: 46 0 0 c1 28 1e 0 0 4 be e7 c8 a3 4 be e7 F..A(....>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 9: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 34 20 6 51 41 4d 32 35 36 0 0 2 22 c1 7 S4 .QAM256..."A. 96: 3c 0 0 c1 2b 3c 0 0 4 be e7 c8 a3 4 be e7 <..A+<...>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 10: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 35 20 6 51 41 4d 32 35 36 0 0 2 2a c1 7 S5 .QAM256...*A. 96: 32 0 0 c1 2b 32 0 0 4 be e7 c8 a3 4 be e7 2..A+2...>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 11: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 36 20 6 51 41 4d 32 35 36 0 0 2 32 c1 7 S6 .QAM256...2A. 96: 14 0 0 c1 2b 1e 0 0 4 be e7 c8 a3 4 be e7 ...A+....>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 12: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 37 20 6 51 41 4d 32 35 36 0 0 2 3a c1 6 S7 .QAM256...:A. 96: 32 0 0 c1 2b 0 0 0 4 be e7 c8 a3 4 be e7 2..A+....>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 13: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 38 20 6 51 41 4d 32 35 36 0 0 2 42 c1 6 S8 .QAM256...BA. 96: 1e 0 0 c1 2a 50 0 0 4 be e7 c8 a3 4 be e7 ...A*P...>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 14: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 31 5 31 2f 30 2f 2.23.0.80.1.1/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 43 46 1.B0002.0031.ACF 64: 41 31 30 2e 39 32 2e 31 31 39 2e 34 34 20 20 44 A10.92.119.44 D 80: 53 31 20 6 51 41 4d 32 35 36 0 0 2 7a c1 7 S1 .QAM256...zA. 96: 1e 0 0 c1 2a 5a 0 0 4 be e7 c8 a3 4 be e7 ...A*Z...>gH#.>g 112: c8 a3 2a 38 39 20 64 61 79 73 2c 20 31 39 20 68 H#*89 days, 19 h 128: 6f 75 72 73 2c 20 34 38 20 6d 69 6e 75 74 65 73 ours, 48 minutes 144: 2c 20 34 33 20 73 65 63 6f 6e 64 73 2e , 43 seconds.... slot 15: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 32 20 6 51 41 4d 32 35 36 0 0 2 12 3b 4e S2 .QAM256....;N 96: 34 33 3c c1 2c 46 0 0 4 ba d2 b7 ae 4 be e7 43<A,F...:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 16: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 33 20 6 51 41 4d 32 35 36 0 0 2 1a 3b 4e S3 .QAM256....;N 96: 34 33 3c c1 28 50 0 0 4 ba d2 b7 ae 4 be e7 43<A(P...:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 17: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 34 20 6 51 41 4d 32 35 36 0 0 2 22 3b 4e S4 .QAM256...";N 96: 34 33 3c c1 2c 50 0 0 4 ba d2 b7 ae 4 be e7 43<A,P...:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 18: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 35 20 6 51 41 4d 32 35 36 0 0 2 2a 3b 4e S5 .QAM256...*;N 96: 34 33 3c c1 2c 1e 0 0 4 ba d2 b7 ae 4 be e7 43<A,....:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 19: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 36 20 6 51 41 4d 32 35 36 0 0 2 32 3b 4e S6 .QAM256...2;N 96: 34 33 3c c1 2c 3c 0 0 4 ba d2 b7 ae 4 be e7 43<A,<...:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 20: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 37 20 6 51 41 4d 32 35 36 0 0 2 3a 3b 4e S7 .QAM256...:;N 96: 34 33 3c c1 2d 0 0 0 4 ba d2 b7 ae 4 be e7 43<A-....:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 21: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 38 20 6 51 41 4d 32 35 36 0 0 2 42 3b 4e S8 .QAM256...B;N 96: 34 33 3c c1 2d 0 0 0 4 ba d2 b7 ae 4 be e7 43<A-....:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 22: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 35 5 32 2f 30 2f 2.23.0.80.5.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 41 45 34 1.B0002.0031.AE4 64: 42 31 30 2e 39 32 2e 31 31 39 2e 32 34 35 20 44 B10.92.119.245 D 80: 53 31 20 6 51 41 4d 32 35 36 0 0 2 6a 3b 4e S1 .QAM256...j;N 96: 34 33 3c c1 2c 3c 0 0 4 ba d2 b7 ae 4 be e7 43<A,<...:R7..>g 112: c8 a3 2a 34 36 20 64 61 79 73 2c 20 31 37 20 68 H#*46 days, 17 h 128: 6f 75 72 73 2c 20 31 30 20 6d 69 6e 75 74 65 73 ours, 10 minutes 144: 2c 20 34 34 20 73 65 63 6f 6e 64 73 2e , 44 seconds.... slot 23: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 39 5 32 2f 30 2f 2.23.0.80.9.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 42 32 46 1.B0002.0031.B2F 64: 45 31 30 2e 39 32 2e 31 31 32 2e 31 39 34 20 44 E10.92.112.194 D 80: 53 32 20 6 51 41 4d 32 35 36 0 0 2 12 c1 2 S2 .QAM256....A. 96: 50 0 0 c1 2a 14 0 0 4 be e7 c8 a3 4 be e7 P..A*....>gH#.>g 112: c8 a3 2a 33 30 20 64 61 79 73 2c 20 32 31 20 68 H#*30 days, 21 h 128: 6f 75 72 73 2c 20 31 33 20 6d 69 6e 75 74 65 73 ours, 13 minutes 144: 2c 20 32 35 20 73 65 63 6f 6e 64 73 2e , 25 seconds.... slot 24: 0: 32 30 32 31 31 31 32 39 31 37 30 30 38 30 30 4e 202111291700800N 16: 30 31 30 30 38 57 42 35 37 33 30 31 31 b 31 37 01008WB573011.17 32: 32 2e 32 33 2e 30 2e 38 30 1 39 5 32 2f 30 2f 2.23.0.80.9.2/0/ 48: 31 1 42 30 30 30 32 2e 30 30 33 31 2e 42 32 46 1.B0002.0031.B2F 64: 45 31 30 2e 39 32 2e 31 31 32 2e 31 39 34 20 44 E10.92.112.194 D 80: 53 33 20 6 51 41 4d 32 35 36 0 0 2 1a c1 3 S3 .QAM256....A. 96: a 0 0 c1 27 32 0 0 4 be e7 c8 a3 4 be e7 ...A'2...>gH#.>g 112: c8 a3 2a 33 30 20 64 61 79 73 2c 20 32 31 20 68 H#*30 days, 21 h 128: 6f 75 72 73 2c 20 31 33 20 6d 69 6e 75 74 65 73 ours, 13 minutes 144: 2c 20 32 35 20 73 65 63 6f 6e 64 73 2e , 25 seconds.... ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Sang, I wonder if that is the null value for the data type. Just curious. +----- Jacob Salomon -- jakesalomon@yahoo.com -------------------------+ | The first lesson of economics is scarcity: there is never enough of | | anything to fully satisfy all those who want it. The first lesson of | | politics is to disregard the first lesson of economics. | +------------------------------ Thomas Sowell (Is Reality Optional?) --+

Thanks for your reply, Jacob. It was not searched with a null condition for that column. > select first 10 rowid, power from stat_cm_pwr_bad_800_11 where power < -100;rowid power 2577922 -21474840 2577923 -21474840 2577924 -21474840 2577925 -21474840 2577926 -21474840 2577927 -21474840 2577928 -21474840 2577929 -21474840 2583811 -21474840 2583812 -21474840 10 row(s) retrieved. > select * from stat_cm_pwr_bad_800_11 where power is null;No rows found. > select first 10 rowid, power from stat_cm_pwr_bad_800_11 where power = -21474840;rowid power 2577922 -21474840 2577923 -21474840 2577924 -21474840 2577925 -21474840 2577926 -21474840 2577927 -21474840 2577928 -21474840 2577929 -21474840 2583811 -21474840 2583812 -21474840 10 row(s) retrieved. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Hello! I would write a little ESQL/C program, to fetch the value of the "power" column into a dec_t structure, and inspect the content of the dec_t variable. Maybe it will give some hint... Check dec_t definition in $INFORMIXDIR/incl/esql/decimal.h Also, is the DBMONEY environment variable defined? Seb ------------------------------ Sebastien FLAESCH ------------------------------