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



Me with another SQL issue.
Barbara's presentation states that the SQL precompiler supports all the new features in ILE RPG V6R1.
http://www.nemug.com/handouts/rpg_v6r1_whats_new_col.pdf
Maybe I shouldn't take from it that the SQL precompiler supports all ILE RPG functions, only the new ones, but that's what I'm doing (b/c if they're not I'm putting in a RFE).

Here's my new issue, SQL doesn't seem to like my host data structure array variable:
Exec SQL
Insert into CalTypTIDP (Carry)
Values( :ds_CalTypTID(gReadIndex).Carry );

Same definition of the DS as before:

D ds_CalTypTID DS LikeDS( dsTmpl_CalTypTID )

D Dim( MAX_BLOCK_READ )



Precompiler Error Messages (line 1301 is the "Values" line above):

SQL0312 30 1301 Position 25 Variable DS_CALTYPTID not defined or not usable.

SQL0104 30 1301 Position 24 Token : was not valid. Valid tokens: (.

SQL0104 30 1301 Position 37 Token ( was not valid. Valid tokens: UNION

EXCEPT INTERSECT.

Thanks for the help,

Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems

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.