Re: JAVA400-L Digest, Vol 2, Issue 331

[Marshall Dunbar/DPS <marshall@xxxxxxxxxxx>]

That is very strange.  I just ran this test successfully (via STRSQL, 
which should give the same results as JDBC):

 CREATE TABLE QTEMP/IT005P (ITEM_NUMBER DECIMAL (7 , 0) NOT NULL WITH 
DEFAULT) 
 Table IT005P created in QTEMP. 

 INSERT INTO IT005P (ITEM_NUMBER) VALUES(47001) 
 1 rows inserted in IT005P in QTEMP. 


DSPFFD QTEMP/IT005P shows:

           Data        Field  Buffer    Buffer        Field    Column 
Field      Type       Length  Length  Position        Usage    Heading 
ITEM_00001 PACKED       7  0       4         1        Both     ITEM_NUMBER
  Alternative name  . . . . . . . . . . . . : 
      ITEM_NUMBER 

When you do DSPFFD on your file, are the field attributes the same as my 
test?

===
Marshall Dunbar
DPS, Inc.
marshall@xxxxxxxxxxx
direct:(828)635-5561
main office:(317)574-4300 (800)654-4689
====

java400-l-bounces@xxxxxxxxxxxx wrote on 10/28/2004 02:07:57 PM:


> 
> Hi Marshall
> 
> Thanks for the suggestion-- I had already tried that, and received the
> following:
> 
> SQL Statement = INSERT INTO IT005P (ITEM_NUMBER) VALUES(47001)
> 
> Error: [SQL0408] Value for column or variable ITEM_NUMBER not 
compatible.
> 
> Which is why I was wondering if I needed to do some sort of typecasting 
or
> conversion for the INSERT Statement.  ITEM_NUMBER is a 7-position, 0 
decimals
> packed field.
> 
> Any other ideas greatly appreciated.
> 
> Thanks.
> 
> -Ed