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