HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY
ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?
Answer / maheshg
Delete the record from dependent file where it has
REFERTIAL INTYGRITY then delete the record from master
file.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to read alternative records in a pf by using rpg?
How can we change element of compile time array?Can we do so
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?
Write a program to display prime numbers between 1 to 100 using RPGLE.
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'
can anyone explain aboutovrOVRDBF,OPNQRYF, OVRSCOPE and OPNSCOPE?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
what is the difference between do while and do until?
I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.