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.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?
i have 1000 records in pf.what are all the ways to read a particular name records in rpg?? ie.. in pf i have a name called demo appeared around 52 times hw will we read this particular records in rpg/400?.
what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?
Need a sql query: retrive all duplicate records in table
where we give the MSGSFL in rpg400?
difference between CHAIN and READE?
How to update physical file in rpgle without using display file?
i'm working on progA , in that program i want to see the userids of the users who work on this program?
What is the significance of UDATE?
1.I have a Batch job, Running for 4 hours, i want to reduce the executing time to 2 hours what should you do?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program