Re: rec level i/o to QTEMP

[dawall@xxxxxxxxxx]

The short answer (the one you won't like) is that CommandCall and RLA do
not use the same AS/400 server (job).  CommandCall uses the DPC server
while RLA uses the DRDA/DDM server.  These different servers run in
separate jobs so they have separate QTEMPs.  To create the file using
CommandCall then use it using RLA, you will have to store it in a library
other than QTEMP.  I realize this eliminates the 'garbage collection' of
QTEMP the AS/400 does for you, but since the servers are running in
separate jobs you don't get to use QTEMP.

I will ask around to see if anyone else has good ideas to solve the
problem.

David Wall
AS/400 Toolbox for Java


"Alex Garrison" <agarrison@logtech.com> on 04/12/2000 09:38:46 PM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  rec level i/o to QTEMP




I remember there was some discussion several weeks ago about problems with
rec level i/o to QTEMP.  Would someone mind reposting the solution to the
problem?

Problem:  The rec level i/o classes like KeyedFile or
AS400FileRecordDescription dont seem to see files in QTEMP.  I know the
files exist in QTEMP because I have just done a CPYF to QTEMP using
CommandCall.  As a diagnostic I also did a DSPFD OUTPUT(*PRINT) on the file
in QTEMP again using CommandCall.  The spool file clearly shows the file is
in QTEMP.  When I try to do a
AS400FileRecordDescription.retrieveRecordFormat or KeyedFile.open on the
file, the as/400 insists on telling me that the file doesnt exist in QTEMP.

BTW:  I do make absolutely sure that I am using the same AS400 object
connection for the whole process.  Also I am using the latest mod2 toolbox.
The as/400 is at v4r4 with fairly recent ptfs.


Here is a little code snippet that fails with a "CPF3012 File STATUS in
library QTEMP not found." when retrieving the record format:

 AS400 host = null;
 host = new AS400("MYSYS","MYUSRPRF","MYPASSWORD");
 host.connectService(AS400.COMMAND);
 host.connectService(AS400.RECORDACCESS);
 CommandCall cmd = new CommandCall(host);
 System.out.println("running command");
 cmd.run("CPYF FROMFILE(MYLIB/STATUS) TOFILE(QTEMP/STATUS) CRTFILE(*YES)");
 cmd.run("DSPFD QTEMP/STATUS OUTPUT(*PRINT)");
 QSYSObjectPathName filepath = new
QSYSObjectPathName("QTEMP","STATUS","*FILE","MBR");
 KeyedFile file = new KeyedFile(host,filepath.getPath());
 AS400FileRecordDescription recdesc = new
AS400FileRecordDescription(host,filepath.getPath());
 System.out.println("getting record format");
 RecordFormat[] recfmt = recdesc.retrieveRecordFormat();


Sorry to ask for the repost, but this problem is quite frustrating.

Alex Garrison


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---