HP3000-L Archives

October 2017, 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: [EXTERNAL] [HP3000-L] KSAMXL questions
From:
"Santucci, Patrick" <[log in to unmask]>
Reply To:
Santucci, Patrick
Date:
Thu, 5 Oct 2017 17:11:41 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (91 lines) 
Weird...

 82 + 83 = 165
 83 + 83 = 166

166 + 82 = 248
166 + 83 = 249

249 + 82 = 331
249 + 83 = 332

332 + 82 = 414
332 + 83 = 415

...

What are in records 82 and 83? And why the repeating pattern?

Patrick
________________________________________________
Patrick Santucci 
Oracle Database Administrator 
CBI - A Division of HSNi

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of James B. Byrne
Sent: Thursday, October 05, 2017 12:51
To: [log in to unmask]
Subject: [EXTERNAL] [HP3000-L] KSAMXL questions

*************************************************************************
This email is from an external sender.  If you think it is malicious or spam, please do not open any attachments or links and forward to [log in to unmask]                     
                                                                         
*************************************************************************

As reported earlier I am having some difficulty with extracting data
from a KSAMXL file using QTP.  Eventually I gave up trying to fix the
problem in the existing RUN and extracted the problem REQUEST code
into its own script.  However, this has not solved the problem
although it has changed the symptoms.

When I run this request in its own stand-alone QTP RUN:

REQUEST FOUR-NOTES ON CALCULATION ERRORS REPORT

ACCESS AC-NOTES ALIAS AN

DEFINE QPD-N-DTECR CHAR SIZE 8 = ASCII(DATE-CREATED OF AN,8)

DEFINE QPD-N-TMECR CHAR SIZE 6 = ASCII(TIME-CREATED OF AN,6)

SUBFILE QPCSVAN1 NODICTIONARY KEEP PORTABLE NOAPPEND SIZE 35000     &
     INCLUDE                                                        &
             QUOTE,                                                 &
             NOTE-TYPE OF AN,                                       &
             QDELIMQ,                                               &
             NOTE-CHAR-KEY OF AN,                                   &
             QDELIMQ,                                               &
             TEXT OF AN,                                            &
             QDELIMQ,                                               &
             USER-ID OF AN,                                         &
             QDELIMQ,                                               &
             GROUP-ID OF AN,                                        &
             QDELIMQ,                                               &
             QPD-N-DTECR,                                           &
             QDELIMQ,                                               &
             QPD-N-TMECR,                                           &
             QUOTE

I get blank lines in the subfile at records 82, 83, 165, 166, 248,
249, 331, 332, 414, 415, . . .

Any ideas as to why this is happening?

-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[log in to unmask]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

* 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