Informix

 View Only
  • 1.  decimal type data input error (-1226)

    Posted Fri November 26, 2021 12:30 PM
    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
    ------------------------------


  • 2.  RE: decimal type data input error (-1226)

    Posted Fri November 26, 2021 01:03 PM
    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
    ------------------------------



  • 3.  RE: decimal type data input error (-1226)

    Posted Fri November 26, 2021 08:20 PM
    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
    ------------------------------



  • 4.  RE: decimal type data input error (-1226)

    Posted Mon November 29, 2021 02:19 AM
    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
    ------------------------------



  • 5.  RE: decimal type data input error (-1226)

    IBM Select
    Posted Mon November 29, 2021 03:24 AM
    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
    ------------------------------



  • 6.  RE: decimal type data input error (-1226)

    Posted Mon November 29, 2021 03:46 AM
    Edited by SangGyu Jeong Mon November 29, 2021 03:47 AM
    @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_202111291700
    
    DBSCHEMA 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
    ------------------------------



  • 7.  RE: decimal type data input error (-1226)

    Posted Mon November 29, 2021 10:11 AM
    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?) --+





  • 8.  RE: decimal type data input error (-1226)

    Posted Mon November 29, 2021 08:01 PM
    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
    ------------------------------



  • 9.  RE: decimal type data input error (-1226)

    Posted Tue November 30, 2021 03:38 AM
    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
    ------------------------------