IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only

  • 1.  reg database adapter

    Posted 09/18/08 01:12 AM

    Originally posted by: SystemAdmin


    i am running a map (wtx 8.1) having d/b adapter as ip on windows. In the .mdq , i have specified the adaper type as ORACLE. The connect string is blank & uname & pwd are given.
    In the map in the input card i am giving the following settings:
    -MDQ abc.mdq -DBNAME pqr -DBTYPE ORACLE -CONNECT xyz -QUERY zzz -T.
    when i run the map on windows , it runs fine & completes successfully.

    When the same map is run on a unix box , it now throws the error as:
    "Source not available" , Database type is unknown

    I am unable to find the exact cause of why the map is not reading the d/b table at its input on .aix box where as it runs on windows.

    thanks in advance...
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: reg database adapter

    Posted 09/18/08 03:15 AM

    Originally posted by: paul.brett


    Hi,

    It looks like you are using a mixtuer of connection optiosn that are not compatible

    Use either :

    -MDQ abc.mdq -DBNAME pqr
    or
    -DBTYPE ORACLE -CONNECT xyz

    ....not both.

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


Related Content