Focal Point Banner


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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums    Search    Search Results
Page 1 2 3 4 5 6 
Go
Search
Tools
Search Results: (115 matches) New Search Login/Join 

Discussion Topic  RE: Displaying footer with empty report? (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I believe that what Carol meant was to use something like the Car file and then hardcode the same re......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Align Fields in Reports (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Try using over TABLE FILE FILENAME PRINT Field1 Field3 Field4 OVER Field2 Field5 OVER Field6 Fiel......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Regd: Focus database extraction (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I do not know what Focus counts as a record when a heirachical multipathed Focus database is used. S......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Record Length Exceeded (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
The error message text by issuing a ? 765 is: > > ? 765 (FOC765) WARNING. LOGICAL RECORD LENGTH EXC......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Strange FIXFORM and DECIMAL ERRORS, then fine (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
No idea about the first error but for the second error ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: SET All=PASS Not Working (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Have you looked at my example using the car file I posted earlier? I tried to emulate what I thought......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: SET All=PASS Not Working (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I tried to create an example using the car file. Hope this helps. -*CREATE A FOCUS DATABASE DEFIN......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: SET All=PASS Not Working (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I believe that there is a misunderstanding as to what SET ALL = PASS means. In general, using your f......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Suppressing *TOTAL in sub total (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I'm on an old mainframe release 7.11 not to confused with Webfocus. It may be a new feature coming t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Suppressing *TOTAL in sub total (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I think that subtotal is not a option with the "on table" phrase. TABLE FILE CAR SUM SALES BY COUNT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: is there a REVERSE function in 7 that reads a string backwards? (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
What about GETTOK? This code: DEFINE FILE CAR LSTTOK/A12=GETTOK(MODEL,24,-1,' ',12,'A12'); END TABL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Getting the count of records during table request (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I would suggest the use of &lines and not &records as &records is usually the number of records pars......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: comparing and combining files (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
You want to use old-or-new. Old-and-new is like an inner join and you would get only those that are ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: comparing and combining files (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
How about using match file? This would eliminate your step2 (extra hold file) and having to join the......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Oracle SQLpass thru (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Just a thought. I have not encountered this message so this is just a guess. I think the error mess......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: where exactly the row or column total value resides (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I assume you want to perform calculations on subtotal values (defined or otherwise). If this assumpt......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: To have percentage % for the total generated in the report (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Here is an example using the car file. TABLE FILE CAR PRINT DEALER_COST SALES BY CAR UNDER-LINE SUB......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: looking for a way to produce reports verticaly not horizontally (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
I'm not quite sure what you need here so this is just my guess of what you mean by reporting vertica......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Show Column Title Each Time Group Changes (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Just shut off the default column titles and create your own like this. This would work for a text re......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Strange behaviour with SUBTOTAL (in WebFOCUS/FOCUS Forum on Focal Point ) by ET
Taking out the field references in the on phrase also works (at leasst on MVS 7.11). TABLE FILE CAR......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 5 6  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders