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






Please be aware that it is very ambiguous to determine the end of embedded
SQL within free form RPG.
Before you hit format, make sure that you have a semicolon inserted to
terminate your SQL. If it is a compound statement you might need your end
statement;
Given the ambiguity of the language, please help the tooling out by making
the end clear. In the meantime RDi will try its best, but cannot guarantee
it will get it right.



|
|
|Edmund Reinhardt
|
|Rational Developer for i Architect
|
|IBM
|p:
| 905 413 3125
|w:
| ibm.biz/rdi_hub e:
| edmund.reinhardt@xxxxxxxxxx
|







From: "Mike Hockings" <hockings@xxxxxxxxxx>
To: "Rational Developer for IBM i" <wdsci-l@xxxxxxxxxxxxxxxxxx>
Date: 09/20/2021 10:59 PM
Subject: [EXTERNAL] Re: [WDSCI-L] Corrupted my RDI settings
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx>






Do you mean the conversion to uppercase? Check out the preferences under
Remote Systems>Remote Systems LPEX Editor>IBM i parsers>ILE RPG and UNcheck
the "Automatic Uppercasing" checkbox? Did you maybe create a template or
something for the exec statement?

I would really recommend that you fire up IM and update from 9.6.0.6 to
9.6.0.11

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: "Eric Wolf" <EWolf@xxxxxxxxxxxxx>
To: "wdsci-l@xxxxxxxxxxxxxxxxxx" <wdsci-l@xxxxxxxxxxxxxxxxxx>
Date: 2021/09/20 02:44 PM
Subject: [EXTERNAL] [WDSCI-L] Corrupted my RDI settings
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx>



I am new to using RDI and am using Version 9.6.0.6 and somewhere I changed
some settings that made it so when I add some lines I get strange results.

Before:
Exsr zzInitial;

* Write record that will be used to run the re-process this transaction
*inlr = *on;

When I add the following line after zzInitial:
Exec sql

I get the following result:
EXEC SQL
WRITE RECORD THAT WILL BE USED TO RUN THE RE - PROCESS THIS
TRANSACTION


Does anyone have any idea what I changed to corrupt this? I am at a point
where I cannot use RDI if this is the result of this change? Is there a
way to set all the application's defaults with a single update?

Thanks...
Eric A. Wolf
Sr. Program Developer
2980 N. San Fernando Blvd.<
https://www.google.com/maps/place/2980+N+San+Fernando+Blvd,+Burbank,+CA+91504/@34.2016192,-118.3414462,17z/data=!3m1!4b1!4m2!3m1!1s0x80c29506b13e342b:0x8e7c0e2b16b32dff


Burbank, CA 91504-2566<
https://www.google.com/maps/place/2980+N+San+Fernando+Blvd,+Burbank,+CA+91504/@34.2016192,-118.3414462,17z/data=!3m1!4b1!4m2!3m1!1s0x80c29506b13e342b:0x8e7c0e2b16b32dff


[cid:image001.png@01D7AE14.7E3A2E00] (818) 260-2936
[cid:image002.jpg@01D7AE14.7E3A2E00] (818) 669-0636
[cid:image003.png@01D7AE14.7E3A2E00] ewolf@xxxxxxxxxxxxx<
mailto:ewolf@xxxxxxxxxxxxx>
[cid:image004.png@01D7AE14.7E3A2E00]<
https://seniorssp.com/


A division of Senior Operations LLC

This communication is intended only for the use of the individual or entity
to which it is addressed and may contain information that is privileged,
confidential, or otherwise exempt from disclosure under applicable law. If
you are not the intended recipient, or the employee or agent responsible
for delivering this communication to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, please immediately notify the sender by telephone
or email. The technical data herein provided is subject to export control
under the International Traffic in Arms Regulations (ITAR) or the Export
Administration Regulations (EAR). Such data should not be disclosed,
exported or transferred in any manner to any foreign person or any foreign
country without prior written approval of the Office of Defense Trade
Controls, U.S. Department of State or the Bureau of Industry
and Security, U.S. Department of Commerce.

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please contact: admin@xxxxxxxxxxxxx
______________________________________________________________________
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/wdsci-l


or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/wdsci-l

.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com




--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/wdsci-l

or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/wdsci-l
.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.