How to update only a field of a PF in an RPG program.
I don't want to update the record, only one field.
Answers were Sorted based on User's Feedback
If file FileA has fields field1, field2, field3, and we
want to write out field2 only ...
C...except..Change
OfileA...E...Change
O...............field2
Hope it will work fine.
For Free Format try out following...
Update Recformat %fields(field2);
| Is This Answer Correct ? | 33 Yes | 1 No |
Answer / kapil kumar
Use CHAIN for that record
then EVAL fld='value'
UPDATE pfrecfmt
| Is This Answer Correct ? | 1 Yes | 24 No |
what procedure should we use to find whether the following operations are successful or not setll setgt chain read reade readp pls tell with example i'm not lazy to read the manual or not lazy to do anything.but sometimes i cannot understand the things given in manual in high level english its little bit complicated for me,i can't understand their way of writing thats why i ask these questions here and find the solution in simple words that i can understand thats the real reason sir.sorry if i had hurt you or disturbed you.please understand my situation.
1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
To check the locks , we use cmd WRKOBJLCK , but how we confirm whether it's objeck lock / member lock. I confused with the Lock type and Status values...Can any body please tell me ...
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?
while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue
how can I tell when to replace the array?
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?
parameters cannot be passed in which one??
RPG/400 number of Records present in a physical file using file information data structure FPF001 IP E DISK F KINFDS INFDS1 IINFDS1 DS I *RECORD RECORD Is this coding correct sir,i have given I P E that is I- input,P-primary file,E-externally described. Primary to use RPG logic cycle,is this the correct method because we have to find number of records present using file information data structure in RPG/400 without doing any input/output operations on the file and also without using DSPFD,SQL. If the above coding is correct means,when i compile the program it gets compiled,but if i call the program it does not return anything,i need number of records,please complete the coding sir.
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
What is the OPEN and CLOSE accesspath?
what is file information data structure?