Re: SQL precompile failed. SQL9001 received by C at 1200. (C D I R)

On one machine it is interactive, on the other I am using a CL because I
need to change come compile parameters & I'm not allowed to change the
command defaults. Here is the CL:

RTVMBRD FILE(&LIBNM/QRPGLESRC) MBR(&PGMNM) +
SRCTYPE(&SRCTYP)
MONMSG MSGID(CPF9815)

SELECT
WHEN COND(&SRCTYP *EQ 'SQLRPGLE') THEN(DO)
CRTSQLRPGI OBJ(&LIBNM/&PGMNM) SRCFILE(*LIBL/QRPGLESRC) +
COMMIT(*NONE) OUTPUT(*PRINT) +
RPGPPOPT(*LVL2) CLOSQLCSR(*ENDMOD) +
GENLVL(21) DATFMT(*JOB) DATSEP(*JOB) +
DBGVIEW(*SOURCE)
ENDDO

I don't thing changing from QTEMP to QGPL is in our hands.










"mahefa randimbisoa" <mahefa.randimbisoa@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
19/05/2008 04:30 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>

To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL precompile failed. SQL9001 received by C at 1200. (C D I R)





By hazard, are you compiling in interactive mode for both the 2 machines?

If you were compiling in batch mode, and submit the compilation in some
step,
the file created in QTEMP may be unavailable on another job.

What if you tried to replace QTEMP with QGPL for instance?


On Mon, May 19, 2008 at 1:38 PM, <ewart.desouza@xxxxxxxxxxx> wrote:

Hello all,

I'm in a fix. Somehow my SQLRPGLE programs are refusing to compile

giving

the above error. Anyone have any ideas what could be wrong. I'm sure

there

is some parameter missing but I can't seem to find it. To make things
worse these exact same programs are compiling fine in another machine

with

exactly the same compilation parameters. We are on V5R4.

The message on the message line is :
Member SPM100 file QSQLPRE in QTEMP not found.

The file does exist in QTEMP and also has the correct source program.
Object Type Attribute Text
QSQLPRE *FILE PF-SRC LOADING

I have got nested /COPY statements which is why I have the following
parameter:

RPG preprocessor options . . . . *LVL2

Here is the joblog:
Member SPM100 file QSQLPRE in QTEMP changed.
Diagnostic check of source is complete. Highest severity is 00.
File QRPGLESRC in library SPMSRC member SPM100 already open or has an
error.
Member SPM100 file QSQLPRE in QTEMP not found.
SQL precompile failed.
Function check. SQL9001 unmonitored by C at statement 1200, instruction
X'0028'.
SQL9001 received by C at 1200. (C D I R)


Any ideas ???

Thanks & best regards
Ewart



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
Mahefa
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.