Answer / pravin

clear and reset both opcodes are used for clearing the
fields and then initialise the numeric fields with
zero and character with blanks difference is that if we
define any initilialise value for that var in pgm reset
initialize it by that value but clear initialize it by zero
or blanks.
OPEN & CLOSE opcodes are used for explicitly open and
close the file.

SFLNXTCHG :Its always read those records which changed
in uppdatesubfile.this is declared in subfile(SFL) format
not
SUBCTL format.

Answer / balaji

CLEAR opcode is used to set a data item i.e. a field with
predefined default value based on its type. This opcode is
particularly useful when it specified for a data structure
because it clears all of the subfields in the data
structure.
char = *blanks Numeric = 0 etc

RESET is returns a filed to its intial value as specified
in INZ keyword.

Answer / swadesh

clear and reset both opcodes are used for clearing the
fields.difference is that clear only clear but reset is
used for clear & then initialise the numeric fields with
zero and character with blanks.

OPEN & CLOSE opcodes are used for explicitly open and
close the file.In precise all files are automatically open
when these are processed by program bt at somepoint if we
want this should not be implicitly then open we use these
keywords.
SFLNXTCHG :Its always read those records which changed 2
or more times.this is declared in subfile(SFL) format not
SUBCTL format.

Answer / john bulloch

Clear is used to re-initialise a set of data (fields,
arrays, data structures, record formats etc) to blanks for
alpha fields & zeros for numeric fields.
Reset is used to re-initialise a set of data (fields,
arrays, data structures, record formats etc) to it's
initial values set using the inz keyword.

When a file is defined as USROPN, you need to use OPEN &
CLOSE to (you guessed it) OPEN & CLOSE the file.

SFLNXTCHG is used when reading changed records in a subfile
using the READC opcode. The indicator is set on when the
data in the record changes.
For example, when you use READC to validate all the entries
in a subfile before updating or writing the data to a file,
the next time you use READC to perform the updates, you
wouldn't pick up the record you just validated without
reseting the SFLNXTCHG indicator as in the following:

(SFLNXTCHG is linked to indicator 85)

READC sflrec // read the first changed record
DOW not %EOF // process all changed records
Validate the record
*IN85 = *ON // Reset the SFLNXTCHG indicator
UPDATE SFLREC // Update it so that *IN85 sticks
READC sflrec // read the next changed record
ENDDO

now, when you readc to perform your updates, it will pick
up the records you validated in the previous loop

READC sflrec // read the first changed record
DOW not %EOF // process all changed records
update/write the data // read the next changed record
READC sflrec
ENDDO

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

2 Answers  

---

what is a spool file?

0 Answers   IBM,

---

Difference Between Skip Before & Space Before?

0 Answers   IBM,

---

what is the purpose of ovrdta (override data) keyword?

1 Answers   IBM,

---

I want to run ls *.csv (sftp command) from CL Program... Can u plz tell me when SFTP command will start running? i.e.which command should I use in CL Program to run ls command?

2 Answers  

---

what are the important factors in error message subfile ?

0 Answers   IBM,

---

how to validate input values in display file ?

0 Answers   IBM,

---

What is a Device file?

1 Answers  

---

what is the use of CPYFRMQRYF?

4 Answers  

---

How are the objects stored on AS/400?

1 Answers  

---

Logic cycle

1 Answers  

---

Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?

3 Answers   Syntel, Tech Mahindra,

---