ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

export M/S Access DB to Iseries PF

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    export M/S Access DB to Iseries PF

    Im trying to export a MS access data base to a ISeries Pf that exists. I have journelled the PF.
    I select export then i select ODBC database.
    It then asks me export to what file, so i enter in the PF.
    I then create a new data source
    selecting ISeries Access ODBC Driver
    Then get the error saying.
    ODBC --call failed
    [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0601 - PCDLAD00 in P1857DEV type *FILE already exists. (#-601)

    Now if i try all this again and select a file that doesn't exist.
    I get the following.
    ODBC --call failed
    [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - PCDLAD01 in P1857DEV not valid for operation. (#-67008)

    Any tips on transfering this file from Access to a PF on an ISeries.
    This file has 24 fields with a length of 400 and is keyed.
    The reason Im using Access is the file contains 1.8 million records to large fo XL.
    cheers
    Tags: None
  • #2
    Re: export M/S Access DB to Iseries PF

    Ive never tried to upload an access file to the iseries directly....I would think its full
    of proprietary Microsoft secret codes and symbols....

    can you use wordpad with comma seperated fields and upload this to the IFS / iseries
    I dont believe workpad (.txt) has the same limitations as excel.


    jamie
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

    Comment

    • #3
      Re: export M/S Access DB to Iseries PF

      r ha then use CPYFRMIMPF to copy to PF?

      Cheers

      Comment

      • #4
        Re: export M/S Access DB to Iseries PF

        should work! please let us know.
        All my answers were extracted from the "Big Dummy's Guide to the As400"
        and I take no responsibility for any of them.

        www.code400.com

        Comment

        • #5
          Re: export M/S Access DB to Iseries PF

          From the top of my head I seem to recall that you have to create the Data Source as a System DSN and check the Read/Write radio button as shown on the below picture. Not sure but it's at least worth giving a try. For some unknown M$ reasons, another type of DSN wouldn't work.

          Philippe

          Comment

          • #6
            Re: export M/S Access DB to Iseries PF

            used CPYFRMIMPF and after a bit of mucking around got it to work fine
            So copying over 1.8 million records now.

            cheers
            scott

            Comment

            • #7
              Re: export M/S Access DB to Iseries PF

              Scott,
              I've tested using MS.Access 2000 and the method shown in my previous post made me sure that it's working well.
              BTW it is recommended but not essential to create the PF first as the ODBC driver creates the file layout for you.
              Last edited by Mercury; November 9, 2007, 06:56 AM.
              Philippe

              Comment

              Previous template Next
              Working...
              X