Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 886
  • Last Modified:

AS400 iSeries Access Unique Index for Windows Access

I would like to use Windows Access 2010 to modify an AS400 Physical File.

The AS400 file has No Key and no combination of fields will create a Unique Key.

I can access the file using iSeries Access using a Linked Table ODBC Connection.

Is there any way to create a logical file on the AS400 with a unique key or
create a psuedo unique key in Windows Access in the link.

Without a unique key the file cannot be updated in Windows Access
0
SCMHC
Asked:
SCMHC
  • 2
1 Solution
 
Jon SnydermanCommented:
You can certainly create a new logical but it will still need some sort of uniqure key for Access to deal with it.  If there is no unique key at all, how do you maintain the records in the file?  Is it a dumping ground for logs or something like that?  Is there a date\time stamp?

Jon
0
 
SCMHCAuthor Commented:
Jon,

Thanks for your help.
The records are service transactions records just added to the end of the file
and there could be exact duplicate services provided.

In my research, I found that even in this type of file there is a Relative Record Number
associated with the record. However you cannot access it unless you create a View.

I worked with IBM and they gave me the following which I got to work.

     create view library/viewname as (select filename.*, rrn(filename) as relnum
     from library/filename)

You also need to set the Commit Mode to  --  Commit immediate (*NONE)
     in the ODBC setup under  --  Server, Advanced

In my case it is slow but works which is all I need.
I am just trying to not have to pay a consultant to Create a special program
for only a few transactions that should be corrected.

Thanks for all your help.
Steve
0
 
SCMHCAuthor Commented:
See notes above, worked with IBM on the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now