can i use unique key in LF

Answer Posted / 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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

693


what is the difference between do while and do until?

662


How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1279


How to handle duplicate error handling in RPG?

1633


How to select highest score of each subject or how to select highest income of every month?

1257






how does the rpg element work?

679


What is difference between bind by copy and bind by reference?

1681


How many program bind in one module....

2082


what is kids-rpg?

643


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2339


explain sflclr, sflend, sfldlt, and sflcsrrrn?

843


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

705


if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.

2160


What is ment by record level identifier?

629


How can we override a file during runtime in rpg?

661