S6BBRULA (Recover TDS Table From Archive) - Selection criteria produce unexpected results.

S6BBRULA (Recover TDS Table From Archive) - Selection criteria produce unexpected results.

book

Article ID: KB0085542

calendar_today

Updated On:

Products Versions
TIBCO Object Service Broker for z/OS -
Not Applicable -

Description

Resolution:
The input to the S6BBRULA utility for parameter selection are not as flexable as they at first appear
Environment:
============
o ObjectStar and Object Sevice Broker on z/OS

Symptoms:
=========
S6BBRULA is used to extract table data from a backup.
There is a SELECT input file that allows selection of particular parameter subsets of the data.
Sometimes the returned data does not seem to match the selection criteria.
Cause:
======
The cause of the problem is that only certain selection criteria is allowed.

Resolution:
===========
If the selection criteria is PARM = X and PARM2 = Y you can have multiple instances of the selection.

If you are using any other criteria, e.g.  PARM1 > X and PARM2 > Y,  you can only specify 1 selection criteria.  If you supply multiples then the results are unpredictable.

This information will be added to the documentation.

Issue/Introduction

S6BBRULA (Recover TDS Table From Archive) - Selection criteria produce unexpected results.