×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
