I have input file like this

0PLMFFRLB2014-02-02
140010652561557....°...023700003930002012-03-302029-12-20
140010692630818.......|038100002800002014-01-302029-01-14
140011881568272.....&..056700001700002005-09-302029-09-21
140012521308459........064200004670002011-03-302029-03-16
140012531177753......-.078900003500002006-03-302029-03-27
140012551331876..... ..085700003400002011-11-302029-11-30
140024432438879........090600002320002012-03-302029-03-19
140032712019434........018800004200002010-02-302029-02-23
140032771602187....ê.ߤ025800001100002009-07-302029-07-09
9000000011


FILENAME=TLDBEX,SUFFIX=FIX
SEGNAME=TLDBHEAD ,$
FIELD=RECTYPE ,ALIAS=0 ,ACTUAL=A01 ,USAGE=A01 ,$
FIELD=SM_DATA ,ALIAS=DATA ,ACTUAL=A08 ,USAGE=A08 ,$
FIELD=CREATE_DATE , ,ACTUAL=A10 ,USAGE=YYMD ,$
FIELD=CREATE_TIME , ,ACTUAL=A06 ,USAGE=A06 ,$
FIELD=FILLER1 , ,ACTUAL=A36 ,USAGE=A14 ,$
SEGNAME=DETAILS,PARENT=TLDBHEAD ,$
FIELD=RECTYPE ,ALIAS=1 ,ACTUAL=A01 ,USAGE=A01 ,$
GROUP=BRA_ACC_NO , ,ACTUAL=A14 ,USAGE=A14 ,$
FIELD=BRA_ACC_SU , ,ACTUAL=A02 ,USAGE=A02 ,$
FIELD=BRA_ACC , ,ACTUAL=A12 ,USAGE=A12 ,$
FIELD=SM_IN_BAL ,ALIAS=BALNACE ,ACTUAL=P08 ,USAGE=P15.2 ,$
FIELD=SM_AVE_COF ,ALIAS=COST_FUNDS ,ACTUAL=Z07 ,USAGE=P8.5 ,$
FIELD=SM_MARGIN ,ALIAS=MARGIN ,ACTUAL=Z07 ,USAGE=P8.5 ,$
FIELD=SM_FST_DTE ,ALIAS=FST_REP_DTE,ACTUAL=A10 ,USAGE=YYMD ,$

FIELD=SM_NXT_REP ,ALIAS=NEXT_REP ,ACTUAL=A10 ,USAGE=YYMD ,$
SEGNAME=TLDBTRLR ,PARENT=TLDBHEAD ,$
FIELD=RECTYPE ,ALIAS=9 ,ACTUAL=A01 ,USAGE=A01 ,$
FIELD=REC_COUNT , ,ACTUAL=A09 ,USAGE=I09 ,$
FIELD=FILLER2 , ,ACTUAL=A46 ,USAGE=A46 ,$
END
i wrote a program to read the data present in the above and update the Focus Databse

Instead of reading from fixform Directly
I stored the the values in hold and again i am reading the values from hold


TABLE FILE TLDBEX
PRINT BRA_ACC
SM_IN_BAL
SM_AVE_COF
SM_MARGIN
ON TABLE HOLD
END

MODIFY FILE TLDBTERM
FIXFORM FROM HOLD
PERFORM 100_VALBRACC;

Again i am getting the same error
MODIFY FILE TLDBTERM
TLDBTERM ON 04/13/2015 AT 13.58.32
FIXFORM FROM HOLD
ERROR AT OR NEAR LINE 10 IN PROCEDURE TESTM011FOCEXEC
(FOC419) FIXFORM SUBCOMMAND ELEMENT OR FIELDNAME NOT RECOGNIZED: BRA_ACC
/CA12
BYPASSING TO END OF COMMAND
PERFORM 100_VALBRACC;

Will you help me how to resolve it

This message has been edited. Last edited by: <Kathryn Henning>,

FYI, I usually recreate the problem using the CAR Synonym, so that others can reproduce the problem. Reading everything above, I can't tell what the error is or why your getting it.

Whenever you receive an error message that you need a little more information on - and you cannot locate a similar post searching on the Forum or Tech Support pages, then just enter a ? followed by a space and the error number into a FOCUS command console or a new focexec, and then run it.

Most of the time this will give you a little more on the error.

In your instance, ? 419 provides this info -

quote:

(FOC419) FIXFORM SUBCOMMAND ELEMENT OR FIELDNAME NOT RECOGNIZED:
An element on the FIXFORM subcommand, such as the number of
characters to process, cannot be identified.

Now, given that you have a FIXFORM command within the MODIFY statement, then it should be easy to establish that the error is around that area. If you understand that a quoted or implied field name in the FIXFORM statement is still expected to be processed, then you should realise that the fieldname quoted in the "FIELDNAME NOT RECOGIZED:" is not within the synonym of the file that you you are trying to MODIFY. So you need to address that either by removing the field from the hold file, naming it correctly (if incorrect) or some other corrective action.

Also, please be aware that the two postings you made for the same error message are going to be similar in resolution - in your case with different field names. I have observed that posting two successive pleas for assistance in short succession often results in a tendency to avoid future requests for assistance.

Remember that this is a forum where well intentioned folks try and assist those in need ... for free. It is only through the good nature of the "FOCUS Nation" as Sandy Kadish is prone to call it, that many possible solutions are given.

Good luck

T

Is that your entire MODIFY ??

Have you had any FOCUS training?? Your HOLD does not have any BY phrase that would normally suggest a Key field (or more than one in a multi-segment file). You have a multi-segment database, apparently, but no MATCH statement in your MODIFY. PERFORM seems entirely unnecessary.

I suggest that you find an old FOCUS manual somewhere and see if you can figure out how to build a proper MODIFY.

The basic syntax is:

MODIFY FILE XYZ
FIXFORM FROM HOLD
MATCH TOPSEGKEY NEXTSEGKEY
ON MATCH REJECT
ON NOMATCH INCLUDE
DATA ON HOLD
END  

Add a "?FF HOLD" after your ON TABLE HOLD to see what's actually in there. The "BRA_ACC" is the shortest unique truncation of two other fields and as a complete field name which may be causing a bit of confusion...