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
Solved

AS400 iSeries Access Unique Index for Windows Access

Posted on 2011-02-18
3
837 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

I was asked if I could set up a fax machine so that incoming faxes were delivered to people's Exchange inboxes and so that they could send faxes from their desktops without needing to print the document first.  I knew it was possible but I had no id…
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 …
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

808 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