(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,

This most certainly only generated when there are unbalanced parentheses. Why not post your code? maybe we'll see something you missed...

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

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.

Anything funny in the includes COMMON_RUNDATE_SET or COMMON_PAGE_FOOTING?

Post the result of the ECHO - the execution of the code.

What are the values in

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

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',$

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.

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...

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 );

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

Does this line need the ' marks?
WHERE METRIC_DT FROM DT('07/01/2008') TO DT('06/30/2009');

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?

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?

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--

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

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.

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

That's really strange that that's what was giving you the unbalanced parentheses error, but at least we found the problem!