Re: alter table not smallint -- RPG400-L

Subject: Re: alter table not smallint
From: Charles Wilt <charles.wilt@xxxxxxxxx>
Date: Thu, 14 May 2009 14:52:55 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the IBM i / System i <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

On Thu, May 14, 2009 at 3:33 PM, Tom Deskevich
<thomas.l.deskevich@xxxxxxxxxxxxx> wrote:

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

you're missing a comma between :sptrg and :spabaicd. The system
thinks spabaicd is a NULL indicator variable for sptrg.

Charles

As an Amazon Associate we earn from qualifying purchases.

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.