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.
ASKED: Jan 9, 2008  2:02 PM GMT
UPDATED: March 7, 2010  12:25:30 PM GMT
RELATED QUESTIONS
ITKE
16,745 pts.
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:  Jan 10, 2008  4:08 PM (GMT)  by  ITKE   16,745 pts.
Latest Answer Wiki Contributors:  Brooksie18   60 pts., Znason   460 pts., Kevleemor   605 pts.
To see other 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
 66,955 pts.