Hello everyone.
How can I use the SQL statement in RPGLE member?
I have tried to enter very simple statement like:
C/EXEC SQL
C+ SELECT *
C+ FROM F_PRAC
C/END-EXEC
but the compiler (when I try to create a module) shows error: "Compiler directive not recognized".
In the member, there are subroutines that add, update, delete etc. records to/from F_PRAC pf. All are written using Free-Form. Now I want to use SQL to display records from the file (all records or expected ones). Can I do that inside Free-Form? Do I need to change RPGLE to SQLRPGLE? If I do that, will subroutines work correct?
How can I use the SQL statement in RPGLE member?
I have tried to enter very simple statement like:
C/EXEC SQL
C+ SELECT *
C+ FROM F_PRAC
C/END-EXEC
but the compiler (when I try to create a module) shows error: "Compiler directive not recognized".
In the member, there are subroutines that add, update, delete etc. records to/from F_PRAC pf. All are written using Free-Form. Now I want to use SQL to display records from the file (all records or expected ones). Can I do that inside Free-Form? Do I need to change RPGLE to SQLRPGLE? If I do that, will subroutines work correct?
Comment