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.
In Define statement, i am concatinating certain fields as below
O KEY1/A17 = OI.CD|SA.CD|BIT.CD|ISSUE.ST.CD|FNO|STD.PRV.IND|KEY.ACCT.IND
I need to add few more fields but there is no space left on this line, so i need to use next line. How can i continue adding concatenating variables in next line. Is there any continuation symbol for these cases?This message has been edited. Last edited by: Rajiv Garg,
Try KEY1/A17 = OI.CD|SA.CD|BIT.CD|ISSUE.ST.CD|FNO|STD.PRV.IND|KEY.ACCT.IND; KEY1 = KEY1 | OI.PPPP | OI.QQQQ; Remember there is a limit based upon the defined size of your variable.
You have to have a size for the defined field that is big enough to hold all the concatenated fields. In Stefanns example the second KEY1 does not have a size.
WF 8.2.01M 8.2.01M Reporting Server Windows 2012 Srvr R2 PDF,Excel, HTML Graphs - a lot of graphs
Posts: 60 | Location: Atlanta, GA | Registered: October 30, 2003
Originally posted by Alan B: Stefaans - Won't work...
An expression ends with a ';' or an END in a DEFINE
Alan, one assumes that the gentleman knows that you have to have the DEFINE FILE XXXX my code in between and then the END statement. Unless I have made a typo that I do not know about, the code should work. s
Originally posted by mrguru: You have to have a size for the defined field that is big enough to hold all the concatenated fields. In Stefanns example the second KEY1 does not have a size.
Hi I would remind you that by adding a size to the second KEY will re-define the field. THIS IS A NO NO. All that you are doing is concatenating onto the original field. Trust me it works,
I guess what mrguru is implying is that the second KEY1 without a format will be trying to fit KEY1(A17) + OI.PPPP(A?) + OI.QQQQ(A?) into a format of A17. Even if the two additional fields were A1 then the total size being fitted into the second KEY1 would be A19 and an error should be encountered.
Jimmy's should work OK across several lines on mainframe.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004
Francis, you are totally correct on this one, but I think that Rajiv's question was related to the fact that he is dealing with a FOCEXEC that is either on and MVS or VM box where FOCEXEC's can only have a logical record length of 80 chars. If I understand him correctly he wanted to know how he could do this with via a continuation method. Just my thoughts. Perhaps I am wrong. Regards Steve Simon
Stefaans, I understood what Rajiv's question was related to. You don't need a continuation character and you never have a problem with FOCUS or WebFOCUS code where there is a limitation of 80 character lines. The only time there might be a problem is when a field name is longer than 80 characters, even then, you can just type 80 characters and FOCUS will figure out the complete field name, unless there are two or more field names where the first 80 characters are the same!
This is a complete non-issue.
Regards.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server