How can we make use of SETLL operation in CL?
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 9 Yes | 1 No |
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
| Is This Answer Correct ? | 6 Yes | 0 No |
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)
| Is This Answer Correct ? | 5 Yes | 1 No |
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)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / syam
Hi Surendra.....How to set pointer in OVRDBF? Please post
full command.....Thanks
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chowdary s
By using POSDBF Cmmand through CL PGM, can do
Thanks
CHOWDARY S
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / surendra y mudliar
By using OVRDBF command you can set the pointer in the file
to whichever record you want.
| Is This Answer Correct ? | 0 Yes | 5 No |
1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
what is an online rpg?
What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???
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?
Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?
what do you mean by an input subfile, what are the keywords required?
1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?
Job is in MSGW while reading the input file and writing a new record / updating a reacod due to Duplicate data error. What action would you take ( C D I R )...?
what is kids-rpg?
there is any limit to display the members in rpg400?
program to find the number of objects used in a given program through a display.