Using TOSRCFILE on CRTSQLRPGI from a local workspace with deployment

[m-tyler]

I have been moving to develop my temporary or conversion programs locally. I have it set up to deploy and start the compile successfully. CRTBNDRPG works just fine. Often when there is an issue with SQL compiler with a result set DS', I can get a cryptic SQL error about the DS. This leads me to have a source file for the temporary member (the default file is QSQLTEMP1) which persists in my library. I use a temp source file to open up the precompile source to attempt a compile to see if there are other more obvious reasons for the initial compile issue.

So I often add the keyword TOSRCFILE() to the CRTSQLRPGI command string. If I do this with STMF() source there is a problem with the compiler finding the precompile source.

Shell command:/home/PGMT/builds/MySource/: /QOpenSys/usr/bin/qsh...
Command used: CRTSQLRPGI OBJ(PGMT/CVT20617R2) SRCSTMF('CVTSRC/CVT20617R2.SQLRPGLE') OBJTYPE(*MODULE) OPTION(*EVENTF) DBGVIEW(*SOURCE) CLOSQLCSR(*ENDMOD) TOSRCFILE(PGMT/QSQLTEMP2) CVTCCSID(*JOB)

The error that causes a compile error: RNS9339: Unable to open file /QSYS.LIB/PGMT.LIB/QSQLTEMP2.FILE/CVT20617R2.MBR.

Running the CRTSQLRPGI the same way from a 5250 command line produces the same error. It seems that the CRTSQLRPGI compiler code is formatting the member string wrong WHEN I supply a value for the keyword TOSRCFILE(). I know this is an IBM problem but I have failed to find any information on this problem. My company is still at 7.3 and won't be moving up until later this year or next year.
My work around is to supply the keyword, find the reasons for the initial SQL compile error relating to the result set DS, fix my code then compile without that keyword.

Is this issue familiar to anyone here?

[m-tyler]

So the base problem is the system compiler cannot find the temporary source because its located in an IASP. Whenever I use a library that is in the SYSBASE it functions just fine.