i want to retrieve record b/w 2 dates in as400
Answer Posted / vijay
Take date 1 and date 2 as date fields and give the condition as If date 1 > = date and date 2 < = date ;
dsply date ;
Endif; then u can retrieve the records based on the above condition.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of record level identifier?
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 happens when sflsiz = sflpag? What are the advantages and disadvantages?
can you debug ile rpg program using isdb?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
How can we know running job is batch or interactive?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
what is *place and *auto keyword in prtf ?plz explain
are there any useful c runtime apis that I can call from rpg iv?
how do I play {insert rpg system here}?
what is the use of sflnxtchg?
How Chain operation copies the record's data to the input buffer for the program?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
What are the types of identifiers?