Answer / venkat

The format of this keyword is:
UNIQUE[(*INCNULL | *EXCNULL)]The parameter is optional. When specified, it determines whether null key values cause duplicates. *INCNULL is the default and indicates to include null values when determining duplicates. *EXCNULL, when specified, indicates to exclude null values when determining duplicates.
When a logical file based on a physical file has the UNIQUE keyword, the physical file member or members cannot have duplicate key values.

When you specify the UNIQUE keyword for a physical or logical file, you must specify the MAINT(*IMMED) parameter value on the Create Physical File (CRTPF) or Create Logical File (CRTLF) command that creates the file. This means that the access path is maintained immediately when changes are made.

If you do not specify the UNIQUE keyword, records with duplicate key values are sequenced in the order you specify. If you specify the FIFO keyword, they are sequenced in first-in first-out order. If you specify the LIFO keyword, they are sequenced in last-in first-out order. If you specify the FCFO keyword, they are sequenced in first-changed first-out order. If you do not specify FIFO, LIFO or FCFO, the order in which the records are sequenced is not guaranteed.

You cannot specify the UNIQUE keyword with the FIFO, LIFO, FCFO, or REFACCPTH keywords.

Example
The following example shows how to specify the UNIQUE keyword for a logical file.

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00010A*
00020A* SAMPLE LOGICAL FILE (CUSMSTL)
00030A*
00040A UNIQUE
00050A R CUSREC PFILE(CUSMSTP)
00060A TEXT('Logical File Master Record')
00070A CUST
00080A NAME
00090A ADDR
00100A K CUST

Answer / ravi kumar

Hi,

Yes. When Pf doesn't contain duplicate records based on key value then we can use UNIQUE keyword in logical file. If pf contain Duplicate values then LF will not compile.


I have tried in this scenario

Answer / sravan

Yes you can use unique key in logical files.

How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.

2 Answers  

---

what r drawbacks of OPM? Why do we go for ILE RPG?

1 Answers  

---

Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.

1 Answers  

---

what is EXCEPT command in rpg and use

1 Answers   Active Brains,

---

what is importance of 'MAPFLD' IN OPNQRYF FILE ?

2 Answers  

---

2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed

2 Answers   IBM,

---

How to set on/off a group of indicators in a single statement?

3 Answers  

---

Can more than one subfile record be displayed on one line?

7 Answers   IBM,

---

how do I declare a table or array in rpg iv?

0 Answers   IBM,

---

what is post opcode do

1 Answers   CTS,

---

I am reading a file in CL program. and MONMSG CPF0864 has arrived means EOF has arrived. Now i want to read this file again. How i can do this?

5 Answers   CitiGroup, Symphony,

---

what is the difference between the procedure and module in ILERPG?

4 Answers  

---