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     [SOLVED](FOC262) UNBALANCED PARENTHESES

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED](FOC262) UNBALANCED PARENTHESES
 Login/Join
 
Gold member
posted
(FOC262) UNBALANCED PARENTHESES

Is there any other reason why this error is generated? I've made sure that I have the correct number of open and close parentheses.

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


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Expert
posted Hide Post
This most certainly only generated when there are unbalanced parentheses. Why not post your code? maybe we'll see something you missed...


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
It's quite a bit of code......

-* File aponte_help_desk_summary.fex
-INCLUDE ENVIRONMENT_SETTINGS
-*-INCLUDE COMMON_DATE_FMT_CONV
-*============================================================
-* Declaration of Variables
-*============================================================
-SET &ECHO = 'ALL';
SET BYDISPLAY = OFF
SET NODATA = 'N/A'
-DEFAULT &TIME_TYPE = 'FOC_NONE'
-DEFAULT &ST_DT = 'FOC_NONE'
-DEFAULT &END_DT = 'FOC_NONE'
-DEFAULT &OUTPUT = 'FOC_NONE'
-DEFAULT &CLOSE = 'FOC_NONE'
-DEFAULT &TIME_GRP = 'FOC_NONE'
-DEFAULT &MEAS_GRP = 'FOC_NONE'
-DEFAULT &LOCATION_DIVISION = 'FOC_NONE'
-DEFAULT &LOCATION_BOROUGH = 'FOC_NONE'
-DEFAULT &LOCATION_NETWORK_DEPT = 'FOC_NONE'
-DEFAULT &LOCATION_NAME = 'FOC_NONE'
-DEFAULT &METRIC_DT = 'FOC_NONE'
-*============================================================
-* Set Up for Measure Group
-*============================================================
-SET &TITLE1 = IF &TIME_GRP EQ 'GMONTH' THEN 'Month' ELSE '';
-SET &TITLE2 = IF &MEAS_GRP EQ 'LOCATION_DIVISION' THEN 'NYPL Sector' ELSE
- IF &MEAS_GRP EQ 'LOCATION_BOROUGH' THEN 'Borough' ELSE
- IF &MEAS_GRP EQ 'LOCATION_NETWORK_DEPT' THEN 'Network/Center' ELSE
- IF &MEAS_GRP EQ 'LOCATION_NAME' THEN 'Branch/Department' ELSE ' ';

-SET &G1 = &TIME_GRP.EVAL ;
-SET &G2 = &MEAS_GRP.EVAL ;
-RUN
-*===========================================================
-* Date/Notes Formatting
-*===========================================================
DEFINE FILE METRIC_DATA_REGISTRATIONS
GDATE/MDYY = HDATE(METRIC_DT, 'MDYY');
GYEAR/YY = GDATE;
DRILLMON/MYY = GDATE ;
GMONTH/MtYY = GDATE ;
GQUARTER/QYY = GDATE ;
-INCLUDE COMMON_RUNDATE_SET
END
-RUN
SET PRINTPLUS = ON
-*===========================================================
-* Generate Summary Report
-*===========================================================
TABLE FILE METRIC_DATA_REGISTRATIONS
ON TABLE SUBFOOT
" "
"Registrations - Summary <+0>"
"Date Range: <+0>&ST_DT To &END_DT"
"NYPL Sector: <+0>&LOCATION_DIVISION"
"Borough: <+0>&LOCATION_BOROUGH"
"Network/Dept:<+0>&LOCATION_NETWORK_DEPT"
"Branch/Unit: <+0>&LOCATION_NAME"
"Run Date/Time: "
-INCLUDE COMMON_PAGE_FOOTING
SUM
CURRENT_REGIST/P20C AS 'Current, Registrations'
-* PRIOR_REGIST/P20C AS 'Prior, Registrations'
-*===========================================================
-* Filter Conditions
-*===========================================================
METRIC_DT NOPRINT
BY &TIME_GRP.EVAL AS '&TITLE1'
-IF &MEAS_GRP EQ 'FOC_NONE' THEN GOTO SKPBYS ;
BY &MEAS_GRP.EVAL AS '&TITLE2'
-SKPBYS
-*
WHERE LOCATION_DIVISION EQ '&LOCATION_DIVISION';
WHERE LOCATION_BOROUGH EQ '&LOCATION_BOROUGH';
WHERE LOCATION_NETWORK_DEPT IN (&LOCATION_NETWORK_DEPT);
WHERE LOCATION_NAME IN (&LOCATION_NAME);
WHERE METRIC_DT FROM DT('&ST_DT') TO DT('&END_DT');
-*===========================================================
-* Stylesheet
-*===========================================================
-IF &OUTPUT NE 'PDF' THEN GOTO NO_HEAD ;
ON TABLE SUBHEAD
" "
-NO_HEAD
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE RECOMPUTE
ON TABLE PCHOLD FORMAT &OUTPUT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE COMMON_REPORT_STYLE
-*===========================================================
-IF &OUTPUT NE 'PDF' THEN GOTO REG_NOPDF ;
TYPE=TABHEADING, IMAGE=REGISTRATIONS.SVG, position=(0.05 0.05), SIZE=(11 4.5), $
-REG_NOPDF
-*===========================================================
-IF &OUTPUT EQ 'EXL2K' THEN GOTO NO_EXLDRL ;
TYPE=DATA,COLUMN=N1,FOCEXEC=REGISTRATIONS_DETAIL(G1='&G1' G2=&G2.QUOTEDSTRING SDATE=&TIME_GRP.EVAL SMEASURE=' ' DIV=&LOCATION_DIVISION.QUOTEDSTRING BORO=&LOCATION_BOROUGH.QUOTEDSTRING DEPT=&LOCATION_NETWORK_DEPT.QUOTEDSTRING BRANCH=&LOCATION_NAME.QUOTEDSTRING ST_DT='&ST_DT' END_DT='&END_DT' OUTPUT='&OUTPUT'),
TARGET='_BLANK',$
-IF &MEAS_GRP EQ 'FOC_NONE' THEN GOTO NO_MSDRL ;
TYPE=DATA,COLUMN=N2,FOCEXEC=REGISTRATIONS_DETAIL(G1='&G1' G2='&G2' SDATE=&TIME_GRP.EVAL SMEASURE=&MEAS_GRP.EVAL DIV=&LOCATION_DIVISION.QUOTEDSTRING BORO=&LOCATION_BOROUGH.QUOTEDSTRING DEPT=&LOCATION_NETWORK_DEPT.QUOTEDSTRING BRANCH=&LOCATION_NAME.QUOTEDSTRING ST_DT='&ST_DT' END_DT='&END_DT' OUTPUT='&OUTPUT'),
TARGET='_BLANK',$
-NO_MSDRL
-NO_EXLDRL
-*
-IF &OUTPUT NE 'EXL2K' THEN GOTO NOTXT ;
TYPE=REPORT, TITLETEXT='Summary', $
TYPE=REPORT, GRID=OFF, $
-NOTXT
ENDSTYLE
END
-RUN
-*
-IF &LINES GT 0 THEN GOTO SKP_MSG ;
-HTMLFORM NODATA
-SKP_MSG


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Gold member
posted Hide Post
quote:
PRIOR_REGIST/P20C AS 'Prior, Registrations'


Francis,
I get the error when I include the above line of code, when I comment it out it works, however, I need to SUM that field.


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Expert
posted Hide Post
Anything funny in the includes COMMON_RUNDATE_SET or COMMON_PAGE_FOOTING?


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Post the result of the ECHO - the execution of the code.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
What are the values in

WHERE LOCATION_NETWORK_DEPT IN (&LOCATION_NETWORK_DEPT);
WHERE LOCATION_NAME IN (&LOCATION_NAME);


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
It's quite possible the problem lies with the two drilldown lines - they're probably too long. Some WebFOCUS errors can be a bit misleading.

Try converting this:

TYPE=DATA,COLUMN=N1,FOCEXEC=REGISTRATIONS_DETAIL(G1='&G1' G2=&G2.QUOTEDSTRING SDATE=&TIME_GRP.EVAL SMEASURE=' ' DIV=&LOCATION_DIVISION.QUOTEDSTRING BORO=&LOCATION_BOROUGH.QUOTEDSTRING DEPT=&LOCATION_NETWORK_DEPT.QUOTEDSTRING BRANCH=&LOCATION_NAME.QUOTEDSTRING ST_DT='&ST_DT' END_DT='&END_DT' OUTPUT='&OUTPUT'),
TARGET='_BLANK',$

to this:

TYPE=DATA,COLUMN=N1,FOCEXEC=REGISTRATIONS_DETAIL( \
G1='&G1' \
G2=&G2.QUOTEDSTRING \
SDATE=&TIME_GRP.EVAL \
SMEASURE=' ' \
DIV=&LOCATION_DIVISION.QUOTEDSTRING \
BORO=&LOCATION_BOROUGH.QUOTEDSTRING \
DEPT=&LOCATION_NETWORK_DEPT.QUOTEDSTRING \
BRANCH=&LOCATION_NAME.QUOTEDSTRING \
ST_DT='&ST_DT' \
END_DT='&END_DT' \
OUTPUT='&OUTPUT'),
TARGET='_BLANK',$


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
The fact that commenting out that single line of code resolves the problem, indicates that you are probably activating a DEFINEd field which would otherwise be ignored. If you have an error in a defined field, but never use that field as a verb object, you will be able to see the error message, but it does not cause the request to crash because that field is never referenced in the TABLE request.

Is PRIOR_REGIST an actual database field or is it defined in some -INCLUDEd code or possibly in the Master File?

The only time you'll get the unbalanced parentheses error is when there actually are unbalanced parentheses. It may just be somewhere you are not looking - like one of those previously mentioned. If you use -SET &ECHO=ALL; and then look at the code you'll probably be able to see it. If not, then look in the master file.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
DMA, Using "SET &ECHO=ALL" as darin suggested will produce an output which will include the "(FOC" Error number and associated line number of the error which should lead you to you error. I'd like to see, as I'm sure darin would, the results of the &ECHO trace...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Platinum Member
posted Hide Post
WHERE LOCATION_NETWORK_DEPT IN (&LOCATION_NETWORK_DEPT);
WHERE LOCATION_NAME IN (&LOCATION_NAME);

Try this instead:
WHERE LOCATION_NETWORK_DEPT IN (&LOCATION_NETWORK_DEPT );
WHERE LOCATION_NAME IN (&LOCATION_NAME );
 
Posts: 140 | Location: Adelaide South Australia | Registered: October 27, 2006Report This Post
Gold member
posted Hide Post
Here is the ECHO with the error message.

--------------------------------------------------------------------------------

No HTML Output!

--------------------------------------------------------------------------------


SET BYDISPLAY = OFF
SET NODATA = 'N/A'
-DEFAULT &TIME_TYPE = 'FOC_NONE'
-DEFAULT &ST_DT = 'FOC_NONE'
-DEFAULT &END_DT = 'FOC_NONE'
-DEFAULT &OUTPUT = 'FOC_NONE'
-DEFAULT &CLOSE = 'FOC_NONE'
-DEFAULT &TIME_GRP = 'FOC_NONE'
-DEFAULT &MEAS_GRP = 'FOC_NONE'
-DEFAULT &LOCATION_DIVISION = 'FOC_NONE'
-DEFAULT &LOCATION_BOROUGH = 'FOC_NONE'
-DEFAULT &LOCATION_NETWORK_DEPT = 'FOC_NONE'
-DEFAULT &LOCATION_NAME = 'FOC_NONE'
-DEFAULT &METRIC_DT = 'FOC_NONE'
-*============================================================
-* Set Up for Measure Group
-*============================================================
-SET &TITLE1 = IF GMONTH EQ 'GMONTH' THEN 'Month' ELSE '';
-SET &TITLE2 = IF LOCATION_BOROUGH EQ 'LOCATION_DIVISION' THEN 'NYPL Sector' ELSE
- IF LOCATION_BOROUGH EQ 'LOCATION_BOROUGH' THEN 'Borough' ELSE
- IF LOCATION_BOROUGH EQ 'LOCATION_NETWORK_DEPT' THEN 'Network/Center' ELSE
- IF LOCATION_BOROUGH EQ 'LOCATION_NAME' THEN 'Branch/Department' ELSE ' ';
-SET &G1 = GMONTH ;
-SET &G2 = LOCATION_BOROUGH ;
-RUN
-*===========================================================
-* Date/Notes Formatting
-*===========================================================
DEFINE FILE METRIC_DATA_REGISTRATIONS
GDATE/MDYY = HDATE(METRIC_DT, 'MDYY');
GYEAR/YY = GDATE;
DRILLMON/MYY = GDATE ;
GMONTH/MtYY = GDATE ;
GQUARTER/QYY = GDATE ;
-INCLUDE COMMON_RUNDATE_SET
-* File common_rundate_set.fex
-*
CUR_DT_TM/HYYMDm = HGETC ( 10 , 'HYYMDm' ) ;
RUN_DTE_MDYY/A8MDYY = HDATE (CUR_DT_TM , 'YYMD' );
RUN_TIME/A12 = HHMMSS(RUN_TIME);
RUN_DT_TIME/A30 = EDIT(RUN_DTE_MDYY , '99/99/9999') | ' ' | RUN_TIME ;
END
-RUN
SET PRINTPLUS = ON
-*===========================================================
-* Generate Summary Report
-*===========================================================
TABLE FILE METRIC_DATA_REGISTRATIONS
ON TABLE SUBFOOT
" "
"Registrations - Summary <+0>"
"Date Range: <+0>07/01/2008 To 06/30/2009"
"NYPL Sector: <+0>Branch"
"Borough: <+0>Bronx"
"Network/Dept:<+0>BLC Network"
"Branch/Unit: <+0>AL"
"Run Date/Time: "
-INCLUDE COMMON_PAGE_FOOTING
-* File common_page_footing.fex
-DEFAULT &OUTPUT = 'HTML'
-IF HTML NE 'PDF' THEN GOTO NO_FOOT ;
-NO_FOOT
SUM
CURRENT_REGIST/P20C AS 'Current, Registrations'
PRIOR_REGIST/P20C AS 'Prior, Registrations'
-*===========================================================
-* Filter Conditions
-*===========================================================
METRIC_DT NOPRINT
BY GMONTH AS 'Month'
-IF LOCATION_BOROUGH EQ 'FOC_NONE' THEN GOTO SKPBYS ;
BY LOCATION_BOROUGH AS 'Borough'
-SKPBYS
-*
WHERE LOCATION_DIVISION IN (Branch);
WHERE LOCATION_BOROUGH IN (Bronx);
WHERE LOCATION_NETWORK_DEPT IN (BLC Network);
WHERE LOCATION_NAME IN (AL);
WHERE METRIC_DT FROM DT('07/01/2008') TO DT('06/30/2009');
-*===========================================================
-* Stylesheet
-*===========================================================
-IF HTML NE 'PDF' THEN GOTO NO_HEAD ;
-NO_HEAD
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE RECOMPUTE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE COMMON_REPORT_STYLE
-* File common_report_style.fex
-*************************************************************************************************************
-*Procedure Name: common_report_style.fex
-*Creation Date: June 04 2008
-*Author: Yogesh Patel
-*Description: This is a common report style sheet procedure, all common report style options should be
-* included in this procedure so it is easy to maintain and easy to make global style changes.
-*
-*************************************************************************************************************
-* Modification History:
-* Date Who Change Description
-* June 16, 2008 Joey Baloun Changed Arial to Verdana, to comply with NYPL standards
-*
-*------------------------------------------------------------------------------------------------------------
-*
-* Common Report Style settings --------------------------------------------
-SET &POS = IF HTML EQ 'PDF' THEN 1.5 ELSE 0 ;
-*
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
CALC-LOCATION=TOP,
MENU-LOCATION=COLUMN,
LEFTGAP=0.06, RIGHTGAP=0.06,
PAGESIZE='LEGAL',
LEFTMARGIN=0.280556,
RIGHTMARGIN=0.080556,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT, OBJECT=MENU,$
TYPE=REPORT, OBJECT=STATUS-AREA, JUSTIFY=CENTER, BACKCOLOR='WHITE',$
TYPE=REPORT, OBJECT=CURRENT-ROW,$
TYPE=REPORT, OBJECT=CALC-AREA, BACKCOLOR='WHITE',$
-* Common Title Style settings -----------------------------------------------
TYPE=TITLE, BACKCOLOR=RGB(205 205 220), STYLE=BOLD,$
-*TYPE=TITLE, JUSTIFY=RIGHT,$
-* Common Report Heading and Footing Style settings --------------------------
-*TYPE=TABHEADING, SIZE=9, FONT=ARIAL, HEADALIGN=BODY, BACKCOLOR=RGB(239 240 241),$
TYPE=TABHEADING, LINE=1, SIZE=10, OBJECT=TEXT, ITEM=1, COLSPAN=10, COLOR=BLUE, $
TYPE=TABHEADING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=3, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=3, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=4, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=4, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=5, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=5, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=6, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=6, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=7, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=7, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=8, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=8, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=9, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=9, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABHEADING, LINE=10, ITEM=1, COLSPAN=2, $
TYPE=TABHEADING, LINE=10, ITEM=2, COLSPAN=8, POSITION=0,$
-**Report Footing
TYPE=TABFOOTING, SIZE=9, FONT=VERDANA, HEADALIGN=BODY, BACKCOLOR=RGB(239 240 241),$
TYPE=TABFOOTING, LINE=1, ITEM=1, COLSPAN=10, BACKCOLOR=NONE,$
TYPE=TABFOOTING, LINE=2, ITEM=1, COLSPAN=10, SIZE=10, STYLE=BOLD, $
TYPE=TABFOOTING, LINE=3, OBJECT=TEXT, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=3, OBJECT=TEXT, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=4, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=4, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=5, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=5, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=6, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=6, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=7, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=7, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=8, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=8, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=9, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=9, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=10, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=10, ITEM=2, COLSPAN=8, POSITION=0,$
TYPE=TABFOOTING, LINE=10, ITEM=1, COLSPAN=2, $
TYPE=TABFOOTING, LINE=10, ITEM=2, COLSPAN=8, POSITION=0,$
-** Report Page Footing
TYPE=FOOTING, HEADALIGN=INTERNAL,$
TYPE=FOOTING, LINE=1, JUSTIFY=CENTER, BACKCOLOR=RGB(239 240 241), $
-* Common Report SubHeading and SubFooting Style settings --------------------------
TYPE=SUBHEAD, SIZE=8, STYLE=BOLD, BACKCOLOR=RGB(210 210 210), $
TYPE=SUBFOOT, SIZE=8, STYLE=BOLD, BACKCOLOR=RGB(210 210 210), $
-* Common Subtotal and Grandtotal Style settings -----------------------------------
TYPE=SUBTOTAL, BACKCOLOR=RGB(217 227 253), STYLE=BOLD,$
TYPE=GRANDTOTAL, BACKCOLOR=RGB(239 240 241), STYLE=BOLD,$
-* Common Report data Style settings -----------------------------------------------
TYPE=DATA, BACKCOLOR=(WHITE SILVER),$
-*
-*===========================================================
-IF HTML NE 'PDF' THEN GOTO REG_NOPDF ;
-REG_NOPDF
-*===========================================================
-IF HTML EQ 'EXL2K' THEN GOTO NO_EXLDRL ;
TYPE=DATA,COLUMN=N1,FOCEXEC=REGISTRATIONS_DETAIL(G1='GMONTH' G2='LOCATION_BOROUGH' SDATE=GMONTH SMEASURE=' ' DIV='Branch' BORO='Bronx' DEPT='BLC Network' BRANCH='AL' ST_DT='07/01/2008' END_DT='06/30/2009' OUTPUT='HTML'),
TARGET='_BLANK',$
-IF LOCATION_BOROUGH EQ 'FOC_NONE' THEN GOTO NO_MSDRL ;
TYPE=DATA,COLUMN=N2,FOCEXEC=REGISTRATIONS_DETAIL(G1='GMONTH' G2='LOCATION_BOROUGH' SDATE=GMONTH SMEASURE=LOCATION_BOROUGH DIV='Branch' BORO='Bronx' DEPT='BLC Network' BRANCH='AL' ST_DT='07/01/2008' END_DT='06/30/2009' OUTPUT='HTML'),
TARGET='_BLANK',$
-NO_MSDRL
-NO_EXLDRL
-*
-IF HTML NE 'EXL2K' THEN GOTO NOTXT ;
-NOTXT
ENDSTYLE
END
-RUN
0 ERROR AT OR NEAR LINE 63 IN PROCEDURE registrations_summ
(FOC262) UNBALANCED PARENTHESES
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
-*
-EXIT



Darin, PRIOR_REGIST is in fact a field in the table, it is not defined.


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Virtuoso
posted Hide Post
Does this line need the ' marks?
WHERE METRIC_DT FROM DT('07/01/2008') TO DT('06/30/2009');


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Expert
posted Hide Post
OPALTOSH, Why? The only difference is the space before that closnig ")", right? If so, WebFOCUS can handle that, right? Perhaps I'm missing something that you see and I don't?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
DMA,
1) Is "registrations_summ" the name of the fex that you are executing?
2) Can you verify that there are no PARENTHESES in the files that you are using your "WHERE X IN(&filename)" or in the &:variables used?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Virtuoso
posted Hide Post
quote:
WHERE LOCATION_DIVISION IN (Branch);
WHERE LOCATION_BOROUGH IN (Bronx);
WHERE LOCATION_NETWORK_DEPT IN (BLC Network);
WHERE LOCATION_NAME IN (AL);
WHERE METRIC_DT FROM DT('07/01/2008') TO DT('06/30/2009');



although I don't believe this is the cause of your error, I did notice some bad syntax. The first four WHERE statements must have single quote marks around the values inside the parentheses.

WHERE LOCATION_NETWORK_DEPT IN ('BLC Network');

In your last WHERE statement you use the DT operator but are not using a date-time value for comparison. What is the format of the METRIC_DT field?

Can you post your Master File for table METRIC_DATA_REGISTRATIONS? That might help answer your original question--


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Gold member
posted Hide Post
Darin, here is my master file for metric_data_registrations:

FILENAME=METRIC_DATA_REGISTRATIONS, SUFFIX=SQLMSS , $
SEGMENT=METRIC_DATA_REGISTRATIONS, SEGTYPE=S0, $
FIELDNAME=LOCATION_SYMBOL, ALIAS=location_symbol, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=CURRENT_REGIST, ALIAS=current_regist, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=MONTH, ALIAS=month, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=FY, ALIAS=FY, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=LOCATION_NAME, ALIAS=location_name, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=LOCATION_BOROUGH, ALIAS=location_borough, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=LOCATION_NETWORK_DEPT, ALIAS=location_network_dept, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=LOCATION_DIVISION, ALIAS=location_division, USAGE=A255V, ACTUAL=A255V,
MISSING=ON, $
FIELDNAME=LOCATION_ID, ALIAS=location_id, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=METRIC_DT, ALIAS=metric_dt, USAGE=HYYMDI, ACTUAL=HYYMDI,
MISSING=ON, $
FIELDNAME=PRIOR_REGIST, ALIAS=prior_regist, USAGE=A255V, ACTUAL=D8,
MISSING=ON, $


Thanks,
Denise


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Virtuoso
posted Hide Post
quote:
FIELDNAME=PRIOR_REGIST, ALIAS=prior_regist, USAGE=A255V, ACTUAL=D8,
MISSING=ON, $


Anyone know if this is valid? I don't think you can have and Actual format of D8 and a usage of A255.

From the manual:

For most data sources, you can change the type and length specifications of USAGE only to other types and lengths valid for that field's ACTUAL attribute. You can change display options at any time.

Which means that you can't have a numeric actual format and an alphanumeric display format.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Gold member
posted Hide Post
Darin,

It in fact was the USAGE. I changed it to be the same as CURRENT_REGIST (D20.2) and it works now. I wasn't the one who created the SQL table so I wasn't aware.

Thanks everyone for your help!

Denise


WebFOCUS v. 7.6.8 || Windows XP || Format Output: HTML, PDF, EXCEL
 
Posts: 57 | Location: NYC | Registered: November 13, 2008Report This Post
Virtuoso
posted Hide Post
That's really strange that that's what was giving you the unbalanced parentheses error, but at least we found the problem!


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 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     [SOLVED](FOC262) UNBALANCED PARENTHESES

Copyright © 1996-2020 Information Builders