 |
|||||
|
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point What do you think about WebFocus 7 ???
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point What do you think about WebFocus 7 ???Page 1 2
Read-Only TopicGo | Search | Notify | Tools |
| What do you think about WebFocus 7 ??? | Login/Join |
| Virtuoso |
If WebFocus truncates trailing blanks at SAVE time, and -READ fails to deal correctly with the resulting variable-length records, then it's a bug. - Jack Gross WF through 8.1.05 | |||
|
| Expert |
j.g. I would agree if the recordlength was variable. In my users case though, the output is fixed length. In 5.3.2 this file was read line by line even though the actual recordlength was 12 and it was being read in as A20. T
| |||||||||
|
| Virtuoso |
Still a bug, in my view: -READ is supposed to read a single row, so it should never return data from the file's next record, regardless of the platform and file format. How it should react when you attempt to read past the boundary is a separate issue. - Jack Gross WF through 8.1.05 | |||
|
| Platinum Member |
Not to throw a wrench into this discussion, but this is not new behavior. I can't swear to the behavior of any given recent WebFOCUS release, but I first encountered this behavior in the mid 80's. I am unaware of any release in which -READ would do anything other than grab the next record if your cumulative field length exceeded the actual record length. It may be bug, but if so it's one ancient insect. dwf | |||
|
| Expert |
JG, I agree that it was good fortune and precisely why I raise the point. Most "gotcha"s are due to loose coding that could easily be prevented. It has happened before and will happen again. Hopefully, raising awareness will reduce occurences in Forum's member's code. DWF, It seems that with every new release of WF (or FOCUS for the old coders among us) the behaviour swings back and forth. I remember having to go through some code just before the year 2000 for a previous Client in the process of upgrading, where there were a few "loose" coding methods employed that just happened to function in the previous release. Kept me off the streets though and made a break from coding around date problems  Incidently, the DB2 VARCHAR also affects MS SQL Server, so thanks. T
| |||||||||
|
| Virtuoso |
We are now testing 7.1.4...anyone have any problems joining a Focus File to an Oracle Table? We are getting back 0 records. It works in 5.3.4.This message has been edited. Last edited by: Prarie,
| |||||
|
| Expert |
Have hit a problem today in Dev Studio creating synonyms. I normally use the console but just for once decided to use Dev Studio tool (7.1.3). Opened up the app where we hold all synonyms and right clicked in the right hand window, selected New and Synonym and a dialogue box opened informing connection to the server was being achieved. So I sat and waited. And waited And waited And waited Eventually a dialogue showing that the connection to the server had been reset! Checking known problems and it appears that this one hit the product in 7.1 something but is fixed in 7.1.4 of Dev Studio. Question is, does anyone have 7.1.4 Dev Studio and does this work? I'm planning on downloading DS 7.1.4 and trying it, but in the meantime if someone knows for sure that the problem is fixed ...... I would appreciate knowing. Meanwhile, it's back to the console ....... T
| |||||||||
|
| Gold member |
Hey reFOCUSing, now I don't need Alt F4  Using: WF 7.1.5, XP Pro, Tomcat, Self Serve | |||
|
| Gold member |
Now that 7.1.4 is out I wonder if anyone is having issues? Using: WF 7.1.5, XP Pro, Tomcat, Self Serve | |||
|
| Virtuoso |
Yes....read 3 posts back. If the Oracle table is the Host...it works...if it is the guest...it returns no data. As stated..this Join has been production 5.3.4 for months.
| |||||
|
| Expert |
Prarie, Sounds like a call to TS and urgent fix from the product team is in order! T
| |||||||||
|
| Virtuoso |
Yep...that has been done....waiting...
| |||||
|
| Expert |
A bit like me trying to create a synonym in Dev Studio then 
| |||||||||
|
| Expert |
Have downloaded and installed DS 7.1.4 and the create synonym problem is still apparent  . I feel a TS case coming .......T
| |||||||||
|
| Guru |
Another example of code tightening.... The UPCASE routine must be used against a field with the exact number of characters or nothing will be returned to FOCUS. Ex: In this case LESSEE was an Alpha 60 and nothing gets returned. ULESSEE/A30=UPCASE(30, LESSEE , 'A30'); When I added a DEFINE to make LESSEE an Alpha 30, data was returned. Just common sense, but an FYI.... Carol
| |||||
|
| Virtuoso |
I've read a little about Graph Problems..anyone come across any? Also our issue with Oracle joins has been defined as a "bug" and IBI is researching.
| |||||
|
| Member |
I have an idea, but would like a bit more information: Prairie (JOINing Oracle and FOCUS files) - what are the formats of the 'FROM' and 'TO' field, as specified in the MFDs? Yo can do a '?FF filename' at a command prompt, to get fields with formats) Carol Dobson (UPCASE needs exact number of chatacters) - also, I need to know the format of the field from the MFD. I tried: TABLE FILE CAR PRINT COUNTRY ON TABLE HOLD END DEFINE FILE HOLD XX/A5 = UPCASE(5,COUNTRY,'A5'); END TABLE FILE HOLD PRINT COUNTRY XX END Which worked as expected. | |||
|
| Virtuoso |
Fields are both A32. The Oracle table is the guest . There is a case open for it.
| |||||
|
| Powered by Social Strata | Page 1 2 |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point What do you think about WebFocus 7 ???
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point What do you think about WebFocus 7 ???Copyright © 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 |