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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.