i want to retrieve record b/w 2 dates in as400
Answers were Sorted based on User's Feedback
Answer / 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 |
how do you use commitment control in rpg?
Can anybody tell me that why we use option(*nodebugio)in H- Spec?
1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
What will be the value of STRING after line 0106 is executed in the code below? 0101 E* Fromfiletofile..tabnameprnentlenpdatabnamlenpda 0102 E ARR 8 1 0103 ISTRING DS 0104 I 1 8 ARR 0105 C MOVE *BLANK STRING 0106 C MOVEA'ABC' ARR A) 'AAAAAAAA' B) 'BBBBBBBB' C) 'CCCCCCCC' D) 'ABC ' E) ' ABC'
How Commitment and Roll back control is used in as400, explain with real time senario ???
explain sflclr, sflend, sfldlt, and sflcsrrrn?
Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.
can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?
What is the name of default out queue when user logs inn to syatem with valid profile?
difference between 1:%found and %equal built function in detail with example .
How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??