Answer / abhishek kumar

In most of the cases files(*file) will be locked.
Reason: If any program is using that particular file.

Answer / samul

File object locked when file open in update mode or file
allocated excl in cl using cmd ALLOBJ.

Answer / sankar prosad mohanta

Abhishek is correct, but we can avoid this file locking,
specifying 'N' in 53 position of File Description Spec,
where the file is defined in the program.

Answer / keshar jain

@Shankar:
We can use N on position 53 in CHAIN if file is in Update
mode. For other mode we can't specify N.

Answer / ravi

When a file is declared in UF mode. U - Update, F - Fully procedural file.

When you do a read, it locks the particular record making it unavailable for any other programs. This is to protect the data integrity.

Once you do the update, the lock will be released. If you do not want the lock, you can specify Read(N), but you cannot update. You can also UNLCK opcode to release the lock.

Also, each time you update, you need to lock it.

If you do ALCOBJ you can lock it exclusively. This will not even allow basic functions on the object like read/display. And vice versa too. Any *SHRRD locks like read/display will not allow exclusive lock.

what is difference between DSPFD and DSPFFD?please give me real senario with good example?

1 Answers  

Can we create 300 logical files based on a single physical file using the CRTLF command only once?.

8 Answers  

RETRIVING DELETED RECORDS :- I'm frequently asked how to retrieve deleted records from an unjournaled physical file when the deleted records have not yet been removed from the file. Utility UNDEL lets you undelete records in a physical file. This public domain program is available in CISC and RISC versions, and the complete source code is available for download at: UNDEL for AS/400 Save File (RISC): http://www.as400network.com/sharewarefiles/undelris.zip UNDEL for AS/400 Save File (CISC): http://www.as400network.com/sharewarefiles/undel.zip UNDEL for AS/400 Save File (Source code): http://www.as400network.com/sharewarefiles/undelsrc.zip The utility takes advantage of the fact that deleted records in physical files are only flagged as deleted, and the record data still exists until it is overwritten or the file is reorganized with a utility such as RGZPFM. UNDEL simply reads the deleted record, then reuses the record by writing over it with the new record (thus eliminating the flag for the deleted record). Some homegrown and commercial utilities copy the file containing undeleted records to a save file, then use a program to read the save file, which contains live and undeleted records, to a file to undelete the records. The UNDEL utility is superior to the SAVF technique because there's no need to copy the file to a save file, which is especially important for really large files. When run, UNDEL displays the physical file records in their unformatted, raw text form. You can either position the display to a given relative record number or use F19 or F20 to find the previous and next deleted record, respectively. The utility also includes online help, which is almost unheard of for free utilities. Other utilities include the ability to undelete records. You can use the RTVDLTRCD command in the old QUSRTOOL (no longer supported by IBM). QUSRTOOL is now a commercial product called TAA Productivity Tools ( http://www.taatool.com ). The free file editor WRKDBF has a built-in undelete capability ( http://www.wrkdbf.com ), and several commercial file editors can undelete records. For a complete list of file editors, go to http://www.sourcebook400.com, select "Programmer Tools" under "Product Category," then select "File Editors."

0 Answers  

1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers   HCL,

If record-format name in an externally-described file has already been defined as a file-name.how to solve this?

2 Answers   CTS,

Can we used ovrdbf command after the opnqry file if yes then What will be out put of your program?

4 Answers   IBM,

how do u track msg in cl pgm???

1 Answers   CTS,

When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?

5 Answers   Mphasis,

In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening

2 Answers  

How many program bind in one module....

0 Answers  

What is the RPG cycle?

3 Answers   CSC,

Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC

2 Answers