Answer / anu

BY USING THE KEYWORD SFLLIN KEYWORD WE CAN DISPLAY MORE
THAN ONE RECORD.

Answer / david lex

The question is 'can more than one SUBFILE line be
displayed on one line', the answer to which is yes and no.
The example, however, is more of 'can a subfile line be
more than one line'.

Using a over/under, or vertical subfile, one can have many
lines per actual subfile record. As the answer above state,
SFLLIN in conjunction with FOLD/DROP works great.

Using a side by side, or horizontal subfile, one can
actually display multiple SUBFILE lines, each with several
lines per actual record.

Quite different scenarios.

Also, for the record, you can use the alternate screen size
of 132 characters in width to gain more screen real estate.
There are, of course, limitations to this and those must be
addressed before just making the screen bigger.

Answer / rizwan

Actually the Question is regarding Displaying more than 1
records of a Pf in a single line.To do so,Subfile Keyword
SFLLIN is used.

For Ex a PF has Fields named as Iden,Addr whose total
length is 30.In that case since display screen has a room
for displaying upto 80 chars, we can place the first &
second record of the Pf in the same line which in total is
going to occupy nearly 70 space including the blanks for
displaying the fields in the screen.

Answer / nandini

For example, specifying the SFLLIN keyword causes a subfile
of four records to be displayed as:

REC1 REC3
REC2 REC4If SFLLIN is not specified, these records
appear as:

REC1
REC2
REC3
REC4

Answer / raheem

BY USING THIS KEYWORD "SFLLIN" KEYWORD WE CAN DISPLAY MORE
THAN ONE COLUMN OF RECORDS ON A SINGLE LINE.
THIS IS RECORD LEVEL KEYWORD ON A SUBFILE CONTROL RECORD FORMAT & IT BE DISPLAYED AS HORIZONTAL SUBFILE.

Answer / sushama

Yes, by using SFLLIN keyword.

Answer / samul

Yes,we can display the record in more then one line using
SFLFOLD,SFLDROP and SFLMODE...see the usage in redbook

Can we have a Physical file without any member ? Please let me know

12 Answers  

i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?

6 Answers   Mind Tree,

i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.

5 Answers   TCS,

suppose if we want to update the data in cl what we will do?

9 Answers  

program to find the number of objects used in a given program through a display.

2 Answers   IBM,

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,

WHERE DO WE USE COMIT KEYWORD IN AN RPG PROGRAM? YOU MADE SOME CHANGES TO DATABASE BUT YOU DON'T WANT TO SAVE THOSE CHANGES NOW? HOW DO YOU HANDLE THIS ONE?

2 Answers  

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

4 Answers   CTS,

Can AnyOne tell me how to read join logical file in rpg from starting to end?

2 Answers  

what is data area and how it is used in rpg program ?

0 Answers   IBM,

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers   TCS,

suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .

4 Answers   CSC,