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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to continue the focus statement in the next line???

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to continue the focus statement in the next line???
 Login/Join
 
Silver Member
posted
Hi all
I get error stating continuation mismatch when i continue typing the continuation statement in the next line.

Do any one help me out how to continue writing a statements continuation in the next line.

I am using FOCUS 7.1 & 7.6.

I get this error in 7.1, please help me out.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Virtuoso
posted Hide Post
would you be so kind to post an example?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
Are you sure that you are using the syntax as stated in the manual?

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, 2004Report This Post
Virtuoso
posted Hide Post
RB,

Is the statement Dialog Manager? DEFINE? TABLE? MODIFY?

As Frank said, post the code and the error number. When you post the code be sure to put it between code tags (the last icon on the Message ribbon).


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Virtuoso
posted Hide Post
A code example would be helpful indeed.
There are at least two areas in which continuation on the next line might be a bit tricky.
The first is in stylesheets, when defining a drilldown. If you're in the part where the parameters are being defined, you need to continue to the next line using a \ character.
The other area is Dialog manager. There you will need to start your continuation line with a dash and a space (so '- ') otherwise things will go awry.

Hope this helps ...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Silver Member
posted Hide Post
Hi all
Thanks for your reply.
Here is the code.


Example:

EX TBRMLS2 DIV='08,09,11,12,13,14,18,1A,
1B,1C,1D,1E,1L,1M','1N,1O,1P,1Q',
The second line is the continuation of the first line.

How to make the line continuous? Is there any syntax to make a line continuously following the previous line??

What is the continuation syntax tobe used for the above code?

Please help me out.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Virtuoso
posted Hide Post
RB,

quote:
EX TBRMLS2 DIV='08,09,11,12,13,14,18,1A,
1B,1C,1D,1E,1L,1M','1N,1O,1P,1Q',


Please note that you have one parameter DIV then one value which start with '08 and finishes with 1M' on another line. Then you have a second parameter (nameless so it is assigned to &1 in your focexec) which starts with '1N and ends with 1Q'. Then you have a comma which announces a third parameter but nothing appears.
So, you have many problems.
What do you want to assign to DIV? If everything put all the values on one line between quotes. If not, then define more parameters. In anycase do not leave a dangling comma.
I hope this helps.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Virtuoso
posted Hide Post
RB,

Tested this with the following code:
EX TESTPASS DIV='01,02,03,04,05,06,07,08,09,11,12,13,14,15,16,17,18,1A,1B,1C,1D,
1E,1L,1M',
1='1N,1O,1P,1Q',
2='this is just something to see what happens'

and it just works fine wihout any error in my environment.
It may be of course that core focus 7.3 reacts a little bit different, I ran it on webfocus 713 on os/390. Anyway, the continuation of these commands is, as you did, to put a comma at the end of the line. This should allow you to continue on to the next line.

Hope this helps...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Platinum Member
posted Hide Post
ok dangling comma is a no no. next is your inbtent to have hive &div contain 14 values, while &1 contain only 4? try placing all 14 on line enclosed in quotes, and &1 on a separate line with the 4 values enclsoed in quotes.
g'luck. Ira

wf 537 aix 533


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
I would suggest setting an amper variable first.
-SET &DIV='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1L,1M,1N,1O,1P,1Q' ;
EX TBRMLS2 DIV=&DIV,
{other vars}

This way you can set your parms as long as FOCUS lets you.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Silver Member
posted Hide Post
thanks for all your reply
but the problems does not end here,

Code:
OFFLINE CLOSE
DYNAM FREE FILE OFFLINE
DYNAM ALLOC FILE OFFLINE DATASET TBR.TEST.TFOCUS2.TODEC.TBRMLS04 OLD
-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q;
-SET &DIV2=,1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O;
-SET &DIV3=,42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67;
-SET &DIV4=,7Q,RA,SA,SB,SC,SD';
EX TBRMLS2 DIV=&DIV1,&DIV2,&DIV3,&DIV4

This is what i have done, but i get error stating


ERROR AT OR NEAR LINE 34 IN PROCEDURE TBRMLS FOCEXEC
(FOC285) SUBSTITUTED LINE IN FOCEXEC TRUNCATED: EX TBRMLS2
DIV=&DIV1,&DIV2,&DIV3,&DIV4

Please help me out.

Thanks.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Silver Member
posted Hide Post
HI ALL
PROBLEM IS SOLVED

HERE IS THE SOLUTION

-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q
- ,1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O
- ,42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67
- ,7Q,RA,SA,SB,SC,SD';

IS THERE ANY OTHER WAY TO USE THE CONTINUATION OF A LINE (EXACTLY THE SYNTAX)???

THANKS


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Virtuoso
posted Hide Post
This might work

-SET &ECHO=ALL;
-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q';
-SET &DIV2=',1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O'; 
-SET &DIV3=',42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67'; 
-SET &DIV4=',7Q,RA,SA,SB,SC,SD'; 
-SET &DIV5='&DIV1.EVAL|&DIV2.EVAL|&DIV3.EVAL|&DIV4.EVAL';
-TYPE &DIV5




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Silver Member
posted Hide Post
HI FRANK,

WHEN I USE YOUR CODE I GET THE BELOW ERROR,

-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q';
-SET &DIV2=',1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O';
-SET &DIV3=',42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67';
-SET &DIV4=',7Q,RA,SA,SB,SC,SD';
ERROR AT OR NEAR LINE 35 IN PROCEDURE TBRMLS FOCEXEC
(FOC285) SUBSTITUTED LINE IN FOCEXEC TRUNCATED: -SET
&DIV5='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q|,1R,1S,1
,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O||&DIV4.EVAL';
ERROR AT OR NEAR LINE 35 IN PROCEDURE TBRMLS FOCEXEC
(FOC285) SUBSTITUTED LINE IN FOCEXEC TRUNCATED: -SET
&DIV5='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q|,1R,1S,1
,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O|,42,44,46,47,48,4Q,|';
-SET &DIV5='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q|,1R,1S,1T,1
ERROR AT OR NEAR LINE 36 IN PROCEDURE TBRMLS FOCEXEC
(FOC257) MISSING QUOTE MARKS: '08,09,11,12,13,14,1


HOW TO SOLVE THIS??
PLEASE HELP.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Silver Member
posted Hide Post
HI ALL

THE VALUE FOR THE DIV IS SUBSTITUTED WITH THE VALUE 08 ALONE OTHER VALUES ARE BEING OMITTED...
WHY THIS THING HAPPENS...


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Virtuoso
posted Hide Post
RB,

This what I ran without any problem:
  
-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q'; 
-SET &DIV2=',1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O'; 
-SET &DIV3=',42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67'; 
-SET &DIV4=',7Q,RA,SA,SB,SC,SD'; 
-SET &DIV5=&DIV1 || &DIV2 || &DIV3 || &DIV4;
-TYPE &DIV5


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Platinum Member
posted Hide Post
RB4U - Investigating the manual would be beneficial to you. How how to continue a line in dm for a &var is:

-SET &DIV1 = X,Y,Z,A,B,C
- D,E,F,G,H,I,J,K';
NOTICE: I placed a closing quote before the semi colon (you must have matching quotes!)
if you want more than 2 lines just make sure that each subsequent line starts off with a hyphen followed by a space. When you are all done enter a ';'
and as Danny suggested. do a -type after your
-set and a -run to insure that part of the code works before going on.
ira
aix 533 wf 537/533 windows (76)


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
How about this

-SET &DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q'
- |',1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O'
- |',42,44,46,47,48,4Q,4R,51,52,53,54,58,61,63,67'
- |',7Q,RA,SA,SB,SC,SD';

This message has been edited. Last edited by: Waz,


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Silver Member
posted Hide Post
Hi all
I tried all sort of code what u all have specified but still i get error FOC285/FOC281/FOC303 etc.
I didnot get the solution till now.

The following code is used and executed fine in FOCUS 7.6.4 but thros error stating the continuation problem in FOCUS 7.1.1.

OFFLINE CLOSE
DYNAM FREE FILE OFFLINE
DYNAM ALLOC FILE OFFLINE DATASET TBR.TODEC.TBRMLS04 OLD
EX TBRMLS2,
DIV='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q',
DIV2='1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O,42,44,46,47,48',
DIV3='4Q,4R,51,52,53,54,58,61,63,67,7Q,RA,SA,SB,SC,SD'
-RUN
-*


Please help me out to solve this problem

Thanks.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
Virtuoso
posted Hide Post
I do not know what TBRMLS2 does, but if that FEX has some amper fields that need to be filled by the numbers you adress on the next line I suppose you should add "&" before the "DIV" and you end your line 5 and 6 with a comma.

I would recommend to read all the previous made comments.
Try them all on a simplified example (with CAR) and if that does not work show us the complete code.
And Please!!!! put your codes between [ code] and [ /code] so it is readable.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
RB,

Could you please create a new focexec, call it MYTRY in which you have:
  
-SET &ECHO=ALL;
-SET &DIV=&DIV1 || &DIV2 || &DIV3;
-TYPE &DIV

Then run it as follows:
  
EX MYTRY DIV1='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q,', 
DIV2='1R,1S,1T,1U,22,30,31,33,37,38,3A,3H,3L,3M,3N,3O,42,44,46,47,48,',
DIV3='4Q,4R,51,52,53,54,58,61,63,67,7Q,RA,SA,SB,SC,SD' 

If you still get the same error messages, post the output of the echo.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Expert
posted Hide Post
Are these two lines or one and is there a space between TBRMLS2 and the comma ?

quote:
EX TBRMLS2,
DIV='08,09,11,12,13,14,18,1A,1B,1C,1D,1E,1F,1L,1M,1N,1O,1P,1Q',


The syntax should be
 EX FEX VAR=val, etc 


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
-SET &DIV1 = 'X,Y,Z,A,B,C,
- D,E,F,G,
- H,I,J,K';
-TYPE The value for DIV1 is: &DIV1

single quote before the 1st value and before the semi-colon.
any line following the original should have a - in column 1 or 2 followed by a space for each continued line.

Ira
aix533 wf 537


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Silver Member
posted Hide Post
hi all
thanks for all your reply, the error got solved by all your help.
Thanks,
Revathi.


Focus Core 7.1.1 & 7.6.4
XP
MainFrames
 
Posts: 38 | Registered: November 20, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to continue the focus statement in the next line???

Copyright © 1996-2020 Information Builders