I suspect the cause is this problem that was reported in 9.5.1.2 :
SE67507 RDI 9.5.1.2 NOT DETECTING THE END OF FREE-FORM SQL IN SQLRPGLE
SOURCE CAUSING NO OUTLINE TO BE SHOWN
The fix is in RDI 9.6.0.0 and later. ...
Mike
Mike Hockings, M.Eng., P.Eng.
DevOps for Enterprise
IBM Developer for z Systems and Power Systems Software Technical Support
IBM Canada Ltd. Laboratory
hockings@xxxxxxxxxx
voice 1-905-413-3199 T/L 313-3199 ITN 23133199
From: Terry Hertel <T.Hertel@xxxxxxxxxxxxxxxxx>
To: "wdsci-l@xxxxxxxxxxxxxxxxxx" <wdsci-l@xxxxxxxxxxxxxxxxxx>
Date: 2019/01/25 13:14
Subject: [WDSCI-L] Empty outline
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx>
There shouldn't be a semi-colon at the end of the second line - the SQL
statement continues for another 60 lines (three CTE's and then a select
statement joining the results of the CTE's). I didn't include the rest of
the SQL because it was so long and I assumed that the triangle would be
displayed at or after the problem line(s), if there were any. I submitted a
Service Request and Mike Hockings replied and confirmed that the issue is a
defect in the release that I am using. The problem was fixed in later
releases.
------------------------------
message: 3
date: Thu, 24 Jan 2019 19:08:27 -0500
from: "Edmund Reinhardt" <edmund.reinhardt@xxxxxxxxxx>
subject: Re: [WDSCI-L] Empty outline
Hi Terry
You are missing the ; at the end of the second EXEC SQL
Without that, the parser considers the rest of the file SQL instead of RPG.
HTH,
Edmund
From: Terry Hertel <T.Hertel@xxxxxxxxxxxxxxxxx>
To: "wdsci-l@xxxxxxxxxxxxxxxxxx" <wdsci-l@xxxxxxxxxxxxxxxxxx>
Date: 01/24/2019 03:15 PM
Subject: [WDSCI-L] Empty outline
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx>
I'm running RDi version 9.5.1.1 (on V7.1). Yes, I know I'm behind but there
are several reasons why I haven't upgraded: 1) it has been a very stable
and reliable version for the type of programming that we were doing, and 2)
most development is on hold as we convert to a different ERP system. That
being said, I have written an SQLRPGLE program to extract data from one
file. There are three routines in the program that all use SQL statements
to create a table in QTEMP, change the column labels, and then inserts data
into the table. The program compiles without errors and runs without
errors. I opened it today to add another option to the program and noticed
that the outline is blank. There is a yellow triangle with an exclamation
point to the left of the line number, but I am unsure what it doesn't like
since it compiles with a 00 highest severity. The SQL pre-compile list
contains the following errors:
SQL5066 0 136 Precompile option NAMING changed by SET OPTION
statement.
SQL5066 0 136 Precompile option COMMIT changed by SET OPTION
statement.
SQL5066 0 136 Precompile option DATFMT changed by SET OPTION
statement.
SQL5066 0 136 Precompile option CLOSQLCSR changed by SET OPTION
statement.
SQL5066 0 136 Precompile option NAMING changed by SET OPTION
statement.
SQL5066 0 136 Precompile option COMMIT changed by SET OPTION
statement.
SQL5066 0 136 Precompile option DATFMT changed by SET OPTION
statement.
SQL5066 0 136 Precompile option CLOSQLCSR changed by SET OPTION
statement.
SQL1103 10 181 Position 30 Column definitions for table SOQTESUMF in
QTEMP not found.
SQL0088 0 193 Position 14 DELETE applies to entire table.
SQL1103 10 193 Position 26 Column definitions for table SOQTESUMF in
QTEMP not found.
SQL1103 10 197 Position 26 Column definitions for table SOQTESUMF in
QTEMP not found.
SQL1103 10 300 Position 30 Column definitions for table SOQTECUSF in
QTEMP not found.
SQL0088 0 313 Position 14 DELETE applies to entire table.
SQL1103 10 313 Position 26 Column definitions for table SOQTECUSF in
QTEMP not found.
SQL1103 10 317 Position 26 Column definitions for table SOQTECUSF in
QTEMP not found.
SQL1103 10 422 Position 30 Column definitions for table SOQTESGLF in
QTEMP not found.
SQL0088 0 436 Position 14 DELETE applies to entire table.
SQL1103 10 436 Position 26 Column definitions for table SOQTESGLF in
QTEMP not found.
SQL1103 10 441 Position 26 Column definitions for table SOQTESGLF in
QTEMP not found.
The lines of code in the area where the triangle appears are (the triangle
is on the second Exec Sql statement):
// Delete records from table in case it already existed
Exec Sql
Delete from qtemp/soqtecusf;
// Populate the file
Exec Sql
insert into qtemp/soqtecusf
Not sure where to go from here.
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=wo0uDJijITU2f7aW2HWa1KiNWzc2cb7dgMN4W-85iwI&m=b-Z-QaGWs_wAA2ANxX6QpydocHs3x2MknsqAJyQJoZg&s=MCTYjwI9nfCoS-bP4jQU8uoMZGdB0LTqL_bvYxmbbAs&e=
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=wo0uDJijITU2f7aW2HWa1KiNWzc2cb7dgMN4W-85iwI&m=b-Z-QaGWs_wAA2ANxX6QpydocHs3x2MknsqAJyQJoZg&s=yiiHfmUbPQP4Qf76USKQZdhgZi_ieceONipwUGiX2is&e=
.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=wo0uDJijITU2f7aW2HWa1KiNWzc2cb7dgMN4W-85iwI&m=b-Z-QaGWs_wAA2ANxX6QpydocHs3x2MknsqAJyQJoZg&s=N6X8MU_z50vIhXB1_d0JA44K1ZuholFlp1vq_X02UbM&e=
midrange.com
