Need help accessing a file on iSeries

Hi, I am wondering if someone could help me with a simple script - I’m not much of a programmer :slight_smile:

I need to create an agent that gets information from a file on the same iSeries that Domino runs on. I need to be able to store that info in a view in Notes.

Once I understand how to get the info from the file I think I am okay.

Here’s what I have:

The file name is ReportInfo and resides in the library Diane2 on the system called BEAR and the field descriptions are:

RptNam A 10 4 13 REPORT NAME

RptDistNbr P 9 0 14 18 RPT DISTRIBUTION NBR

RecNam A 35 19 53 RECIPIENTS NAME

Not sure if I need to do LCConnection or???

Can anyone give me a nudge in the right direction?

Subject: developer recommends…

… one method is to use LC LSX (Lotus Connector LotusScript Extensions) to access data files so that these files can be treated as the DB2 tables and use SQL to retrieve data is an easy way.

These Redbooks may be helpful:

http://www.redbooks.ibm.com/abstracts/SG246203.html

http://www.redbooks.ibm.com/abstracts/sg246067.html