IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Where Claue in XQUERY

    Posted 01/28/04 09:20 PM

    Hi,

    This is question is regarding Accessing ADABAS (in mainframe) File from Mapped Tamino Schema.

    In the ADABAS file there is one field called REQ-NBR (Numeric) but no Descriptors on it. When I try to use following XQUERY it is giving ADABAS RESPONSE Code = 68.

    for $b in input()/AREQDOC
    where $b/REQ-NBR = 1
    return $b

    Error :
    ino:code : INOXME8506
    Adabas response code = 68 for dbid = 185, fnr = 25, command code = S1, additions2 = 0x10000

    My question is is it possible to use a field in WHERE clause which does not have a Descriptor on it. If yes could you please let me know how to do it.

    If I use any other field which has Descriptor on it, in WHERE clause does works.

    Any help is appreciable.

    Thanks
    Roy


    #API-Management
    #Tamino
    #webMethods


  • 2.  RE: Where Claue in XQUERY

    Posted 01/29/04 10:05 AM

    Hello Roy,

    The ‘where’ clause will utilize a descriptor search. You can perform non descriptor searches on the mainframe provided that the NONDES=YES parameter has been set in the ADARUN job (if this parameter has not been set the default is NONDES=YES). I suspect this parameter has been set to NO by the DBA.

    HTH.

    Stuart Fyffe-Collins
    Software AG (UK) Ltd.


    #webMethods
    #API-Management
    #Tamino


  • 3.  RE: Where Claue in XQUERY

    Posted 01/29/04 10:11 PM

    Hi Stuart,

    Thank you very much for the information. I had DBAs turn that feature on and it works now.

    Thanks
    Roy


    #Tamino
    #webMethods
    #API-Management