Answer / syam

Kumar's answer is correct.

OVRDBF FILE(File name) TOFILE(new file name) MBR(*first)
POSITION(*RRN 55)
55 = record number

OR

OVRDBF FILE(File name) TOFILE(new file name) MBR(*first)
POSITION(*KEY 1 RCD1 SYAM)
1 = no of key field
RCD1= Record format name
SYAM = Value

Answer / kumar pushpam

PLZ PLZ PLZ PLZ PLZ CAN ANYONE TELL ME THAT AS400 FRESHER WILL EVER GET A JOB
AND IF YES THEN WHEN THAT TIME COMES
MY NAME IS KUMAR PUSHPAM AND I M AN AS400 FRESHER AND HAVE 0(ZERO)
YEAR EXPERIENCE BUT EVEN I WANT TO
MAKE MY CAREER IN THIS FIELD SO PLZ PLZ TELL ME ANYTHING ABOUT THAT IF A COMPANY RECRUITS ANY AS400 FRESHER CANDIDATE

Answer / syam

Hi Chowdary.....POSDBF command allows the user to set the
position of a database file to either the beginning or end
of an open file(Member), not EQ to SETLL.
POSDBF OPNID(FILEID) POSITION(*START)
Or
POSDBF OPNID(FILEID) POSITION(*END)

Answer / chowdary

Sorry Syam and Thanx for ur answer, Syam.

Answer / s. croy

You can position to the beginning or end, but the functional equivalent to SETLL in CL

OVRDBF FILE(RPTEMAILL2) TOFILE(RPTEMAILL2) +
POSITION(*KEYAE 1 *N &PROGRAM) +
OVRSCOPE(*CALLLVL)

Answer / syam

Hi Surendra.....How to set pointer in OVRDBF? Please post
full command.....Thanks

Answer / venkaesh

using POSDBF

Answer / s kumar

By OVRDBF Command

Cheers!!

Answer / chowdary s

By using POSDBF Cmmand through CL PGM, can do

Thanks
CHOWDARY S

Answer / surendra y mudliar

By using OVRDBF command you can set the pointer in the file
to whichever record you want.

Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?

1 Answers  

How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"

4 Answers  

1.How to load Records of a Physical file(PF) in the reverse order, in CL program?

2 Answers   Cap Gemini,

list down and describe the sub systems vailable

5 Answers   IBM,

How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.

4 Answers   IBM,

If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  

1.If *HIVAL SETGT is used what opcode is used to read a record? A:READ B:READPE C:CHAIN D:READP 2.How to pass numeric parameter to the rpg pgm from the command line? 3.What keyword is used on the rpg 4 definition specification to rename a subfile in an externally definition data structure? A:RENAME B;LIKE C:EXTNAME D:EXTFLD

4 Answers   Manhattan,

Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir

2 Answers   iGate,

What is the syntax of passing parameters to a procedure by value?

1 Answers  

in rpg could u please tell me errors types and meanings like 3030 that ....

1 Answers   EXL, UHG,

How can read PF in reverse order (end to start) in CL pgm..

8 Answers   TCS,

What are the necessary keywords required to code a message subfile?

3 Answers