I am having problems diplaying the fields from a master file I created that contains XML (CLOB Fields). I can get the account ID to display but the XML fileds will not display Can you see what I am missing?

-* File ArchivedInvestmentReview.fex
-DEFAULTS &OUT_STYLE = 0
SET ALL=ON
SET NODATA=' '
SET ASNAMES=ON
SET EMPTYREPORT=ON
-******************************
-*
-*
-******************************

-*DETERMINE IF PDF OR EXCEL
-IF &OUT_STYLE EQ 0 GOTO PDF;
-IF &OUT_STYLE EQ 1 GOTO EXCEL;


-PDF
TABLE FILE ACCOUNTS_ARCHIVE
PRINT
ACCOUNTNAME
INVESTMENTOFFICER
BY ACCOUNT_ID NOPRINT
WHERE ACCOUNT_ID = '00-0000-00'
AND YEAR = '2006'
HEADING
" "
" Archive Report"
" "
"Account: " "
ON TABLE SET PAGE-NUM OFF
-*ON TABLE HOLD AS OUTFILE FORMAT PDF
ON TABLE PCHOLD FORMAT PDF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='LETTER', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON,
ORIENTATION=LANDSCAPE,$
TYPE=REPORT, FONT='TIMES NEW ROMAN', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE',
STYLE=NORMAL,$
TYPE=HEADING, STYLE=BOLD,$
ENDSTYLE
END

Master File with merged XML fileds:
FILE=ACCOUNTS_ARCHIVE, SUFFIX=DB2 ,$
SEGNAME=ACCOUNTS_ARCHIVE, SEGTYPE=S0 ,$
FIELD=YEAR,YEAR,I6,I2,MISSING=OFF,$
FIELD=ACCOUNT_ID,ACCOUNT_ID,A12,A12,MISSING=OFF,$
FIELD=IO_CODE,IO_CODE,I6,I4,MISSING=ON ,$
FIELD=REVIEW, REVIEW, TX50 ,TX ,MISSING=ON ,$
FIELD=REJECTED,REJECTED,A3,A3,MISSING=ON ,$
FIELD=ASSETS_ARCHIVE,ASSETS_ARCHIVE,TX50,TX,MISSING=ON ,$
FIELD=CREATED_BY,CREATED_BY,A50,A50,MISSING=OFF,$
FIELD=LAST_MODIFIED_BY,LAST_MODIFIED_BY,A50,A50,MISSING=OFF,$
FIELD=CREATION_DATE,CREATION_DATE,HYYMDm,HYYMDm,MISSING=OFF,$
FIELD=LAST_MODIFIED_DATE,LAST_MODIFIED_DATE,HYYMDm,HYYMDm,MISSING=OFF,$
SEGMENT=REVIEW, SEGTYPE=S0, POSITION=REVIEW, PARENT=ACCOUNTS_ARCHIVE, SEGSUF=XML, $
FIELDNAME=REVIEW, ALIAS='Review', USAGE=A1, ACTUAL=A1, $
FIELDNAME=ACCOUNTID, ALIAS='AccountId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=ACCOUNTNAME, ALIAS='AccountName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTOFFICER, ALIAS='InvestmentOfficer', USAGE=A50, ACTUAL=A50, $
FIELDNAME=APPROVERDODE, ALIAS='ApproverCode', USAGE=I6, ACTUAL=I2, $
FIELDNAME=CONTROLGROUP, ALIAS='ControlGroupCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=CONTROLGROUPNAME, ALIAS='ControlGroupname', USAGE=A50, ACTUAL=A50, $
FIELDNAME=MAJORACCOUNTNAME, ALIAS='MajorAccountName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=MINORACCOUNTNAME, ALIAS='MinorAccountName', USAGE=A50, ACTUAL=A50,$
FIELDNAME=CAPACITY, ALIAS='Capacity', USAGE=A30, ACTUAL=A30, $
FIELDNAME=MANAGED, ALIAS='Managed', USAGE=A3, ACTUAL=A3, $
FIELDNAME=INVESTMENTOBJECTIVEDATE, ALIAS='InvestmentObjectDate', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTOBJECTIVECODE, ALIAS='InvestmentObjectiveCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=INVESTMENTOBJECTIVENAME, ALIAS='InvestmentObjectiveName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTAUTHORITYCODE, ALIAS='InvestmentAuthorityCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=APPROVEDDATE, ALIAS='ApprovedDate', USAGE=YYMD, ACTUAL=DATE, $
FIELDNAME=INVESTMENTAUTHORITYNAME, ALIAS='InvestmentAuthorityName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTMODEID, ALIAS='InvestmentModeId', USAGE=A12, ACTUAL=A12,$
FIELDNAME=DUEDATE, ALIAS='DueDate', USAGE=YYMD, ACTUAL=DATE, $
FIELDNAME=EXCEPTION1DESC, ALIAS='Exception1Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION1RESULT, ALIAS='Exception1Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION2DESC, ALIAS='Exception2Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION2RESULT, ALIAS='Exception2Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION3DESC, ALIAS='Exception3Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION3RESULT, ALIAS='Exception3Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION4DESC, ALIAS='Exception4Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION4RESULT, ALIAS='Exception4Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION5DESC, ALIAS='Exception5Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION5RESULT, ALIAS='Exception5Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION6DESC, ALIAS='Exception6Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION6RESULT, ALIAS='Exception6Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION7DESC, ALIAS='Exception7Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION7RESULT, ALIAS='Exception7Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION8DESC, ALIAS='Exception8Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION8RESULT, ALIAS='Exception8Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION9DESC, ALIAS='Exception9Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION9RESULT, ALIAS='Exception9Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION10DESC, ALIAS='Exception10Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION10RESULT, ALIAS='Exception10Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION11DESC, ALIAS='Exception11Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION11RESULT, ALIAS='Exception11Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION12DESC, ALIAS='Exception12Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION12RESULT, ALIAS='Exception12Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION13DESC, ALIAS='Exception13Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION13RESULT, ALIAS='Exception13Result', USAGE=A10, ACTUAL=A10,$
SEGMENT=ASSETS_ARCHIVE, SEGTYPE=S0, POSITION=ASSETS_ARCHIVE, PARENT=ACCOUNTS_ARCHIVE, SEGSUF=XML, $
FIELDNAME=ASSETS_ARCHIVE, ALIAS='AssetsArchive', USAGE=A1, ACTUAL=A1, $
FIELDNAME=ACCOUNTID, ALIAS='AccountId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=ACCOUNTMARKETVALUE, ALIAS='AccountMarketVal', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=CUSIPID, ALIAS='CusipId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=SECURITYDESCRIPTION, ALIAS='SecurityDescription', USAGE=A50, ACTUAL=A50, $
FIELDNAME=SHARES, ALIAS='Shares', USAGE=P20.4, ACTUAL=P10, $
FIELDNAME=MARKETVALUE, ALIAS='MarketValue', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=COSTVALUE, ALIAS='CostValue', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=MARKETPERCENTAGE, ALIAS='MarketPercentage', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=ASSETMINORTYPE, ALIAS='AssetMinorType', USAGE=A50, ACTUAL=A50, $
FIELDNAME=RATING, ALIAS='Rating', USAGE=A20, ACTUAL=A20, $
Let me know if you need more info.
Thanks
Jim Bowe

Jim
Prod: WebFOCUS 7.6.5 CGI - Self Service - AIX 5.2 - IBM DB2 V9
Env 3 Local: DevStudio 7.6.5 Servlet - Self Service - MS Windows XP SP2 - Output: HTML, Excel 2000 and PDF

Jim,

WebFOCUS does not support CLOB fields. HOWEVER, it will still get the information out of it. I'm not sure what issue you are having with the XML content but you can get away with declaring a field in the MFD as an Annnn if you know that the CLOB contents are always less than roughly 3900 characters. If it contains more, then declare it as a TX field and it will get the entire contents.

You may also want to fix your post so we can see all your code. Select the DISABLE HTML TAGS option at the bottom.

Check the format that the MFD contains, is it Annnn or TXnn.

It's possible that the XML is being retrieved but suppressed by the output type. If you change the output to PDF do you see the actual data?

Sorry about the bad post. As you can see the REVIEW and AESSTS_ARCHIVE are set to TX50.
Here is the MFD:
FILE=ACCOUNTS_ARCHIVE, SUFFIX=DB2 ,$
SEGNAME=ACCOUNTS_ARCHIVE, SEGTYPE=S0 ,$
FIELD=YEAR,YEAR,I6,I2,MISSING=OFF,$
FIELD=ACCOUNT_ID,ACCOUNT_ID,A12,A12,MISSING=OFF,$
FIELD=IO_CODE,IO_CODE,I6,I4,MISSING=ON ,$
FIELD=REVIEW, REVIEW, TX50 ,TX ,MISSING=ON ,$
FIELD=REJECTED,REJECTED,A3,A3,MISSING=ON ,$
FIELD=ASSETS_ARCHIVE,ASSETS_ARCHIVE,TX50,TX,MISSING=ON ,$
FIELD=CREATED_BY,CREATED_BY,A50,A50,MISSING=OFF,$
FIELD=LAST_MODIFIED_BY,LAST_MODIFIED_BY,A50,A50,MISSING=OFF,$
FIELD=CREATION_DATE,CREATION_DATE,HYYMDm,HYYMDm,MISSING=OFF,$
FIELD=LAST_MODIFIED_DATE,LAST_MODIFIED_DATE,HYYMDm,HYYMDm,MISSING=OFF,$
SEGMENT=REVIEW, SEGTYPE=S0, POSITION=REVIEW, PARENT=ACCOUNTS_ARCHIVE, SEGSUF=XML, $
FIELDNAME=REVIEW, ALIAS='Review', USAGE=A1, ACTUAL=A1, $
FIELDNAME=ACCOUNTID, ALIAS='AccountId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=ACCOUNTNAME, ALIAS='AccountName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTOFFICER, ALIAS='InvestmentOfficer', USAGE=A50, ACTUAL=A50, $
FIELDNAME=APPROVERDODE, ALIAS='ApproverCode', USAGE=I6, ACTUAL=I2, $
FIELDNAME=CONTROLGROUP, ALIAS='ControlGroupCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=CONTROLGROUPNAME, ALIAS='ControlGroupname', USAGE=A50, ACTUAL=A50, $
FIELDNAME=MAJORACCOUNTNAME, ALIAS='MajorAccountName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=MINORACCOUNTNAME, ALIAS='MinorAccountName', USAGE=A50, ACTUAL=A50,$
FIELDNAME=CAPACITY, ALIAS='Capacity', USAGE=A30, ACTUAL=A30, $
FIELDNAME=MANAGED, ALIAS='Managed', USAGE=A3, ACTUAL=A3, $
FIELDNAME=INVESTMENTOBJECTIVEDATE, ALIAS='InvestmentObjectDate', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTOBJECTIVECODE, ALIAS='InvestmentObjectiveCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=INVESTMENTOBJECTIVENAME, ALIAS='InvestmentObjectiveName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTAUTHORITYCODE, ALIAS='InvestmentAuthorityCode', USAGE=I6, ACTUAL=I4, $
FIELDNAME=APPROVEDDATE, ALIAS='ApprovedDate', USAGE=YYMD, ACTUAL=DATE, $
FIELDNAME=INVESTMENTAUTHORITYNAME, ALIAS='InvestmentAuthorityName', USAGE=A50, ACTUAL=A50, $
FIELDNAME=INVESTMENTMODEID, ALIAS='InvestmentModeId', USAGE=A12, ACTUAL=A12,$
FIELDNAME=DUEDATE, ALIAS='DueDate', USAGE=YYMD, ACTUAL=DATE, $
FIELDNAME=EXCEPTION1DESC, ALIAS='Exception1Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION1RESULT, ALIAS='Exception1Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION2DESC, ALIAS='Exception2Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION2RESULT, ALIAS='Exception2Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION3DESC, ALIAS='Exception3Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION3RESULT, ALIAS='Exception3Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION4DESC, ALIAS='Exception4Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION4RESULT, ALIAS='Exception4Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION5DESC, ALIAS='Exception5Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION5RESULT, ALIAS='Exception5Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION6DESC, ALIAS='Exception6Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION6RESULT, ALIAS='Exception6Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION7DESC, ALIAS='Exception7Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION7RESULT, ALIAS='Exception7Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION8DESC, ALIAS='Exception8Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION8RESULT, ALIAS='Exception8Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION9DESC, ALIAS='Exception9Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION9RESULT, ALIAS='Exception9Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION10DESC, ALIAS='Exception10Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION10RESULT, ALIAS='Exception10Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION11DESC, ALIAS='Exception11Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION11RESULT, ALIAS='Exception11Result', USAGE=A10, ACTUAL=A10, $
FIELDNAME=EXCEPTION12DESC, ALIAS='Exception12Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION12RESULT, ALIAS='Exception12Result', USAGE=A10, ACTUAL=A10,$
FIELDNAME=EXCEPTION13DESC, ALIAS='Exception13Desc', USAGE=A255, ACTUAL=A255, $
FIELDNAME=EXCEPTION13RESULT, ALIAS='Exception13Result', USAGE=A10, ACTUAL=A10,$
SEGMENT=ASSETS_ARCHIVE, SEGTYPE=S0, POSITION=ASSETS_ARCHIVE, PARENT=ACCOUNTS_ARCHIVE, SEGSUF=XML, $
FIELDNAME=ASSETS_ARCHIVE, ALIAS='AssetsArchive', USAGE=A1, ACTUAL=A1, $
FIELDNAME=ACCOUNTID, ALIAS='AccountId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=ACCOUNTMARKETVALUE, ALIAS='AccountMarketVal', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=CUSIPID, ALIAS='CusipId', USAGE=A12, ACTUAL=A12, $
FIELDNAME=SECURITYDESCRIPTION, ALIAS='SecurityDescription', USAGE=A50, ACTUAL=A50, $
FIELDNAME=SHARES, ALIAS='Shares', USAGE=P20.4, ACTUAL=P10, $
FIELDNAME=MARKETVALUE, ALIAS='MarketValue', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=COSTVALUE, ALIAS='CostValue', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=MARKETPERCENTAGE, ALIAS='MarketPercentage', USAGE=P20.2, ACTUAL=P10, $
FIELDNAME=ASSETMINORTYPE, ALIAS='AssetMinorType', USAGE=A50, ACTUAL=A50, $
FIELDNAME=RATING, ALIAS='Rating', USAGE=A20, ACTUAL=A20, $

I have not had to deal with a CLOB with XML in it so I am just going to take a guess. Try changing the TX50 to TX256 and see what happens.

That's the best guess I have. Sorry.

I had the same problem, just change the TX50 to A700 forteh Actual and Usage and it should work

I tried changing from TX50 to TX700 but recieved a format error. I then changed it to TX256 and the report ran but it still does not display the XML fields.
Here is a sample of the XML in the REVIEW field of the table:

< !--XML file created with STYLEVISION version 2004 rel. 4 [http://www.xmlspy.com) by Gireesh Nair-->


00-0000-00
XXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXX, JR
000
00
0000000000000000000 PORTFOLIOS
AGENCY SERVICES
AGENT FOR FIDUCIARY
INVESTMENT MANAGER
Yes
MARCH 2006
00
xxxxxxxxxxxxxxxxxxxxx PORTFOLIO
00
10-10-2006
XXXXXXXXXXXXXXXXXX AUTHORITY
22MAPBGPIBO
2006-12-20

Does the account hold any fixed income securities that are not investment grade?
N/A


Does the account hold any Wells Fargo & Co. securities?
PASS


Does the account have a greater than 10% concentration in any single equity/fixed income asset?
N/A


Does the account hold any unique assets?
N/A


Does the MAP account hold individual equity securities?
PASS


Does the account hold any individual equity security with a current market value below 20% of original purchase price?
N/A


Is any one equity industry above 15%?
N/A


Does the account hold any outside asset not allowed in the MAP Standard portfolio?
PASS



Is the growth percentage greater than that allowed for this standard MAP account?
PASS


Is there any cash sweep vehicle that is > 15% of the total market value?
PASS


Does the account hold any uninvested cash?
PASS


Is the percentage of asset holdings appropriate based on the Investment Objective?
N/A


Does the account have an Investment Objectives on file greater than three years old?
PASS