 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| MFD Question | Login/Join |
| Guru |
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 | ||
|
| Master |
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  | |||
|
| Guru |
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 | |||
|
| Master |
What is your environment? Is this a extrace from a mainframe? | |||
|
| Expert |
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
-RUNWill 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
| |||||||||
|
| Guru |
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 | |||
|
| Expert |
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
| |||||||||
|
| Master |
Packdata on Mainframe vs Packdata on Unix are to different things. Sorry I do not have any suggestions for you. Scott | |||
|
| Guru |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |