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



Hello there,

        I need some help with a RUNSQLSTM of a stored procedure.  Up until
now, the RUNSQLSTM has worked fine.  Now I am getting the following error:

MSG ID  SEV  RECORD  TEXT
SQL0117  30       1  Statement contains wrong number of values.
                                               Message Summary
Total    Info    Warning    Error    Severe    Terminal
    1      0         0         0         1          0
30 level severity errors found in source
                                * * * * *  E N D  O F  L I S T I N G  * * *
* *

I have no idea as to what the wrong number of values is referring to.  I
have changed the stored proc and removed all comments before the first line.
The first line reads:

      1 CREATE PROCEDURE TESDAT/JAUDDISP2() RESULT SETS 1 LANGUAGE SQL

      2 BEGIN NOT ATOMIC



Any ideas from anyone?  I am about to manually enter the stored procedure
via strsql, but it will take a while (stored proc is approx. 704 lines
long).

Thank you,

Jose Amable Rodriguez
Dominican Knits, S.A. (GrupoM)
(809) 241 - 7171 x 3253
jarodriguez@grupom.com.do




As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.