can i use unique key in LF
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
How do I link an existing logical file to it's Physical File without recompiling?
Can we found a record existance in a file w/o reading the file?
6 Answers Traitsys Technologies,
can anybody help me that what is the procedure of debugging the service program?
How to change the name of physical members Dynamically?
how can we can we the data decimal error?how can we open such file in support
why subproc not run in dftactgrp?????/plz explain
in which journalling which attributes are necessary??/
A pgm subroutine calling child subroutine, that child subroutine again calling parent subroutine, u have 1000 lines of code, with out debugging , how can u find that error??? Is there any command to find errors in pgm???
If record-format name in an externally-described file has already been defined as a file-name.how to solve this?
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
if there is pf in two libraries and there is a logical file based on the PF, how to find the pf on which the pf is based.
Anybody know the difference of primary file and full procedural file