how to change AnV to An and remove hold space, test data as follow:

Version: WEBFOCUS 8.2 utf8

TEST FILE:
CREATE TABLE WEBFOCUS_TEST (
FIELD1 CHAR(3),
FIELD2 VARCHAR(10),
FIELD3 INT
)
TEST DATA:
INSERT INTO WEBFOCUS_TEST(FIELD1, FIELD2, FIELD3 ) VALUES('AA','BBB',123)

mas:
FILENAME=WEBFOCUS_TEST, SUFFIX=SQLSYB , $
SEGMENT=WEBFOCUS_TEST, SEGTYPE=S0, $
FIELDNAME=FIELD1, ALIAS=FIELD1, USAGE=A3V, ACTUAL=A3B, $
FIELDNAME=FIELD2, ALIAS=FIELD2, USAGE=A10V, ACTUAL=A10VB, $
FIELDNAME=FIELD3, ALIAS=FIELD3, USAGE=I11, ACTUAL=I4, $

This message has been edited. Last edited by: FP Mod Chuck,

Hi Selina,

Just change the USAGE format in the synonym from A3V to A3 etc. Do not change the ACTUAL though.

T