Test on Group Field With Numerics

If you are testing on a group that contains numeric fields, the test must contain the sign byte. The ADABAS Interface passes only one value per numeric field, based on the preferred sign values in ADABAS. A sign value of F is passed for positive numbers and a sign value of D is passed for negative numbers. This sign value reduces the number of calls sent to ADABAS and also eliminates the need for ADABAS to perform any logical sign translation.

For example:

GROUP=GROUP1  ,ALIAS=S1  ,USAGE=A9  ,ACTUAL=A14  ,INDEX=I  ,$
   FIELD=FLD1   ,ALIAS=AA  ,USAGE=A3  ,ACTUAL=A3   ,$
   FIELD=FLD2   ,ALIAS=AB  ,USAGE=P3  ,ACTUAL=P3   ,$
   FIELD=FLD3   ,ALIAS=AC  ,USAGE=A3  ,ACTUAL=A3   ,$

Figure 6-4. A Group Containing Numeric Fields

In a report request, you must include the sign for the P3 field:

WHERE GROUP1 EQ 'ABC/123F/XYZ'

Information Builders