Where Claue in XQUERY

, ,
1

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

2

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.

3

Hi Stuart,

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

Thanks
Roy