What is SFLNXTCHG keyword why it has used and where?
Briefly explain with Example.
- 2 Answers
- 18061 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tprabhakarreddy
Before having the answer for SFLNXTCHG, understand about
the MDT tag.
Modified Data Tag:
1. It is 1 bit of the attribute charecter and Every subfile
record will have a MDT tag and it will seton when the
record is changed.
2. Readc will record all subfile records whcih have MDT = 1
and once Readc is performed on changed record MDT will made
off.
3. Hence When you performed READC for the second time on
the same record, which has changed before but not changed
second time, will not work.
SFLNXTCHG keuword:
For reading the subfile reading in second time, which has
changed before but not changed second time, we have to
force the MDT flag set to 1. This can be done using
SFLNXTCHG keyword.
| Is This Answer Correct ? | 31 Yes | 3 No |
Answer / syam
The purpose of SFLNXTCHG =
Which is a subfile record format keyword. If you perform
read on the subfile, the internal indicator
MDT (modified data tag) is automatically set off by the
system. If you again perform read on the
same records, records won't be read. Because internal
indicator MDT would be off. Hence you should be
explicitly set on the MDT by SFLNXTCHG keyword.
| Is This Answer Correct ? | 9 Yes | 1 No |
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
can anybody explain significance of *loval setll with example code????
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?
HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?
Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
How would display prime numbers using CL program?
What is the purpose of FRCDTA keyword?
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?
RPG400 
