Focal Point
MFD Question

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

September 22, 2006, 02:29 PM
Glenda
MFD Question
What would the format of the field be for
Usage?
Actual?

If the data looks like:
0000000194D
0000007993F
0000008133H
0000001490G
0000000124D
0000008009D
0000025946C
0000000110{

The programmer knows nothing about WebFOCUS and is not much help. But she was nice enough to tell me that it was "s9(09)v99".

My experience with MFDs is hit or miss. Any pointers out there?


Glenda

In FOCUS Since 1990
Production 8.2 Windows
September 22, 2006, 05:01 PM
TexasStingray
Actual = Z11
Usage = P13.2

If you have access to the support site after you login here is a usful url

http://documentation.informationbuilders.com/masterinde...2/cobolfd/02cfd8.htm

Hope this helps.




Scott

September 22, 2006, 05:12 PM
Glenda
I have already tried that. It's the wackiest thing I've seen in a while. I've tried just about every combination I can think of.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
September 22, 2006, 05:49 PM
TexasStingray
What is your environment? Is this a extrace from a mainframe?
September 25, 2006, 08:57 AM
Tony A
Glenda,

The formats that TexasStingray has given should do the trick -
APP FI Glenda DISK Glenda.MAS
-RUN
-WRITE Glenda
-WRITE Glenda FILE=Glenda,SUFFIX=FIX
-WRITE Glenda SEGNAME=SEG1
-WRITE Glenda FIELD=WHATFMT,,P13.2,Z11,$
-RUN

APP FI Glenda DISK Glenda.FTM
-RUN
-WRITE Glenda 0000000194D
-WRITE Glenda 0000007993F
-WRITE Glenda 0000008133H
-WRITE Glenda 0000001490G
-WRITE Glenda 0000000124D
-WRITE Glenda 0000008009D
-WRITE Glenda 0000025946C
-WRITE Glenda 0000000110{
-RUN

TABLE FILE Glenda
PRINT *
END
-RUN


Will result in the output of 
WHATFMT 
19.44 
799.36 
813.38 
149.07 
12.44 
800.94 
2594.63 
11.00


Unless the data values you have given in your post are hexadecimal values and not alpha (11 chars)?

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
September 25, 2006, 02:46 PM
Glenda
This is an extract from the mainframe. According to the programmer responsible for the file, it is defined as alpha.

My enviroment is UNIX.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
September 25, 2006, 03:29 PM
Tony A
Hi Glenda,

If the format is alpha and they are 11 chars in length then the suggestion from TexasStingray is the one you need. I suppose another possibility is that the column positioning is misaligned? e.g. counting the previous columns character positions gives 112 but the data starts at 113?

The platform should be inconsequential if the format is fixed.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
September 28, 2006, 10:10 AM
TexasStingray
Packdata on Mainframe vs Packdata on Unix are to different things. Sorry I do not have any suggestions for you.




Scott

September 28, 2006, 10:22 AM
Glenda
I have found out that if any of the fields in a file to be moved from the mainframe to ASCII have any of the following 3 types of data, it must be run through NetConvert before FTP'ing in order for the values to come across correctly.

1. Packed - PIC 9(9) comp-3.
2. Binary - PIC 9(9) comp.
3. Signed zoned decimal - PIC S9(9). (if a zoned decimal field is not signed (ie, PIC 9(9)) then it does NOT need NetConvert)

My problem was not with the MFD after all. Thanks for all your input.


Glenda

In FOCUS Since 1990
Production 8.2 Windows