Mr.Yallamanda Reddy P thanks for your answer sir,can we use
test(D) opcode in RPG/400,if yes please help me by eloborating
on that answer by writing a sample code for that sir
Answers were Sorted based on User's Feedback
Answer / gagan
test(D) opcode is used to check for the validity of a date/time/timestamp.
If the date is valid then error code returned is o else error code is 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / uday bagdi
Testdate field has date data type and 20 is LO level indicator we check this filed is *YMD format or not.Below is the code.
*ymd test (D) Testdate 20
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we possible to key with the date field?
Can we create 300 logical files based on a single physical file using the CRTLF command only once?.
Can we have a Physical file without any member ? Please let me know
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?
1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?
How to declare the dynamic(run time) array in rpgle? can you please give example
I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.
am 2010 passed out . can any one tell me which course is good to put 2+fake .guide me
How would display prime numbers using CL program?
Need a sql query: retrive all duplicate records in table
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.