× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.