Re: alter table not smallint

I did review the data. If it a charecter field to a charecter field.
0192.01 C eval spabaicd=A_abaicd
0193.00 C/EXEC sql
0194.00 C+ INSERT INTO ICSRVLIB/XXXSP50P (SPACTION, SPPROJECT, SPIMAGEID,
0195.00 C+ SPRVIKEY1, SPRVIKEY2, SPUSER, SPDEVICE, SPPATH, SPTIME,
0196.00 C+ SPPAGES, SPERROR, SPACCEPT, SPREASON, SPPROGRAM, SPTRG,
SPABAICD)
0197.00 C+ VALUES(:SPACTION, :spproject,
0198.00 C+ :spimageid, :sprvikey1, :sprvikey2, :spuser, :spdevice,
0199.00 C+ :sppath, :sptime, :sppages, :sperror, :spaccept, :spreason,
0200.00 C+ :spprogram, :sptrg :spabaicd)
0201.00 C/end-exec

Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
ABAICD CHAR 30 30 220 Both Image
Path
Coded Character Set Identifier . . . . . : 37
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
SPABAICD CHAR 30 30 269 Both SPABAICD
Allows the null value
Default value . . . . . . . . . . . . . . :

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


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of DeLong, Eric
Sent: Thursday, May 14, 2009 9:56 AM
To: RPG programming on the IBM i / System i
Subject: 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


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.