I have problem and do not know how to solve! (The compiler show error as syntax error)
I use SQL in RPG3 to delete all data from Physical file
It always show error : "THE CONTROL-LEVEL-INDICATOR ENTRY IS INVALID".
I write subroutine as below:
************************************************** *************
* function: Clear data in file ACo002
************************************************** *************
C CLEAR BEGSR
C*/EXEC SQL
C*+ PREPARE D FROM DELETE FROM ACO002
C*+ EXECUTE D
C*/END-EXEC
C ENDSR
************************************************** *************
I read document in RPG. It said that before use embebed SQL, we should declare "some thing" in calculation specification. But I do not know how and where to declare this statement.
Please help me it anyone know how to solve.
I attached my "picture program"!!!
Thanks in advance,
I use SQL in RPG3 to delete all data from Physical file
It always show error : "THE CONTROL-LEVEL-INDICATOR ENTRY IS INVALID".
I write subroutine as below:
************************************************** *************
* function: Clear data in file ACo002
************************************************** *************
C CLEAR BEGSR
C*/EXEC SQL
C*+ PREPARE D FROM DELETE FROM ACO002
C*+ EXECUTE D
C*/END-EXEC
C ENDSR
************************************************** *************
I read document in RPG. It said that before use embebed SQL, we should declare "some thing" in calculation specification. But I do not know how and where to declare this statement.
Please help me it anyone know how to solve.
I attached my "picture program"!!!
Thanks in advance,
Comment