Re: Is there a trick to compiling RPG SQL programs in RDI?

David Gibbs wrote:

I've made my first foray's into writing RPG SQL programs and found that RDi's support for them to be somewhat lacking.

When I compile the program, the error list points to the temporary source that the SQL pre-processor generated.

If I override the temporary source to a real source-pf, I can get the errors to display (more or less, as they point to code that wasn't really written), but I also get a object lock error eventually (which I don't have the details of at the moment).

Is there any trick to working with RPG SQL in RDi?

I'm on WDSC here but that seems to be about it:

CRTSQLRPGI OBJ(lib/pgm) SRCFILE(lib/QRPGLESRC) SRCMBR(pgm)
OBJTYPE(*MODULE) OPTION(*EVENTF *XREF) RPGPPOPT(*NONE) REPLACE(*YES)
TOSRCFILE(*CURLIB/QSQLTEMP1) COMPILEOPT('DBGVIEW(*LIST)')

When it compiles, I get a new editor tab with the errors. I use Ctrl-.
to find the next error, then Ctrl-F6 to switch to the actual source I
can edit. A lot.
--buck