Tags
 IOS SQL HTML C RUBY-ON-RAILS MYSQL ASP.NET DEVELOPMENT RUBY .NET LINUX SQL-SERVER REGEX WINDOWS ALGORITHM ECLIPSE VISUAL-STUDIO STRING SVN PERFORMANCE APACHE-FLEX UNIT-TESTING SECURITY LINQ UNIX MATH EMAIL OOP LANGUAGE-AGNOSTIC VB6

# Encountered compile time error when embedding sql statement in sub-procedure

By : Eduardo Rodriguez
Date : September 15 2020, 08:00 PM
hop of those help? There's a PTF for that: https://www-01.ibm.com/support/docview.wss?uid=nas3SI68275
Here's how I found it: I went to the RPG Cafe's new main page (https://ibm.biz/rpg_cafe) and put "crtsqlrpgi rnf7030" into the general "Support" search bar at the top.
code :
Resolving CRTSQLRPGI that fails with RNF7030,RNF7503 using RPGPPOPT(*LVL2)
SI68275 - SQL-CMPL-MSGRNF7030 CRTSQLRPGI FAILS WITH RNF7030 AS SQL PRE
SI68274 - SQL-CMPL-MSGRNF7030 CRTSQLRPGI FAILS WITH RNF7030 AS SQL PRE

SI68275 - SQL-CMPL-MSGRNF7030 CRTSQLRPGI FAILS WITH RNF7030 AS SQL PRE
SE69905 - SQL-CMPL-MSGRNF7030 CRTSQLRPGI FAILS WITH RNF7030 AS SQL PRECOMPILER INSERTS RPG STATEMENTS INCORRECTLY


Share :

## Compile time error with this switch statement

By : seo530
Date : March 29 2020, 07:55 AM
around this issue Any of the other switch blocks will just hit the "break" statement depending on the value of "someOtherValue". You have no return statement after the switch, so any of the situations where the "break" is hit will not return a value.

## Procedure is throwing compile time error oracle

By : kb7
Date : March 29 2020, 07:55 AM
wish help you to fix your issue You cannot directly run DDL inside a procedure. You need to use EXECUTE IMMEDIATE.
code :
CREATE OR REPLACE PROCEDURE prc_DropUselessTables (userID NUMBER := 0)
AS
ncount   NUMBER := 0;
BEGIN
SELECT COUNT (*)
INTO NCOUNT
FROM User_Tables
WHERE table_name = 'DummyTable';

IF (ncount > 0)
THEN
EXECUTE IMMEDIATE 'Drop table DummyTable';
END IF;
END prc_DropUselessTables;


## Compile time error in assignment statement

By : indentsang
Date : March 29 2020, 07:55 AM
help you fix your problem You're including an explicit typecast on the left hand side - this can be allowed for variables, but here Items is a property accessed via a getter and so it is not a variable but a function result. The only place you can typecast here, if needed, is on the right hand side of the assignment.
We don't know the type of TimerList, but assuming it is a compatible type like TList you can just assign it directly.
code :
 TimerList.Items[Row] := TTimer.Create(Self);

var
LMyTimer : TTimer
begin
LMyTimer := TTimer(TimerList.Items[someIndex]);


## SQR procedure with run-time error on BEGIN-SELECT statement

By : ritu singh
Date : March 29 2020, 07:55 AM
fixed the issue. Will look into that further I found the answer... i knew it was a silly mistake for not being familiar with SQR syntax
I did not indent the "LET" statements inside the SELECT area. Now I know only the SQL statement can appear in the first column.

## I am not able to use if statement every time it shows me error. Encountered symbol IF when expecting one of the followin

By : Gary Cobb
Date : March 29 2020, 07:55 AM
around this issue FORALL is not a loop, it is an integral part of the INSERT statement. So you can't use IF after FORALL.
....