Home > IT Answers > Database > Logical file
Bubbles1
20 pts.
 Logical file
Database issues, iSeries, Logical File
I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just append the records.

Software/Hardware used:
ASKED: January 9, 2008  2:02 PM
UPDATED: March 7, 2010  12:25 PM
RELATED QUESTIONS
Answer Wiki:
A logical file does not contain data itself. It is only a view of the physical file it is built over. The physical file itself has the data or duplicate records. Kevin You do not have Key constraints on the PF or a LF on those columns.
Last Wiki Answer Submitted:  January 10, 2008  4:08 pm  by  Brooksie18   60 pts.
All Answer Wiki Contributors:  Brooksie18   60 pts. , Znason   460 pts. , kevleemor   605 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

File DDS..
A R ASTFMT PFILE(DBAMAST)
A K DASTLCTNNM
A S DASTDVSN COMP(EQ ‘CUST’)
A DASTASSTYP VALUES(‘DLA’ ‘SOFT’)

Worked when created with a user profile with higher security.

Bubbles1
 20 pts.
 

Then it quite possibly used authority to access a different DBAMAST.

Tom

TomLiotta
 108,215 pts.