HP3000-L Archives

December 2013, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
DBAUDIT question
From:
"Stanfield, Randy (Carrollton, TX)" <[log in to unmask]>
Reply To:
Stanfield, Randy (Carrollton, TX)
Date:
Thu, 5 Dec 2013 23:16:53 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (45 lines) 
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 *

ATOM RSS1 RSS2