RE: alter table not smallint

Did you review the data that you're trying to insert? Could it be that
you are telling SQL to insert a smallint value into a character field?

-Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Deskevich
Sent: Thursday, May 14, 2009 10:46 AM
To: IBM i / System i
Subject: alter table not smallint

When I do an alter table on a table created in sql,then compile a
SQLRPGLE with an INSERT to that table, it tells me that the column is
NOT SMALLINT.
If I do a DSPFFD, it shows the column as CHARECTER, as I defended it.

From what I read, it says all you need to do is ALTER TABLE. That seems

to

be the same as CHGPF in the SQL world.

I have researched this and have not found why it is doing this.

Can anyone either tell me why I am getting that error on the compile, or
give me a step-by-step process for altering a table? THANKS.

Tom Deskevich
Infocon Corporation
Phone 814-472-6066
Fax 814-472-5019