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?
Answer / mahalakshmi
Give file level keyword as the unique based on first keyfield
| Is This Answer Correct ? | 0 Yes | 0 No |
How I can reread the physical file in CL program once the end of file reached in same CL program.
Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4
1.How to load Records of a Physical file(PF) in the reverse order, in CL program?
how do u find whether a record is locked or not??/
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
what are the types of identifers
Need a sql query: retrieve all duplicate records in table?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
How to index LF by relative record no (RRN)
I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this
can I touch the array during treatments?
I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)