Answer / reecha

Using EXTMBR(member name) in the keyword option in the F
specs. For eg.

F filename I F E EXTMBR(mbrname)
This will open the particular member of the file.

Answer / shruti tayal

In F-spec use EXTMBR keyword, specify *ALL in quotes as the
parameter value, this will cause all members of the file to
get processed.

Answer / sumit gupta

if you want to read a particular member/or all member
records in RPG program without OVRDBF in CL program. Then,
you can use EXTMBR keyword.

Declare a file in f specs and in keyword option write
1) EXTMBR(*ALL)
or
2) EXTMBR(MEMBER NAME)

Member Name must be in CAPS as if you dont put it in CAPS
then severity 30 error comes while compilation.

Answer / vivek

USING MEMBER MAPPING IN LF THEN THIS LF USE IN RPG PROGRAM.
LET SEE,
PF@1 CONTAIN 3 MEMBER LIKE M1,M2,M3 AND FIELDS OF
NAME AND ID
LF@1
R R1 PFILE(PF@1)
K NAME
AFTER THAT LF USE IN RPG PROGRAM. TRy now.

Answer / reena

Create a logical file which contains the 3 members. Later
user the LF in RPG Program

Answer / syam

Create diff. 3 RUNQRY with 3 members and save it. Run this
QRY inside the RPG Program thru using EXEC CL Cammand.

which type of object is used in db2/400?

0 Answers   IBM,

Q.1.What is differences in STRDBG and STRISDB debugging commands? 2.Where we should use STRDBG and STRISDB Debugging commands?

6 Answers   CTS,

I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

0 Answers   CSC,

using dfu, user will be able to ___________ from physical file?

0 Answers   IBM,

What is the purpose of the following I UDS I 1 60ORDER# I 7 90LINE#

1 Answers  

what if my system I runs with system value qccsid 65535?

0 Answers   IBM,

how do you pass parameters in cl?

1 Answers   IBM,

at what level s,o are defined and what they will do?

1 Answers   IBM,

We have seen no of parameter list but If we mention like this 'CALL PROGNAME PLIST ' how to know No of parameter name of program ?

2 Answers   IBM,

Hi All, Can any one give me a suggestion for below prob One job is in MSGW due to decimal dara error and I find out stmt error and Value in DMUP. but my file has millions of records.So how can i find out on which record the error was occured....?

3 Answers  

If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?

0 Answers   IBM,

define the purpose of the %sst function?

1 Answers   IBM,