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?

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].