|
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 mailing list archive is Copyright 1997-2025 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.