01-16-2006 10:31 AM
hi , friend, i have let 5 row in my flat file,but i want to skip any particular row on certain condition based on par field, as i am using skip_record or skip_transaction , it makes the field blank on which i have used criteria,
tell me how to skip transfer of any par row.
01-16-2006 10:34 AM
U can write a code in 5 th step.
while uploading based on the condition...say CONTINUE.
01-16-2006 10:36 AM
SKIP_RECORD Will skip that record.
skip_transaction : will skip that transaction
so,as per your question,
USE SKIP_RECORD.
if inputfile-field10 is initial.
*--assume if your field10 is empty on any particular record,you dont want to process it
skip_record.
endif.
Message was edited by: Srikanth Kidambi Maruthi
01-16-2006 10:57 AM
<b>Skip a Record</b>
Situation: You want to "skip" a record depending on a certain condition, i.e. this record shall not be converted and transferred to the output file
Solution:
if <condition>.
skip_record.
endif.
<b>Skip All Records of a Transaction</b>
Situation: You want to "skip" all records of a transaction depending on a certain condition.
Solution:
if <condition>.
skip_transaction.
endif.
01-16-2006 4:34 PM
In your field mapping, double click on begin_of_transaction and put your logic there and use skip transaction(assuming one record from your file will result in one transaction).
Srinivas