3 members in databasefile .how to read records from all the
members??
Answers were Sorted based on User's Feedback
Answer / guru
Reading all the members in a pf cannot be achieved in a
single override command and which is cumbersome too. So
rather using override, you can use EXTMBR('*ALL') in the
file specification in your rpgle program. So when you read a
file, it will automatically read all the members records
from your data base file. This is FYI
Regards
Guru
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / swadesh
With the OVRDBF command give the member name as *all.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ravi shankar porwal
U can also read the records of all members using logical
file.create logical file based on given PF(have more than
one member) and read it using rpgle program.
| Is This Answer Correct ? | 2 Yes | 2 No |
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400
10 Answers IBM, Tech Mahindra,
can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E
Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?
Why we cannot call a service program? If I add a PEP can i call the service program?
I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?
suppose there are 100 records and i want to read records between 60-70 how we can read this 10 records in rpg
what is the difference between SETON RT & RETURN?
How can we receive values from a called procedure in RPG?
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
1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
what is the necessary keyword needed to scroll subfile records?