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


Please Help Members By Posting Answers For Below Questions

What is the purpose of record level identifier?

732


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?

511


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

716


can you debug ile rpg program using isdb?

741


Interviewer asked me write down DDS for load all subfile .can anybody write dds

1026






How can we know running job is batch or interactive?

660


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...........

3291


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

553


what is *place and *auto keyword in prtf ?plz explain

2730


are there any useful c runtime apis that I can call from rpg iv?

704


how do I play {insert rpg system here}?

589


what is the use of sflnxtchg?

807


How Chain operation copies the record's data to the input buffer for the program?

1084


How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

1567


What are the types of identifiers?

574