Anyone else annoyed by the difference between the results of CREATE SYNONYM and REFRESH SYNONYM?

CREATE SYNONYM

SEGNAME=BASEL_AC_APPL_FORM,
TABLENAME=BASEL.AC_APPL_FORM,
CONNECTION=BSL,
KEYS=1
,$

FILE=BASEL_AC_APPL_FORM, SUFFIX=DB2     ,$
SEGNAME=BASEL_AC_APPL_FORM,
SEGTYPE=S0 ,$
FIELD=APPL_DIM_KEY                        ,APPL_DIM_KEY,
I11         ,I4          ,MISSING=OFF,$
FIELD=AC_PROP_INS_CD                      ,AC_PROP_INS_CD,
A10         ,A10         ,MISSING=OFF,$
FIELD=CNTRY_PROV_STAT_ID                  ,CNTRY_PROV_STAT_ID,
I11         ,I4          ,MISSING=OFF,$

REFRESH SYNONYM

 SEGNAME=BASEL_AC_APPL_FORM, TABLENAME=BASEL.AC_APPL_FORM, CONNECTION=BSL,
   KEYS=1, $

FILENAME=BASEL_AC_APPL_FORM, SUFFIX=DB2     , $
  SEGMENT=BASEL_AC_APPL_FORM, SEGTYPE=S0, $
    FIELDNAME=APPL_DIM_KEY, ALIAS=APPL_DIM_KEY, USAGE=I11, ACTUAL=I4, $
    FIELDNAME=AC_PROP_INS_CD, ALIAS=AC_PROP_INS_CD, USAGE=A10, ACTUAL=A10, $
    FIELDNAME=CNTRY_PROV_STAT_ID, ALIAS=CNTRY_PROV_STAT_ID, USAGE=I11, ACTUAL=I4, $

Francis,

Refeshing a synonym via the console in 7.1.3 retains modifications. A good move, especially when you have "statndard" requirements for particular column descriptions.

T

The annoyance is not actually with any modifications I may have made, it is with the fact that different code is generated by the two commands. E.G. one puts the table columns in one line and the other uses multiple lines. One uses FILE, SEGNAME, FIELD, the other uses FILENAME, SEGMENT, FIELDNAME.

Cheers.

Is this done to one synonym at a time or can it be done to all of them at the same time? Refreshing, that is.

Thanks!

On the 5.3.3 server it appears you have to do them one at a time.