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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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    Search    Search Results
Page 1 ... 5 6 7 8 9 10 11 12
Go
Search
Tools
Search Results: (227 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED]How to add an option to save the data as a pipe-delimited file ? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's an example of creating a hold file from the CAR table using the DFIX format. The first severa......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Conversion from A20V to YYQ (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Nice Waz ... a one line version ... TABLE FILE CAR PRINT COMPUTE TXT/A20V = '2015 Q1' ; COMPUTE YY......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] convert alphanumeric to numeric with thousands separator using a set command (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's another example using the CAR file and the -READFILE command ... maybe this is something of i......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] convert alphanumeric to numeric with thousands separator using a set command (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi ... I tried your example (using the CAR file) but the -TYPE statement didn't display anything .........
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Display two columns from field that has multiple entires (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Try this ... TABLE FILE XXXX SUM MAX.DESC_INFO MAX.RESOL_INFO BY REQUEST_TICKET END...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] passing multiple values from textarea to sql (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
And then this ... TABLE FILE CAR SUM DEALER_COST RETAIL_COST BY COUNTRY BY CAR WHERE COUNTRY ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] passing multiple values from textarea to sql (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Suzy Try this ... -DEFAULT &ITEM_LIST = '''ENGLAND'',''FRANCE'',''ITALY''';...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Possible to get an empty report? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, Try this ---> ON TABLE SET EMPTYREPORT ON Here is an example that created an empty file for me......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: ***CLOSED Easiest way to Convert a Date (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Example using the CAR file ... -* -TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date Calculations.. (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's one example to look at ... -* SET CURRENT DATE -SET &CUR_YYMD = &YYMD; -*-SET &CUR_YYMD = ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] DMYY to DMtYY using Dialog Manager commands (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
How about this ... -* DEFINE FILE CAR DATE1/DMtYY = '&DATEDMYY'; DATE2A/DMYY = '&DATEDMYY'; DATE2B/......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] DMYY to DMtYY using Dialog Manager commands (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Another way ... with your comma -SET &DATETXT2 = FPRINT(DATECVT(&YYMD,'I8YYMD','DMYY'),'DMtYY','A......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]How to change the date format from tDMYY to dd-mon-yyyy (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Maybe something like this ... -SET &CUR_DMYY = &DMYY; -*-SET &CUR_DMYY = 01092015; -SET &CUR_D34 ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] -IF THEN call a -SET command? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Another example using DECODE ... -* -DEFAULT &PORT_SUMRY_TYPE = 'Conforming'; -* -SET &NONCONFORMFL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] 7 last days from currently day (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's an example ... -* SET CURRENT DATE -SET &CUR_YYMD = &YYMD; -* -SET &BEG_YYMD = DATECVT((DAT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Error trying to code double quotes in text string (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Try this ... -SET &TST = '''Mary had a &|quot;little&|quot; lamb''';...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Error trying to code double quotes in text string (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
How about this? -* -SET &TST = '''Mary had a "little" lamb'''; -* -TYPE TST ---- &TST -EXIT...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] how to get year quarter in SET command (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's another example: -SET &YYMD = &YYMD; -SET &MY_YYQ = FPRINT(DATECVT(DATECVT(&YYMD,'I8YYMD',......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]How to read count(*) in the read command.... (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, Here's an example of counting the number of countries and cars from the CAR file and using -REA......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Percent change on subtotal (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Teri, Try using: ON REGION SUMMARIZE Instead of: ON REGION SUBTOTAL Let me know if that works....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 5 6 7 8 9 10 11 12 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders