Answer / vasu devareddy.g

we can update selected fields from pf using EXCEPT OPCODE

Answer / rahul

we can update selected fields of a pf using EXCEPT opcode

Answer / gurjit oberoi

without using cl command we can read members in RPG using
EXTMBR in F spec like

EXTMBR(member_name)

Answer / sivakumar y

Hello Friends, Question asked by vinit is how to read all
members in RPG3, but not in RPGLE.

I think the answer for this question is:
1)Need to declare the rquired file in USROPN mode in RPG.
FFILE1 UF E K DISK Usropn

2)Using QCMDEXC API execute the override command. The
value to be passed in first parameter is like below.
D Cmd1 C OVRDBF FILE(FILE1)
TOFILE(TOOLBOX/FILE1) MBR(*ALL)'

Regards
siva

Answer / sekhar214

UPDATE RCDFMT %FIELDS(FIELD1:FIELD2)

Answer / kamlesh

create new LF which is based on multi memeber PF
This LF has only one data member which is based on
all data members present in PF. Now use this LF
in yr RPG3.

Answer / daithuan

1.Why not use embedded SQL?
2.Why read all members, surely if you want to update the pf file base on a certain condition then every record that matches that condition will be updated.

Hope that helps!!!

Answer / sai reddy

Hi Siva,
what is the major Difference between RPG 3 and RPGLE in terms of coding...please reply me.

difference between 1:%found and %equal built function in detail with example .

6 Answers   Polaris,

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  

Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers  

How to find d key field of a pf that doesn’t have source physical file?

2 Answers  

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?

4 Answers  

In case if I want to know whether a record exists in a file, which one do you prefer CHAIN or a SETLL and why ?

1 Answers  

How to update physical file in rpgle without using display file?

4 Answers   GalaxE, IBM, TCS,

Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers   IBM,

i want to retrieve record b/w 2 dates in as400

2 Answers   L&T,

1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword

1 Answers   CSC, CTS,

what is kids-rpg?

0 Answers   IBM,

can I touch the array during treatments?

0 Answers   IBM,