Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

AS400 iSeries Access Unique Index for Windows Access

Posted on 2011-02-18
3
Medium Priority
?
853 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
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

783 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