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.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword
Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?
There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented
this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002
difference betwen keywords and opcodes
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF
3 members in a databasefile .how to read records from all the members?????????
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What are the necessary keywords required to code a message subfile?