Focal Point
[SOLVED] Filedef problem

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4907081776

July 10, 2015, 01:45 PM
krhapner
[SOLVED] Filedef problem
I am using FILEDEF to read a file in, and it works just fine .. except I am reading in items that are 10 characters long (Ex: SF12345678) AND when I run it, it only captures 9 of the characters (Ex: SF1234567). Can a FILEDEF only read in a certain amount of characters? Any ideas?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 02:04 PM
MartinY
Look at your master file and fields definition (TABLE FILE ...), it may not be as defined as your thought, 'cause I do use it and read more than 10 characters.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 10, 2015, 02:28 PM
krhapner
It is defined as 'A10,' this is not the problem.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 02:30 PM
krhapner
I am reading in an outside file.. I am reading in a list of ID's.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 02:57 PM
Tom Flynn
APP FILEDEF DDNAME DISK DRIVE:/FOLDER/FOLDER/FILENAME.TXT (RECFM F LRECL 10

OR

APP FILEDEF DDNAME DISK DRIVE:/FOLDER/FOLDER/ FILENAME.TXT (RECFM V LRECL 10

Whichever works...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 10, 2015, 03:05 PM
krhapner
It didn't work. The first one gave an error and the second one ran but I am having the same problem.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 03:11 PM
Tom Flynn
Probably something wrong with the Master, or, the file itself...
do
WHENCE MASTERNAME MASTER
-EXIT

and make sure it's the right one and in the right folder.
We do this all the time...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 10, 2015, 03:15 PM
krhapner
I am not sure if I understand what you are talking about. I am reading in an ftm file that is in my P: Drive. It contains a list of 10-digit/character ID numbers. It is not from any master file, but I can use these ID numbers to compare to another table with the same ID numbers to say... print out a first name that matches the ID number.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 03:17 PM
Tom Flynn
If you are using FILEDEF, then the DDNAME is the Master name.


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 10, 2015, 03:18 PM
krhapner
Right, but it is one that I, myself, create when I run the report.. not an actual one that already exists.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 03:19 PM
krhapner
I have run many reports using the filedef and know how to use it, but this one is doing something odd and not reading in the full value.


WebFOCUS 8
Windows, All Outputs
July 10, 2015, 03:29 PM
krhapner
Figured it out. - Thanks


WebFOCUS 8
Windows, All Outputs
July 12, 2015, 06:12 PM
Waz
What was the issue ?

It may help others in the future.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!