RNF2120 compilation error

[tomlini]

Greetings All,

I am new to this forum and I have recently returned to RPG after a 4 year break. My experience is RPG400 but I am working with RPG IV. I have a problem with creating a module that appears simple but I must be missing something and would appreciate any help.

I have created a couple of tables into QTEMP using SQL from RUNSQLSTM. The objects are created and QTEMP is in the library list, however, the module fails with an RNF2120 advising it cannot see the files.

Thanks for any help,
Tomlini

[renur]

Re: RNF2120 compilation error

Hi,
Are you compiling in batch mode?

[Mercury]

Re: RNF2120 compilation error

IMO You'd better off using a CREATE TABLE QTEMP/MYTABLE stm embedded in the RPG program.

[ChrisL]

Re: RNF2120 compilation error

QTEMP is specific for the job which is active, for example, if you have 2 sessions signed onto the AS/400 and place an object into QTEMP for session A, session B will know nothing about the object.

Same goes for a submitted job, if you have created the files from your interactive session and then submitted the compile to batch, the QTEMP library that is used by the batch job will not have the files you created in them.

Try creating a dummy library and loading the files into there, making sure that when you submit the job it has this library in your library list.

Hope this helps.

[tomlini]

Re: RNF2120 compilation error

Thanks all for the quick responses.

I was compiling in batch! Can't believe I'd forgotten that.