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:
Re: DBAUDIT question
From:
Neil Armstrong <[log in to unmask]>
Reply To:
Neil Armstrong <[log in to unmask]>
Date:
Fri, 6 Dec 2013 14:04:21 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (72 lines) 
Randy,

Happy to hear. It isn't even my product anymore but figured I would give 
it a shot. :)

Neil

On 12/6/2013, 1:56 PM, Stanfield, Randy (Carrollton, TX) wrote:
> That worked thanks.
>
> I was able to loop through previous weeks image log files and find the program that was creating the problem.
>
>
>
> -----Original Message-----
> From: Neil Armstrong [mailto:[log in to unmask]]
> Sent: Thursday, December 05, 2013 6:49 PM
> To: Stanfield, Randy (Carrollton, TX); [log in to unmask]
> Subject: Re: [HP3000-L] DBAUDIT question
>
> 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 *

ATOM RSS1 RSS2