I think Charles nailed it with the null flag. In this case, line 200
shows the culprit:
0200.00 C+ :spprogram, :sptrg :spabaicd)
Notice that there is no comma between :sptrg and :spabaicd. To SQL, it
looks like you're passing a null indicator, which is required to be
smallint. Add your comma and try again...
-Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Deskevich
Sent: Thursday, May 14, 2009 2:33 PM
To: RPG programming on the IBM i / System i
Subject: 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.
midrange.com
