IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
  • 1.  How to connect to mainframe system to read input data from WTX?

    Posted Thu August 07, 2008 11:14 AM

    Originally posted by: muralee


    Hi,

    i have tried to connect to mainframe server through FTP adapter and used the following command

    -T FTP://username:password@hostname:port://data set location

    i have used mainframe credentials to connect.
    Please let me know, is this the only way to connect to mainframe or we have any other options.

    i am facing source not available error while connecting.

    Please help me out.

    Thanks
    Murali
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Thu August 07, 2008 01:09 PM

    Originally posted by: SystemAdmin


    Murali,

    I don't know how to help you with the FTP adapter ... we don't use it here. But, I see that you've got the -T option set on your command. That should have generated a trace with more data available for the users here to help you troubleshoot your problem. Look through that trace file, and see if it gives you information telling why the "source not available" was reported.

    That error ("source not available") is a very generic error that WTX uses to report many, many types of problems on many, many types of adapters. It could be that the address to your resource is incorrect, you don't have permission, there's a break in the network, etc. Using the -T option, or even the -TV (for trace verbose), tells WTX to write a trace file with information specific to the adapter you are using.

    If the trace file doesn't help you figure out what is wrong, post the trace file on the message board, and maybe one of the other developers here will be able to tell what you missed. Many of the folks on here are happy to help (thanks to all who've helped me), but you need to give more information about the problem you're trying to solve.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Thu August 07, 2008 01:22 PM

    Originally posted by: janhess


    Check the ftp adapter documentation. There are a number of command options depending on what you're trying to connect to.
    You don't say what sort of mainframe of what version of WTX you're using.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Fri August 08, 2008 03:53 AM

    Originally posted by: paul.brett


    Hi,
    2 potential errors that I can see here. This should work:

    -T -URL FTP://username:password@hostname:port//datasetlocation

    Paul.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 5.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Fri August 08, 2008 01:17 PM

    Originally posted by: muralee


    Thank you for your reply.

    Is there any adapter to connect to Mainframe system other then FTP adapter?

    If yes, please provide me the information.

    Thanks
    Murali.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 6.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Fri August 08, 2008 03:49 PM

    Originally posted by: janhess


    Why not tell us what the problem is then we may be able to help.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: How to connect to mainframe system to read input data from WTX?

    Posted Fri August 08, 2008 03:52 PM

    Originally posted by: janhess


    Missed a bit.
    Why not tell us what the problem is in more detail then we may be able to help.
    Is the source not available the file you are trying to ftp or the destination? What's in the trace file? What type of mainframe? Do you have permission to the destination? Can you use native ftp ok?
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange