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



Hi!



Having this working insert into statement:

exec sql

Insert Into TAGSTE/CPDETAILS :rowsreturned rows

values( :ds );



Now I need to be able to change the table name/library.

My understanding is that host variables cannot be used in a prepared
statement so:



Sqlstmt = 'Insert Into ' + %trimr( wxlib ) + '/' + %trimr( wxdb ) + ' ' +

' ? rows values(' + ds + ')';



exec sql

prepare tcanzjrn_insert_cpdetails

from :sqlstmt;



exec sql

execute tcanzjrn_insert_cpdetails

using

:rowsreturned;



The ds is declared as:

dcl-ds ds qualified dim(100);

CPCODE CHAR( 1 ); // Journal code

CPENTT CHAR( 2 ); // Entry type

CPTSTP TIMESTAMP; // Timestamp of entry

...

end-ds;



The compiler pukes at my first sqlstmt assignment by claiming:

*RNF5343 30 1 Array has too many omitted indexes; specification is
ignored.



How can I circumvent this?



Thanks!




Stefan Tageson












As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.