×
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.
I'm on version 9.5.0.2 and having this issue also. I have isolated my issue
to the following code, if I comment it out I get an outline.
/free
//?======================================================================
//?Set SQL-Precompiler Options.
//?This statement is not an executable statement. Instead, it
provides
//?instruction to the SQL-Precompiler only.
//?======================================================================
exec sql
set option closqlcsr = *ENDMOD,
commit = *NONE,
datfmt = *ISO,
timfmt = *HMS;
exec sql
declare CURSOR1 cursor with hold for
select PARTITION_NAME
from DH#TOOLS.PARTITIONS_TO_PROCESS
where RBA_REFRESH = '1'
order by PARTITION_NAME
for read only
optimize for all rows;
exec sql
declare CURSOR2 cursor with hold for
select MS4_FILE_NAME, RBA_TABLE_NAME,
STORED_PROCEDURE, LOG_TABLE,
MULTIPLE_LIBRARIES
from DH#TOOLS.RBA_TABLES_TO_PROCESS
order by MS4_FILE_NAME
for read only
optimize for all rows;
exec sql
declare CURSOR3 cursor for cursor3select;
/end-free
If I put the cursor over the yellow box, it says "misplaced construct(s)",
which is a Java error. The program compiles and runs on the iSeries without
issues.
Thanks,
jon
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
midrange.com
