Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does RTPA audit embedded SQL statements?

April 26, 2017audit embedded rtpa sql statements

0

Posted

Does RTPA audit embedded SQL statements?

1 Answer

0

Posted

Yes. Embedded SQL statements are converted to RPG statements by the IBM SQL pre-compiler, and RTPA audits the converted SQL statements. Top • Does RTPA for RPG audit all RPG source programs? Yes. RTPA for RPG is designed to audit all types RPG source programs including: RPG, RPT, SQLRPG, RPGMOD, RPGLE, SQLRPGLE and SQLRPGMOD. Top • Does RTPA for RPG audit copybook (C/COPY) statements? RTPA can audit any source statement, including copybook source statements. RTPA does not expand I/COPY copybook statements. For copybooks with D specs, such as SDS definitions, use the format D/COPY instead of I/COPY (as in RPGIII). Top • Can I ship audit-enabled programs? RTPA for RPG is intended for use in program development, unit testing, system testing and pilot production. RTPA is not intended for use in normal production processing, except as needed. You may not ship or sell any audit-enabled software to any third party. Top • Can I use RTPA with my other programming utilities? Yes. RTPA works alon