 |
|||||
|
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 |
| [CLOSED] MFD : Record Error | Login/Join |
| Gold member |
Is it possible bypass record on master description. Some records do not respect the MFD in my VSAM file but i don't know which ones it is. I want to continue reading other records. Is it possible ? ThanksThis message has been edited. Last edited by: Kerry, Webfocus 8.201M. Windows InfoAssist + Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH | ||
|
| Expert |
That may depend on whether you are using indexed or not. But my guess would be No Does this VSAM file have a record type ?, you may be able to have the different record types in different segments. Then you could get only one type of record. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Yes VSAM file to several segments Normally the format of the fields is defined, but it may happen that some records in the file does not respect the format. I would like to play it when the record meets the format and the record is not read when he does not follow the format. For the moment I made a conversion error and I can read the good records of the file. Section break problem which is not an index Webfocus 8.201M. Windows InfoAssist + Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH | |||
|
| Expert |
Does the record length change with the different records ? Could you define the field as text, then you may be able to do your filtering. What is the format of the field ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
the problem is fairly recent with master that worked for all records. We can not detect the incorrect records that causes this conversion error. The deed to pass the text field or alpha does not work. Heading is ACTUAL: P7 / USE: Z7 there is a filter on the topic GE value, can be that he will break problem .. Webfocus 8.201M. Windows InfoAssist + Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH | |||
|
| Virtuoso |
Last time I used VSAM was eons ago. This type of problem though was not uncommon. First, I think you mean USAGE=P7, ACTUAL=Z7. As Waz said this should get through as A7 for both. I cannot remember it all now but there was a U format that was useful, I think it would be used as USAGE=A14, ACTUAL=U7. U is for Unformatted and returns the Hex(?), hence the A14; has to be twice the actual. May still work. From that you may more easily find bad records. Takes time. Unfortunately I don't remember any easy approach to take when this happens, other than finding roughly where the error occurs, and just working in that area of data. Alan. WF 7.705/8.007 | |||
|
| Gold member |
Alan thank you for this clarification In fact I'll try to break records that target problem even though it may take time. It's a pity there is not a parameter that allows to pass a registration in case of misreading, but who knows in a future version can be ... Thanks Jacquetl Webfocus 8.201M. Windows InfoAssist + Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH | |||
|
| 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 |