Access a custom file with 8.0.3 PF Pro

We have a lot of custom tables accessed by process flows since we were on version 802. What is your problem?

PROD=&FILE=CUPCENTCO&FIELD=USER&SELECT=COMPANY_NO=0027&OUT=CSV&DELIM=~ This is what I am using in my query. When I test it in builder, it tells me the database is secured. What do I need to do to be able to access it?

<!-- Converted from text/plain format -->

The product line in that query/URL is missing. PROD= ???  S/b PROD=PRODLINE 

for one you are missing PROD=

Chito

We are an iSeries shop and have a separate library that our custom files are stored in. They aren't in the LAWAPP81 prodline. So what would I specify for the prodline in that case?

I'm assuming you mean a "custom library" as in not defined in a Lawson product line, correct?

Yes. Sorry I guess I wasn't very clear.

You can define your custom library as a separate product line but you have to redefine your tables and fields thru dbdef to create the metadata then build the dictionary and reorg.

Thanks Sam for the info!!! I'm so close to making this work! I'm getting an error on the reorg though that says "Error: 'File not created yet - do dbcreate' in phase 'Create File' while processing file CUPCENTCO." I've looked through the lawson manuals on dbdef and can't find the issue. No help on the knowledgebase either. Does anyone have any suggestions to help this Lawson rookie. :)