RE: Reading sequential a database

First try hardcoding the file path to see if you can get it to work.

I also think you may need to qualify with the member name.

/QSYS.LIB/LIBNAME.LIB/XY.FILE/XY.MBR

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT


-----Original Message-----

------------------------------

message: 2
date: Fri, 21 Nov 2008 10:15:19 +0100
from: "Michael Schmitz" <schmitz.bit@xxxxxxxxxxxxxx>
subject: Reading sequential a database

Hello,

I try to read a database file in sequential mode. I use the %LIBL% to
set
the library list. Unfortunately I get the error that the file is not
found.
Does someone know why?

The code....

AS400 as400 = new AS400();
//chglibl
QSYSObjectPathName fileName = new
QSYSObjectPathName("/QSYS.LIB/%LIBL%.LIB/XY.FILE");
SequentialFile sFile = new SequentialFile(as400,
fileName.getPath());
AS400FileRecordDescription recDesc = new
AS400FileRecordDescription(as400, fileName.getPath());


sFile.setRecordFormat(recDesc.retrieveRecordFormat()[0]);
sFile.open(AS400File.READ_ONLY, 0 ,
AS400File.COMMIT_LOCK_LEVEL_NONE);
Record record = sFile.readFirst();

Thanks
Michael