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 2 3 4 5 6 
Go
Search
Tools
Search Results: (106 matches) New Search Login/Join 

Discussion Topic  RE: Date conversion [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Awesome, works like a charm. Thanks for your help!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Date conversion [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Francis, thanks, this 'kind of' works. It does give me the desired format, but: You have a hardcod......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Date conversion [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Thanks jfr99, but it looks like your inputs are in a different format than mine. Here's what I have......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Date conversion [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I used the following formula to convert the timestamp to this format: 1 Sep, 2010 VAL_DT_DISP/DMt......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Date conversion [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I have gotten a timestamp to convert to the following format: 1 Sep, 10 Now, I want to convert thi......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] PDF Layout Tool (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I have a text column that has "Series I Related Credits Outstanding" in it. If I use JUSTIFY=CENTER......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Inserting a variable into SQL (in iWay Software Product Forum on Focal Point) by Ted Michalski
When I convert to alpha, it will do the -READ and insert into the table, but I get an erroneous numb......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Inserting a variable into SQL (in iWay Software Product Forum on Focal Point) by Ted Michalski
It appears that the format in the read (D18.2C) is causing the problem. But, I have to insert this ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Inserting a variable into SQL (in iWay Software Product Forum on Focal Point) by Ted Michalski
Thanks for the response ABT, but when I execute this code, I get: (FOC339) DIALOGUE MANAGER -READ F......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  Inserting a variable into SQL (in iWay Software Product Forum on Focal Point) by Ted Michalski
I have the following code: TABLE FILE XXX PRINT A B COMPUTE C/D18.2C = A - B ; ON TABLE SE......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: SQL Object - insert statement (in iWay Software Product Forum on Focal Point) by Ted Michalski
I'm using this syntax: INSERT INTO table1(a,b) values('A','B') But, if I have a numeric variable t......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: Creating a timestamp [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I change it to YYMD. We are writing these timestamps to Sql Server to use in a future report....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Creating a timestamp [Resolved] (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I can get the first and last day of the current month with this code: DEFINE FILE DATE CURR_DATE/YY......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] SQL INSERT command (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Oh, I thought that WF would think I was trying to put literally "&MONTH" into the text field. Thans......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] SQL INSERT command (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Thanks Francis. I tried this also and it gave me the same error: -SET &MONTH = EDIT(&DATEMtDwY,'99......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] SQL INSERT command (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
On the same subject, I have the following code: -SET &MONTH = EDIT(&DATEMtDwY,'999$-$$$99'); (which......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date in Title (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Thanks GamP. works great. Looks like I'm going to have to cough up the 25 bucks and buy that date ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Date in Title (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Waz, which one of these formats will return this exact format: Sep-10...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Current Month (resolved) (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
I've searched this forum high and low and can't seem to find a formula that will extract the month n......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] hOW CAN WE GET THE CURRENT TIME? (in WebFOCUS/FOCUS Forum on Focal Point ) by Ted Michalski
Thanks GamP. works great....
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