Re: alter table not smallint

The CREATE TABLE was? The ALTER TABLE was? The INSERT INTO was? Was it really SQL DDL that gave an error code? What is the message identifier; i.e. /tells me/ tells _us_, very little about what the database really /told you/. Message identifiers, text, and replacement values exist expressly for the purpose of diagnosing errors.

FWiW only the invocation of CHGPF which uses CHGPF SRCFILE(named) is somewhat comparable to the use of SQL ALTER TABLE, but with respect only to column changes.

Regards, Chuck

Tom Deskevich wrote:

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?