Answer Posted / ravi kumar shukla
This is a file level keyword used in a logical file. If you specify this in a file level, the system doesn't perform record selection until the program reads file.Then on the Select/Omit criteria, it selects the records from the specified file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the clp command to access a query/400?
at what level s,o are defined and what they will do?
how to write code for singlepage in sqlrpgle with update ?
Write a CL program which will run a batch job at 1 am every night
what does vldcmdkey means?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
how you get the relative record in a subfile in which cursor is located?
what is the command to know key fields of file?
how will you find a string using pdm?
when do you explicitly open files and close files in an rpg program?
How can we arrange duplicate records in a file?
difference between sflrcdnbr and sflnxtchg?
what is arrival sequence?
what does check opcode do ?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.