How to create RPGIV program with embedded SQL

[Guest.Visitor]

I decided to modify a subfile program to use embedded SQL's instead of native I/O functions. (As a way of getting my feet wet for future development). Anyway, the original program was created using the CRTRPGMOD/CRTPGM combo because is bounded to a service program, as well as it run on a named activation group. The CRTSQLRPGI command does not allow an activation group nor a service program to be specified. So my question is How do I compile this program? TIA

[Guest.Visitor]

Alan, I think you use the CRTSQLRPGI to create the bound module then use CRTPGM specifing the service program and activation group. HTH, John

[Guest.Visitor]

In CRTSQLRPGI change the parameter OBJTYPE to *MODULE

[Guest.Visitor]

John, that did it! Thanks.