Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    14

    Unanswered: Accessing distributed systems from the mainframe

    Like a lot of folks, our applications where built in metaphoric "silos". We have spent a good deal of time trying to make data accessible from one silo to the next. I feel that I am close to accomplishing that goal, but I am not quite there yet.

    I can run a SPUFI command from my OS/390 session and access data on Windows servers (accomplished by
    a) adding the appropriate entry to SYSIBM.IPNAMES,
    b) adding the appropriate entry to SYSIBM.LOCATIONS,
    c) binding DSNESPCS.DSNESM68 to that location
    d) changing the "LOCATION" in SPUFI
    e) running the select query via SPUFI

    I am happy with those results, but I need to be able to automate this procedure. Running SELECT NAME FROM LOCATION.SYSIBM.SYSTABLES through the plan DSNTEP71 results in a RC=12, but no more information than that. There is no DB2-related code to research, so I am stuck.

    What am I missing?

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by bigal21
    Running SELECT NAME FROM LOCATION.SYSIBM.SYSTABLES through the plan DSNTEP71 results in a RC=12
    Maybe issuing the SELECT from within a COBOL program (as static SQL) works?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Mar 2006
    Posts
    14
    COBOL is not my forte, but that may be an option for my developers. I'll get back to you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •