Suppose you have 3 members in a database file. How to read records from al

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> MainFrame >> IBM AS400 >> RPG400

RPG400 Interview Questions

COBOL400 Interview Questions

DB400 Interview Questions

COOLPLEX Interview Questions

IBM AS400 AllOther Interview Questions

Question

Suppose you have 3 members in a database file. How to read
records from all the members without using CL (OVRDBF) i.e.
Entire process should be handled exclusively in a RPG program?

Question Submitted By :: Harshadpendse

I also faced this Question!!

Rank

Answer Posted By

Re: Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

Answer
# 1

use EXTMBR('*ALL') keyword on F specification

Is This Answer Correct ?

11 Yes

1 No

Kcsyam

Re: Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

Answer
# 2

The above answer is perfectly right!

Is This Answer Correct ?

0 Yes

0 No

As400 Gem

Re: Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

Answer
# 3

Hello, EXTMBR key word can be used in RPGLE program, but the
question is how to use it in RPG?

Is This Answer Correct ?

0 Yes

0 No

Prasanh

Re: Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

Answer
# 4

One way could be using CPYF copy all the members into a
single member of a file and then process the new file in
the RPG.

Is This Answer Correct ?

0 Yes

0 No

Milan Kumar Banerjee

Re: Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

Answer
# 5

Use OVRDBF command in RPG using QCMDEXC

Is This Answer Correct ?

0 Yes

0 No

Phalgun

Question	Asked @	Answers
Other RPG400 Interview Questions


How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.		2
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.		1
HOW TO DEBUG A BATCH JOB WHEN IT IS IN MESSAGEWAIT(MSWG) STATUS.I KNOW THE STEPS FOR BATCH DEBUGGING,BUT IM CONFUSING WITH WHEN WE SUBMIT ANY JOB FOR BATCH DEBUG WE PUT IN HELD STATE.SO HERE ALSO DO SAME THING OR ANY OTHER WAY,PLEASE HELP ME....	HCL	1
What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???	HSBC	7
What is the length of Signature?	UST	3
What are different ways to pass data between programs and which one is the efficient way?		5
1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400	IBM	9
can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?	TCS	2
How can i keyed a flat file in RPGLE	Wipro	5
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?	HCL	4
How to index LF by relative record no (RRN)		1
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?	HSBC	2

For more RPG400 Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2012 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com