Answer / guest

SFLCLR - is used to just clear the subfile
SFLINZ - is used to clear the subfile and also initialize
the subfile records with its initial values.

Answer / sivakumar y

continuation to Answers 1 & 2:

SFLINZ will be used only in case of input subfiles.

Answer / ram&

SFLCLR - is used to clear the subfile before load the
records from file .
SFLINZ - is used to clear the subfile and initialize the
defalut values .
e.g: for Numeric values '0',for Char 'blank spaces'.

Answer / lakki

SFLCLR _ clears the subfile to load records in to it

SFLINZ - initialise your records by default and display the
records in to the subfile
(it initialise the number of records depends on your SFLSIZ)

note: once u clear the subfile you can load but once u
initialise the subfile you cannot load the subfile you can
load the subfile after the SFLSIZ member greater than 1

Answer / srini

one more differance is:

To avoid session device error by using SFLINZ.

Answer / venkateshp

SFLCLR is clear the toal subfile and inactive the all
therecord and you can wrie the recors to subfile thoseare
only active

SFLINZ is just gives the deful values to the fields of all
the records of subfile and all are active this will useful
only when u showing total subfile withou data
you cant write the data to subfile once you intilize the
data untill clear the subfile

Answer / venkat

sflclr is a record level keyword on the subfile control record format .sflclr is clear the subfile before loading the records from datebase file into the subfile

sflinz:it is also a record level keyword on the subfile control record format .it also clear the subfile and initialize the some dafault values.

I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.

3 Answers  

Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  

I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.

2 Answers  

What is the difference between RPG/400 and RPG4

1 Answers   HCL,

use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,

how do u find whether a record is locked or not??/

5 Answers   CTS,

what will happen two jobs have same name are submitted

5 Answers   CTS,

This is my Physical file 'EMPS' existing in library "TAMIL1" and its record format is 'EMPRCD" a)its source is R EMPRCD ENO 4 0 ENAME 10 EADD 10 b)The records present in EMPS are as follows ENO ENAME EADD 0001 tamil coimbatore 0002 kumar bangalore 0003 sunder bangalore 0004 arunkumar chennai 0005 pandi hyderabad 0006 santhosh hyderabad 0007 sasi salem 0008 kalai chennai 0009 suresh hyderabad 0010 vijay bangalore 0011 Arul chennai 0012 velu chennai 0013 khan bangalore 0014 praba chennai 0015 praba.p coimbatore 0016 anand ooty 0017 raja erode 0018 sankar erode 0019 vadivel namakkal 0020 anbu chennai 0021 Ajith mumabi c)now i want to select the 'ENAME' field records starting with 'S' for that i have created a RPG program its source code is PGM DCLF FILE(TAMIL1/EMPS) DCL VAR(&MYENO) TYPE(*CHAR) LEN(4) OVRDBF FILE(EMPS) SHARE(*YES) OPNQRYF FILE((TAMIL1/EMPS)) QRYSLT('ENAME *EQ %WLDCRD("S *")') READ: RCVF RCDFMT(EMPRCD) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) CHGVAR VAR(&MYENO) VALUE(&ENO) SNDUSRMSG MSG(&MYENO) SNDUSRMSG MSG(&ENAME) SNDUSRMSG MSG(&EADD) GOTO READ END: CLOF OPNID(EMPS) DLTOVR FILE(EMPS) ENDPGM Is this coding correct sir,the program gets compiled,and if i call it it says query running but records are not displayed.please help me out

4 Answers   Virtusa,

1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?

4 Answers   IBM,

Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?

1 Answers  

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 Answers   iGate,

1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers   HCL,