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 |
Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
RPG/400 number of Records present in a physical file using file information data structure FPF001 IP E DISK F KINFDS INFDS1 IINFDS1 DS I *RECORD RECORD Is this coding correct sir,i have given I P E that is I- input,P-primary file,E-externally described. Primary to use RPG logic cycle,is this the correct method because we have to find number of records present using file information data structure in RPG/400 without doing any input/output operations on the file and also without using DSPFD,SQL. If the above coding is correct means,when i compile the program it gets compiled,but if i call the program it does not return anything,i need number of records,please complete the coding sir.
Can someone tell me tell me what is meant by message wait...?
why we do STRSRVJOB in batch debugging in as400
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?
how to change the length of the field in a physicalfile?
What is the purpose of FRCDTA keyword?
Why Rpg/400 is Famous?
what is an online rpg?
can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?
suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .