Hi,

I need to alter the master file field format length. The .mas file is having like below format ,

The file name is EPL.MAS

 
$File EPL.MAS
$*****  PL Table  *****
FILENAME=EPL, SUFFIX=XFOCUS  , FDEFCENT=20, $
  SEGMENT=EPL_S1, SEGTYPE=S5, $
    FIELDNAME=NTW, ALIAS=NTW_TYPE, USAGE=A6, FIELDTYPE=I,
      TITLE='NTW Type', DESCRIPTION='NET_TYPE', $
    FIELDNAME=PLF, ALIAS=PLF_TYPE, USAGE=A6, FIELDTYPE=I,
      TITLE='PLF Type', DESCRIPTION='PLF', $
    FIELDNAME=NTP, ALIAS=ND_TYPE, USAGE=A6, FIELDTYPE=I,
      TITLE='ND Type', DESCRIPTION='ND_TYPE', $
    FIELDNAME=CCD, ALIAS=CNTCODE, USAGE=A6, FIELDTYPE=I,
      TITLE='CNT', DESCRIPTION='CNT', $
    FIELDNAME=CST, ALIAS=CST, USAGE=A6, FIELDTYPE=I,
      TITLE='CST', DESCRIPTION='CST', $
    FIELDNAME=S1_DMY, ALIAS=EPL_S1_DMY, USAGE=A1,
      TITLE='DMY Not used', DESCRIPTION='DMY', $
  SEGMENT=EPL_S2, SEGTYPE=S1, PARENT=EPL_S1, $
    FIELDNAME=PID, ALIAS=PL_ID, USAGE=I4, FIELDTYPE=I,
      TITLE='PL Id', DESCRIPTION='PL_ID', $
    FIELDNAME=PL, ALIAS=PL_NAME, USAGE=A24,
      TITLE='PL Name', DESCRIPTION='PL_NAME', $
    FIELDNAME=EOC, ALIAS=E_F_C, USAGE=YYMD,
      TITLE='E F C', DESCRIPTION='E_F_C', $
    FIELDNAME=NRD, ALIAS=N_R_D, USAGE=I4,
      TITLE='NERED', DESCRIPTION='N_R_D', $
    FIELDNAME=CDT, ALIAS=CRDT, USAGE=YYMD,
      TITLE='CTD DT', DESCRIPTION='CRDT', $
    FIELDNAME=CTM, ALIAS=C_TM, USAGE=I6L,
      TITLE='CTD TM', DESCRIPTION='C_TM', $
    FIELDNAME=CREA, ALIAS=CRTR, USAGE=A8,
      TITLE='CRTR', DESCRIPTION='CRTR', $
  SEGMENT=EPL_S3, SEGTYPE=S1, PARENT=EPL_S2, $
    FIELDNAME=ACN, ALIAS=ACND, USAGE=I6, FIELDTYPE=I,
      TITLE='Actual ND', DESCRIPTION='ACND', $
    FIELDNAME=DAT, ALIAS=ACT_DAT, USAGE=YYMD,
      TITLE='Act Dat', DESCRIPTION='ACT_DAT', $
  SEGMENT=EPL_S4, SEGTYPE=S1, PARENT=EPL_S2, $
    FIELDNAME=UNO, ALIAS=U_NO, USAGE=I4,
      TITLE='U No', DESCRIPTION='U_NO', $
    FIELDNAME=H_ND, ALIAS=H_ND, USAGE=I6, FIELDTYPE=I,
      TITLE='His ND Id', DESCRIPTION='HIS_ND', $
    FIELDNAME=H_NM, ALIAS=H_NM, USAGE=A16,
      TITLE='His ND Nm', DESCRIPTION='              ', $
    FIELDNAME=CHDA, ALIAS=CNG_DA, USAGE=YYMD,
      TITLE='Cng Da', DESCRIPTION='CNG_DA', $
    FIELDNAME=CHTM, ALIAS=CH_TM, USAGE=I6L,
      TITLE='Ch Tm', DESCRIPTION='CH_TM', $
    FIELDNAME=UID, ALIAS=USRID, USAGE=A8,
      TITLE='Usr Id', DESCRIPTION='USR_ID', $
    FIELDNAME=AC, ALIAS=ACNION, USAGE=A15,
      TITLE='ACNion', DESCRIPTION='ACNION', $
    FIELDNAME=H_NR, ALIAS=H_NR, USAGE=I4,
      TITLE='His NR', DESCRIPTION='HIS_NR', $
    FIELDNAME=UPDAT, ALIAS=DAT_UPDAT, USAGE=YYMD,
      TITLE='Up Dat', DESCRIPTION='UP_DAT', $
    FIELDNAME=UTM, ALIAS=U_TM, USAGE=I6L,
      TITLE='Up Tm', DESCRIPTION='UP_TM', $
    FIELDNAME=ACNIVE, ALIAS=ACNIVE, USAGE=A1,
      TITLE='ACNive', DESCRIPTION='ACNIVE', $

My .MAS file having the above desription , but i want change FORMAT=A16 to FORMAT=A49 for field name H_NM.
I changed simply in .mas file FORMAT=A16 to FORMAT=A49 , but i got the below error

"(FOC32505) WRONG SEGMENT LENGTH DETECTED: EPL_S3
BYPASSING TO END OF COMMAND"

please help me how to alter the MAS file field format ,
also please let me know how to add new field in already existing .MAS file .
This is the first time for me to handle the focus db mas files,.

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

You will need to use the REBUILD REORG command to make this change: REBUILD REORG

Dan, you are correct (as usual) about the 'rebuild reorg', but unless I missed something, aren't the value he is supplying for attribute 'parent=' wrong? Look at the parent attributes for EPL_S2 (it is the same as the segment name) and the parent for EPL_S3 segment does not exist in the code provided?

Ira

AiX 5.33 wf (test) 7.6, WF (Dev/Prod) 5.3.8

Ira, excellent point. I assumed Pink was not showing us the entire master description because segment EPL_S1 is defined with SEGTYPE=S5, but only one field is shown for the segment when there should be at least five. And if the problems you point out are not the result of typing errors and omissions when posting the entry, Pink will certainly encounter other error messages besides the one described in the post.

Thanx Dan n Ira.. those were certainly typo errors. m working ryt now with rebuild reorg, will update abt the outcome early next week.. happy weekend to u both