Dear Randy,

The error you're getting from Dbaudit is that it is expecting a pattern 
in this case.

SELECT  FIELD * * CUSTGRP-PB-SITEM(1,1,1) < " "

You might want to try and specify the first byte of the field.

I could not find a way to specify specific decimal equivalents, but possibly the above will help narrow it down.

Neil


On 12/5/2013, 6:16 PM, Stanfield, Randy (Carrollton, TX) wrote:
> Looking to find what is creating NULL values when records are being put. Does anyone know of a selection for that?
>
> Suprtool and others allow you to select a value LessThan  a blank        ( custgrp-pb-item < " ")
>
> Don't find anything in the Dbaudit manual.
>
> Option 8.2  ---  DBAUDIT interface----------------  Thu, Dec  5, 2013,  5:05 pm
>
> NM DBAUDIT 3.4.02 (2004/11/29) Copyright 2004, Bradmark.
>    Copyright Robelle Consulting Ltd. 1980-1990
>
> INPUT sfdAU001.log
> L CALLS put
> LIST FIELDS DEVICE+
> SELECT BASE SFDAUX.DATA,MGR
> SELECT DATASET * UNIT-DEFAULTS
> SFDAUX.DATA
> SELECT  FIELD * * CUSTGRP-PB-SITEM < " "
> SFDAUX.DATA
> UNIT-DEFAULTS
>
> Error:  For field > X26, use pattern matching
> SET PAGENUMBERS OFF
> SET ONEPERLINE off
> SET PRESENT keys
> Beware! Values shown MAY NOT be from same records!
> set prologue off
>
>
>
> Randy Stanfield
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *