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?