× 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.


  1.  Home
  2. RPG400-L
  3. May 2009

Re: alter table not smallint

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 thread ...
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.