I am trying to retrieve data from our ODS Database and hold it as XML.
This is a copy of the error

-GOTO L_EXIT ;
-L_EXIT
SET GRAPHSERVURL=http://xxxxx.xxxxxxx.xxx:xxxx/ibi_apps/IBIGraphServlet
SET GRAPHENGINE=GRAPH53
-INCLUDE mrheader
-* mr header include start
-* mr as NOT html
-SET &FOCEXURL=/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=baseapp ods_common ods_student plus_sis sql_student& | '&' | 'IBIMR_drill=X,studentx/studentx.htm' | '&';
-OLAP ON
SET FOCEXURL='/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&IBIAPP_app=baseapp ods_common ods_student plus_sis sql_student&&IBIMR_drill=X,studentx/studentx.htm&'
-OLAP OFF
-* mr header include end
-*
-INCLUDE ADHOCRQ
TABLE FILE ODSST_COURSE_CATALOG
PRINT
SUBJECT
SUBJECT_DESC
COURSE_NUMBER
TITLE_LONG_DESC
COURSE_TEXT_NARRATIVE
BY COURSE_IDENTIFICATION
HEADING
""
FOOTING
""
WHERE ACADEMIC_YEAR_DESC EQ '2009-2010';
WHERE RECORDLIMIT EQ 100
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD FORMAT XML
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
0 NUMBER OF RECORDS IN TABLE= 100 LINES= 100
0 ERROR AT OR NEAR LINE 29 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:



I cannot figure out where I am going wrong with this one.

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

quote:

(FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:

I think that is pretty clear. Comment out the text field and see if it works. If yes, then you'll have to convert your text field to an alpha.