V field problem and solution

August 21, 2008, 11:44 AM

Had a problem with running a report and summing amounts by the Source Id field. Values in the field where not being separated but where being combined.

The problem was with the master file description and the usage format for the field.

Original field definition
FIELDNAME=SOURCE_ID, ALIAS=SOURCE_ID, USAGE=A15V, ACTUAL=A15V, $

New field definition
FIELDNAME=SOURCE_ID, ALIAS=SOURCE_ID, USAGE=A15, ACTUAL=A15V, $

Removal of the V option from the usage format corrected the problem.

Is this a BUG and is this documentated?

August 21, 2008, 12:05 PM

Prarie

Jay,
if you will do a search on VARCHAR on the forum....there are many discussions on this topic.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

August 21, 2008, 12:45 PM

Kamesh

SET VARCHAR=OFF

I believe this should solve your issue.

WFConsultant

WF 8105M on Win7/Tomcat

August 21, 2008, 02:14 PM

GinnyJakes

Set VARCHAR OFF has to be done by data base engine, for instance SQL SQLORA SET VARCHAR OFF.

Then the master file description has to be regenerated.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google