Home > IT Answers > Database > Logical file
Help

Question

  Asked: Jan 9 2008   2:02 PM GMT
  Asked by: Bubbles1

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jan 10 2008  4:08 PM GMT  by ITKE


Latest Contributors: Brooksie18, Znason, Kevleemor


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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and AS/400.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Bubbles1  |   Jan 10 2008  3:29PM GMT

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.