making rpc connection to as/400

Posted on 2007-09-29
Last Modified: 2008-01-09
We have some images which are  are stored on optical platters, Currently we access them using a 3rd party application  which requires ISeries to access the AS400 (I don't know how the application makes the call to the optical drive).

We need to migrate from this 3rd party application to browser base solution
The indexes are created manually by our Scanning Department. The indexes live on the AS400. Here is the description of the process from our AS400 programmer...

The keyword file (TMM0300) will give you the object ID. Use that to go to the link file (TMM0310). That will give you the document id (aka internal object ID). Use that to get to the document file (TMM0320). That will give you data about the document including the volume and optical path the document resides on.

How do I make a connection from my windows'web server" to the As/400 to retrieve the images ?


Question by:royalcyber
    LVL 13

    Expert Comment

    Hi royalcyber

    What format are the images stored in?
    What 3rd party application are the users running to view the images?

    For example, stored fax images can be viewed by using the AFP viewer in client access. Migrating to a new platform would be a matter of launching the same app. Those other tables are used to map your search criteria to a specific file location.


    LVL 26

    Accepted Solution


    The description from your programmer leaves much of the useful info out.

    For example, there's no info on whether the relationships are DB2 relationships or they're programmatic relationships. This part -- "link file (TMM0310)" -- makes it sound as if DataLinks are used; are they? ...or is it some unknown coding that the app uses to get to the next step? This part -- "document id (aka internal object ID)" -- almost sounds as if DLO names are converted to system object names; is that involved? This part -- "document file (TMM0320)" -- well, I'm not clear at all on what that does, though I suspect it might be a consequence of perhaps a many-to-many relationship earlier in the chain; otherwise, it seems to be an unnecessary layer.

    And "volume and optical path the document resides on" -- is this something like the 3995 optical juke-box? Is this all built over DLO processing?

    In general, the questions come down to whether or not an image can be retrieved by an SQL statement. I've seen DLO-based imaging that had no reasonable SQL access.

    LVL 26

    Expert Comment


    I'm now not clear on why this is marked as solved. Is there no additional info available? or did the resolution suggest itself during research? More help is available if the environment info can be filled in.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
    In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now