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.

How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,

1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400

10 Answers   IBM, Tech Mahindra,

check existence of one record without using chain or read?

1 Answers   IBM,

Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  

What is the OPEN and CLOSE accesspath?

3 Answers   CTS,

Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?

1 Answers  

Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4

4 Answers  

I have learnt through Net that Debugging a Batch job involves 1. Submit the job with the HOLD (*YES) parameter: SBMJOB HOLD(*YES) or Hold the job queue that before submitting the job by using the HLDJOBQ command. 2. Determine the job name, user, and number of the submitted job by using the WRKSBMJOB command. 3. Type the Start Service Job command on your screen: STRSRVJOB JOB(job name/user/number) 4. Type the Start Debug command on your screen: STRDBG 5. Release the job in the jobq. Type WRKSBMJOB and then put a 6 beside the job to be released and press enter, or, if the job queue was put on hold, release the job queue with the RLSJOBQ command. 6. A display appears when the job is ready to start, saying that you can now begin debugging the job. Press F10 to show the Command Entry display. 7. Now you can start debugging by entering an Add Break Point command: ADDBKP 8.ENDDBG 9.ENDSRVJOB I tried this for RPG/400 Program and up to six steps of the above it's ok,but for me no source is displayed and i typed DSPMODSRC in Command line but still i can't see the sourceif i press F.10 and enter command ADDBKP i don't know how to add break points through it,usually i add break points using F.6 for Interactive job debugs,but since this is batch i don't know sir,Please help me out. I was asked this question in a interview,i know only RPG/400 and i’m asking for debugging of RPG/400 program only sir. or is it only possible to debug BATCH RPG ILE JOB and it is not possible to debug BATCH RPG/400 JOB kindly help me out sir

4 Answers   HSBC,

Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?

2 Answers  

3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’

4 Answers   IBM,

What is file identifier where we can use?

0 Answers  

1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?

0 Answers