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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.