Hello,

I am trying to read a text file that has records in it.

When I go to run the FEX I get no errors but do get "0 records in table".

I know there are records in the table and I have no filtering in the FEX.

Any Help.

Dan

This message has been edited. Last edited by: moyer1dl,

Hi, Dan.

This should be fairly easy to solve. Do you have an APP FI in the program to point to the data? If you don't have an APP FI in the fex, does the master have a DATASET parameter in it? Does your master file description for your text file actually match the data? Where is the MFD in relation to the location of your fex?

Please give us the answers to these questions. If the answers are not sufficiently enlightening, we might need to see the fex, master, and a bit of data but I don't think we need that right now.

I made a test fex. Here it is:

-* File uwreven.fex

FILEDEF PPINFEX2 DISK "C:\DOCUMENTS AND SETTINGS\DMOYER\DESKTOP\PPINFEXT.DAT"
TABLE FILE PPINFEX2
PRINT
Compname
Policynmbr
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL

Here is the part of the master:

FILE=PPINFEX2, SUFFIX=FIX
SEGNAME=ROOT_SEG, SEGTYPE=S1, $
FIELD=Compname, ALIAS=F1, USAGE=A7, ACTUAL=A7, $
FIELD=Policynmbr, ALIAS=F2, USAGE=A9, ACTUAL=A9, $

Are you running this locally, i.e on your PC with your reporting server on your PC? You say you are on the mainframe. If that is so, then your file needs to be on the mainframe.

Do a CHECK FILE PPINFEX2 and make sure that the number of bytes returned matches the record length of each row.

Do a ? FILEDEF to make sure that it is pointing to the right place.

When I do a File Def

I get this

Lname Device Lrecl Recfm Append Filename
============================================================


but no output

This is a flat file and I am working with it in windows. I have also tried placing the file in my developer studio project area. The file matches the record length in the master

This message has been edited. Last edited by: moyer1dl,

I have done a simple repro:

- Created a file in the same place.
- Created a master to describe it.
- Wrote a focexec to read it.

-* File textdoc.fex
FILEDEF TEXTDOC DISK "C:\Documents and Settings\c758760\Desktop\textdoc.dat"
? FILEDEF
TABLE FILE TEXTDOC
PRINT *
END

Master:

FILE=TEXTDOC, SUFFIX=FIX
SEGNAME=ROOT_SEG, SEGTYPE=S0, $
FIELD=TEXTLINE, ALIAS=F1, USAGE=A80, ACTUAL=A80, $

Output of the FILEDEF:

Lname Device Lrecl Recfm Append Filename
============================================================
TEXTDOC DISK 0 V C:\Documents and Settings\userid\Desktop\textdoc.dat

Output of report:

PAGE 1

TEXTLINE
Sample Text File

It bothers me that you have nothing coming back from the ? FILEDEF. I think that is where you need to focus your efforts. Try making the filename mixed/lower case. If that doesn't work, move the file to approot and try it from there, changing the filedef to correspond.

You didn't mention whether you ran the CHECK FILE and what the results were. But your primary concern at this point in the filedef. That is why you are not getting any rows. Even if the master was off-column, you'd get data but it would look finny.

The record length checked out ok.

When you say move to Approot do you mean in my project area?

If you are using Developer Studio to access local data, then both the Project area and the Data Servers area point to the same place on your hard drive, drive:\ibi\apps\dirname.

I don't think that is your problem though since I was able to get it to work by putting the file in the same place you did.

Gosh, I wish I could see what you are doing. This should be so simple. We are missing something really tiny.

Try throwing in a -RUN after the FILEDEF command. If that doesn't do it, try adding a DATASET declaration in your master file to specify the location of your data. Seems to be finding the master file OK. Ginny is right - it's got to be something easy that's missing.

quote:

Originally posted by moyer1dl:
I made a test fex. Here it is:

-* File uwreven.fex

FILEDEF PPINFEX2 DISK "C:\DOCUMENTS AND SETTINGS\DMOYER\DESKTOP\PPINFEXT.DAT"
TABLE FILE PPINFEX2
PRINT
Compname
Policynmbr
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL

Here is the part of the master:

FILE=PPINFEX2, SUFFIX=FIX
SEGNAME=ROOT_SEG, SEGTYPE=S1, $
FIELD=Compname, ALIAS=F1, USAGE=A7, ACTUAL=A7, $
FIELD=Policynmbr, ALIAS=F2, USAGE=A9, ACTUAL=A9, $

Your master file and data file names(PPINFEXT.DAT, PPINFEX2.mas) are different , they should be the same so webfocus engine can find the datafile from specified location in filedef.

OK,

I moved this project to the localhost environment and it worked and picked up the file on my computer.

The only thing is how can I run this from my project area on the EDA server? I would like it to be available to more poeple than just me. Do I need to put the file somewhere else?

Thanks

Dan

You need to move the file to the reporting server platform. That is the only way EDASERVE will be able to find it.

This is what I suspected all along, re this previous comment:

quote:

Are you running this locally, i.e on your PC with your reporting server on your PC? You say you are on the mainframe. If that is so, then your file needs to be on the mainframe.

quote:

Your master file and data file names(PPINFEXT.DAT, PPINFEX2.mas) are different , they should be the same so webfocus engine can find the datafile from specified location in filedef.

Yogesh the fact that the master and data file have different names is not an issue when using FILEDEF

The whole point of FILEDEF, AP FI and DYNAM ALLOC is to assign a logical name to a physical file.

In the case of relational tables the master does not need to be the same name as the physical table
because the physical files db and table/view name are maintained in the access file.

In the case of a FOCUS or XFOCUS database the master name does not have to match the physical database
name as the logical name can be assigned with a USE statement.

quote:

Originally posted by GinnyJakes:
You need to move the file to the reporting server platform. That is the only way EDASERVE will be able to find it.

This is what I suspected all along, re this previous comment:

quote:

Are you running this locally, i.e on your PC with your reporting server on your PC? You say you are on the mainframe. If that is so, then your file needs to be on the mainframe.

When you say the reporting server platform how does that translate geographically from my view in Dev Studio.

I can probably hit this file when it is on the Mainframe, but the file name changes every month and Id rather export it off the mainframe and report off of it in the windows envrinment.

quote:

FILEDEF PPINFEX2 DISK "C:\DOCUMENTS AND SETTINGS\DMOYER\DESKTOP\PPINFEXT.DAT"

When running the fex in Dev Studio, it's going to look at the C: drive of the server that Dev Studio is running on.

Either you can move the file into your project or somewhere on the same server as Dev Studio or you can use the APP MAP command to map to another server. (but not the c: drive)

Good Luck!

Thanks