Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

AS400 iSeries Access Unique Index for Windows Access

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
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…

721 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