Solved

AS400 iSeries Access Unique Index for Windows Access

Posted on 2011-02-18
3
842 Views
Last Modified: 2012-05-11
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
Comment
Question by:SCMHC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Expert Comment

by:Jon Snyderman
ID: 34935342
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
 

Accepted Solution

by:
SCMHC earned 0 total points
ID: 34960799
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
 

Author Closing Comment

by:SCMHC
ID: 34995338
See notes above, worked with IBM on the solution
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question